Институт социологии
Федерального научно-исследовательского социологического центра
Российской академии наук

Сектор социологии профессий и профессиональных групп

Список публикаций
список публикаций института   |    расширенный поиск публикаций

>> О подразделении


2020 | 2019 | 2018 | 2017 | 2016 | 2015 | 2014 | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1997 | 1996 |
Query failed 1 SELECT DISTINCT * FROM ( (SELECT 'mag' as 'type',c.page_id,c.cv_text AS name,m.cv_text as name2, t.cv_text AS avtor, y.cv_text AS year, '*' as visible,' ' AS full FROM adm_pages_content AS c INNER JOIN adm_pages_content AS t ON t.page_id=c.page_id AND t.cv_name='title' INNER JOIN adm_pages_content AS y ON y.page_id=c.page_id AND y.cv_name='year' INNER JOIN adm_pages_content AS m ON m.page_id=c.page_id AND m.cv_name='month' INNER JOIN adm_pages AS pp ON pp.page_id=c.page_id AND pp.page_status=1 WHERE c.cv_name='content' AND ((pp.page_parent=596 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=577 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=579 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=580 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=581 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=582 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=584 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=989 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1224 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1360 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1225 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1508 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1659 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=1799 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=2205 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=2354 AND y.cv_text=2013 AND y.cv_text<2014) OR (pp.page_parent=887 AND y.cv_text=2013 AND y.cv_text<1990) OR (pp.page_parent=1837 AND y.cv_text=2013 AND y.cv_text<1900) OR (pp.page_parent=1698 AND y.cv_text=2013 AND y.cv_text<1900) OR (pp.page_parent=637 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=784 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=982 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=1344 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=1506 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=1649 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=1786 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=2185 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=2357 AND y.cv_text=2013 AND y.cv_text<2013) OR (pp.page_parent=826 AND y.cv_text=2013 AND y.cv_text<1900) OR (pp.page_parent=921 AND y.cv_text=2013 AND y.cv_text<1900) OR (pp.page_parent=1090 AND y.cv_text=2013 AND y.cv_text<2020) OR (pp.page_parent=247 AND y.cv_text=2013 AND y.cv_text<2020)) AND (c.cv_text LIKE '%Мансуров%' OR c.cv_text LIKE '%Семенова%' OR c.cv_text LIKE '%Юрченко%' OR c.cv_text LIKE '%Епихина%' OR c.cv_text LIKE '%Ермолаева%' OR c.cv_text LIKE '%Юрьев%' OR c.cv_text LIKE '%Колесникова%' OR c.cv_text LIKE '%Иванова%' OR c.cv_text LIKE '%Ануфриева%' OR c.cv_text LIKE '%Шатрова%' OR c.cv_text LIKE '%Рыбакова%' OR c.cv_text LIKE '%Мамонова%')) UNION ALL ( SELECT 'publ' AS 'type', id AS page_id,name,name2,avtor,year,`as` AS visible,link AS full FROM `publ` WHERE IFNULL(imp,0)<>'on' AND publ.status=1 AND ( avtor LIKE '164
%' OR avtor LIKE '%
164
%' OR avtor LIKE '324
%' OR avtor LIKE '%
324
%' OR avtor LIKE '307
%' OR avtor LIKE '%
307
%' OR avtor LIKE '163
%' OR avtor LIKE '%
163
%' OR avtor LIKE '517
%' OR avtor LIKE '%
517
%' OR avtor LIKE '526
%' OR avtor LIKE '%
526
%' OR avtor LIKE '646
%' OR avtor LIKE '%
646
%' OR avtor LIKE '656
%' OR avtor LIKE '%
656
%' OR avtor LIKE '1843
%' OR avtor LIKE '%
1843
%' OR avtor LIKE '1417
%' OR avtor LIKE '%
1417
%' OR avtor LIKE '2172
%' OR avtor LIKE '%
2172
%' OR avtor LIKE '2252
%' OR avtor LIKE '%
2252
%') AND year=2013 ) UNION ALL ( SELECT 'v' AS 'type',page_id,adm_article.name,CONCAT(' // ',j_name,'. ',year,'. № ',number) AS name2, people AS avtor,year,'*' AS visible,'' AS full FROM vestnik.`adm_article` WHERE ( people LIKE '164
%' OR people LIKE '%
164
%' OR people LIKE '324
%' OR people LIKE '%
324
%' OR people LIKE '307
%' OR people LIKE '%
307
%' OR people LIKE '163
%' OR people LIKE '%
163
%' OR people LIKE '517
%' OR people LIKE '%
517
%' OR people LIKE '526
%' OR people LIKE '%
526
%' OR people LIKE '646
%' OR people LIKE '%
646
%' OR people LIKE '656
%' OR people LIKE '%
656
%' OR people LIKE '1843
%' OR people LIKE '%
1843
%' OR people LIKE '1417
%' OR people LIKE '%
1417
%' OR people LIKE '2172
%' OR people LIKE '%
2172
%' OR people LIKE '2252
%' OR people LIKE '%
2252
%') AND date_public <> '' AND year=2013) UNION ALL ( SELECT 'socis' AS 'type',page_id,a.name,CONCAT(' // ',j_name,'. ',year,'. № ',number) AS name2, people AS avtor,year,'*' AS visible,'' AS full FROM socis.persona INNER JOIN socis.`adm_article` AS a ON a.people LIKE CONCAT(persona.id,'
%') OR a.people LIKE CONCAT('%
',persona.id,'
%') WHERE ((persona.surname='Мансуров' AND persona.name='Валерий' AND persona.fname='Андреевич') OR (persona.surname='Семенова' AND persona.name='Анна' AND persona.fname='Валерьевна') OR (persona.surname='Юрченко' AND persona.name='Олеся' AND persona.fname='Викторовна') OR (persona.surname='Епихина' AND persona.name='Юлия' AND persona.fname='Борисовна') OR (persona.surname='Ермолаева' AND persona.name='Юлия' AND persona.fname='Вячеславовна') OR (persona.surname='Юрьев' AND persona.name='Павел' AND persona.fname='Сергеевич') OR (persona.surname='Колесникова' AND persona.name='Елена' AND persona.fname='Михайловна') OR (persona.surname='Иванова' AND persona.name='Елена' AND persona.fname='Юрьевна') OR (persona.surname='Ануфриева' AND persona.name='Ирина' AND persona.fname='Викторовна') OR (persona.surname='Шатрова' AND persona.name='Елена' AND persona.fname='Александровна') OR (persona.surname='Рыбакова' AND persona.name='Марина' AND persona.fname='Владимировна') OR (persona.surname='Мамонова' AND persona.name='Ольга' AND persona.fname='Николаевна')) AND year=2013) UNION ( SELECT 'ojs' AS 'type',a.article_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',i.number,'. С. ',a.pages) AS name2, CONCAT(IFNULL(au1.setting_value,au.last_name),' ',SUBSTRING(IFNULL(au2.setting_value,au.first_name),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,au.middle_name),1,1),'.') AS avtor, i.year,'*' AS visible,'' AS full FROM ojs3.authors AS au LEFT OUTER JOIN ojs3.author_settings AS au1 ON au1.author_id=au.author_id AND au1.setting_name='last_name' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3.author_settings AS au2 ON au2.author_id=au.author_id AND au2.setting_name='first_name' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3.author_settings AS au3 ON au3.author_id=au.author_id AND au3.setting_name='middle_name' AND au3.locale='ru_RU' INNER JOIN ojs3.submission_settings AS aa ON au.submission_id=aa.article_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3.submissions AS a ON aa.article_id =a.article_id INNER JOIN ojs3.journal_settings AS j ON j.journal_id=a.journal_id AND j.setting_name='name' AND j.locale='ru_RU' INNER JOIN ojs3.`published_articles`AS p ON p.article_id=a.article_id INNER JOIN ojs3.issues AS i ON i.issue_id=p.issue_id LEFT OUTER JOIN ojs3.submission_files AS f ON f.file_id=a.submission_file_id WHERE a.status=3 AND (IFNULL(au1.setting_value,au.last_name)='Мансуров' AND IFNULL(au2.setting_value,au.first_name)='Валерий' AND IFNULL(au3.setting_value,au.middle_name)='Андреевич' OR IFNULL(au1.setting_value,au.last_name)='Семенова' AND IFNULL(au2.setting_value,au.first_name)='Анна' AND IFNULL(au3.setting_value,au.middle_name)='Валерьевна' OR IFNULL(au1.setting_value,au.last_name)='Юрченко' AND IFNULL(au2.setting_value,au.first_name)='Олеся' AND IFNULL(au3.setting_value,au.middle_name)='Викторовна' OR IFNULL(au1.setting_value,au.last_name)='Епихина' AND IFNULL(au2.setting_value,au.first_name)='Юлия' AND IFNULL(au3.setting_value,au.middle_name)='Борисовна' OR IFNULL(au1.setting_value,au.last_name)='Ермолаева' AND IFNULL(au2.setting_value,au.first_name)='Юлия' AND IFNULL(au3.setting_value,au.middle_name)='Вячеславовна' OR IFNULL(au1.setting_value,au.last_name)='Юрьев' AND IFNULL(au2.setting_value,au.first_name)='Павел' AND IFNULL(au3.setting_value,au.middle_name)='Сергеевич' OR IFNULL(au1.setting_value,au.last_name)='Колесникова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Михайловна' OR IFNULL(au1.setting_value,au.last_name)='Иванова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Юрьевна' OR IFNULL(au1.setting_value,au.last_name)='Ануфриева' AND IFNULL(au2.setting_value,au.first_name)='Ирина' AND IFNULL(au3.setting_value,au.middle_name)='Викторовна' OR IFNULL(au1.setting_value,au.last_name)='Шатрова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Александровна' OR IFNULL(au1.setting_value,au.last_name)='Рыбакова' AND IFNULL(au2.setting_value,au.first_name)='Марина' AND IFNULL(au3.setting_value,au.middle_name)='Владимировна' OR IFNULL(au1.setting_value,au.last_name)='Мамонова' AND IFNULL(au2.setting_value,au.first_name)='Ольга' AND IFNULL(au3.setting_value,au.middle_name)='Николаевна') AND i.year=2013 AND i.journal_id<>7 ) UNION ( SELECT 'ojs' AS 'type',a.article_id AS page_id,aa.setting_value AS name, CONCAT(' // ',j.setting_value,'. ',i.year,'. № ',i.number,'. С. ',a.pages) AS name2, CONCAT(IFNULL(au1.setting_value,au.last_name),' ',SUBSTRING(IFNULL(au2.setting_value,au.first_name),1,1),'. ', SUBSTRING(IFNULL(au3.setting_value,au.middle_name),1,1),'.') AS avtor, i.year,'*' AS visible,'' AS full FROM ojs3_inter.authors AS au LEFT OUTER JOIN ojs3_inter.author_settings AS au1 ON au1.author_id=au.submission_id AND au1.setting_name='last_name' AND au1.locale='ru_RU' LEFT OUTER JOIN ojs3_inter.author_settings AS au2 ON au2.author_id=au.submission_id AND au2.setting_name='first_name' AND au2.locale='ru_RU' LEFT OUTER JOIN ojs3_inter.author_settings AS au3 ON au3.author_id=au.submission_id AND au3.setting_name='middle_name' AND au3.locale='ru_RU' INNER JOIN ojs3_inter.submission_settings AS aa ON au.submission_id=aa.submission_id AND aa.setting_name='title' AND aa.locale='ru_RU' INNER JOIN ojs3_inter.submissions AS a ON aa.article_id =a.article_id INNER JOIN ojs3_inter.journal_settings AS j ON j.journal_id=a.journal_id AND j.setting_name='name' AND j.locale='ru_RU' INNER JOIN ojs3_inter.`published_articles`AS p ON p.article_id=a.article_id INNER JOIN ojs3_inter.issues AS i ON i.issue_id=p.issue_id LEFT OUTER JOIN ojs3_inter.submission_files AS f ON f.file_id=a.submission_file_id WHERE a.status=3 AND (IFNULL(au1.setting_value,au.last_name)='Мансуров' AND IFNULL(au2.setting_value,au.first_name)='Валерий' AND IFNULL(au3.setting_value,au.middle_name)='Андреевич' OR IFNULL(au1.setting_value,au.last_name)='Семенова' AND IFNULL(au2.setting_value,au.first_name)='Анна' AND IFNULL(au3.setting_value,au.middle_name)='Валерьевна' OR IFNULL(au1.setting_value,au.last_name)='Юрченко' AND IFNULL(au2.setting_value,au.first_name)='Олеся' AND IFNULL(au3.setting_value,au.middle_name)='Викторовна' OR IFNULL(au1.setting_value,au.last_name)='Епихина' AND IFNULL(au2.setting_value,au.first_name)='Юлия' AND IFNULL(au3.setting_value,au.middle_name)='Борисовна' OR IFNULL(au1.setting_value,au.last_name)='Ермолаева' AND IFNULL(au2.setting_value,au.first_name)='Юлия' AND IFNULL(au3.setting_value,au.middle_name)='Вячеславовна' OR IFNULL(au1.setting_value,au.last_name)='Юрьев' AND IFNULL(au2.setting_value,au.first_name)='Павел' AND IFNULL(au3.setting_value,au.middle_name)='Сергеевич' OR IFNULL(au1.setting_value,au.last_name)='Колесникова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Михайловна' OR IFNULL(au1.setting_value,au.last_name)='Иванова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Юрьевна' OR IFNULL(au1.setting_value,au.last_name)='Ануфриева' AND IFNULL(au2.setting_value,au.first_name)='Ирина' AND IFNULL(au3.setting_value,au.middle_name)='Викторовна' OR IFNULL(au1.setting_value,au.last_name)='Шатрова' AND IFNULL(au2.setting_value,au.first_name)='Елена' AND IFNULL(au3.setting_value,au.middle_name)='Александровна' OR IFNULL(au1.setting_value,au.last_name)='Рыбакова' AND IFNULL(au2.setting_value,au.first_name)='Марина' AND IFNULL(au3.setting_value,au.middle_name)='Владимировна' OR IFNULL(au1.setting_value,au.last_name)='Мамонова' AND IFNULL(au2.setting_value,au.first_name)='Ольга' AND IFNULL(au3.setting_value,au.middle_name)='Николаевна') AND i.year=2013 AND i.journal_id=7 ) ) AS z ORDER BY z.YEAR desc, z.name asc