Green Jobs in Sociological Theories of Professions // Europe and Beyond: Boundaries, Barriers and Belonging.View from Russia:[Electronic resource]: collected papers European Sociological Association 14th Conference “Europe and Beyond: Boundaries, Barriers and Belonging”(Manchester, GB, Augest 20-24, 2019)/ Editor-in-Chief V. Mansurov. Moscow: RSS; FCTAS RAS. 2019. P. 226-235. 1 CD ROM; 12 sm – system requirements: Windows XP/Vista/7/10 – Title from disk label.

Array
(
    [code] => 0
    [message] => 
    [query] => SELECT publ.*,type.text as tipt,vid.text as vidt,publ.rubric2 AS rubric_id,vid.text,parent.name AS parent_name,parent.picsmall AS parent_pic,publ.sbornik,
		IF(publ.rubric2<>0 OR publ.rubric2d<>0,
        CONCAT(CONCAT('',r.name,''),
		IF(publ.rubric2d<>0,CONCAT('
','',r2.name,''),'')),
		publ.rubric) AS rubric,publ.rinc AS rinclink,publ.dop,publ.EDN,
		(SELECT count(id) FROM isras2015.publ WHERE parent_id=7227) AS count,publ.lang,
		IFNULL(j.name,'') AS jname,IFNULL(j.name2,'') AS jname2,IFNULL(j.lang,'RU') AS jlang 
	          FROM isras2015.publ
          	  INNER JOIN isras2015.type ON type.id=(publ.tip-1)
		      INNER JOIN isras2015.vid ON vid.id=(publ.vid-1)
		      INNER JOIN isras2015.publ_rubric AS r ON r.id=publ.rubric2
              LEFT OUTER JOIN isras2015.publ_rubric AS r2 ON r2.id=publ.rubric2d
			  LEFT OUTER JOIN isras2015.publ AS parent ON parent.id=publ.parent_id AND parent.status=1 
			   LEFT OUTER JOIN rinc_download.journals AS j ON TRIM(j.ISSN)=TRIM(REPLACE(publ.izdat,'ISSN ','') ) AND IFNULL(publ.izdat,'')<>''
                         WHERE publ.id=7227 AND (publ.status=1 OR publ.status2=1)
    [context] => /home/shef/fnisc.ru/html/site_template/cmpl_tmp/1publ.html.php line 165
)