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

Андреев Иван Андреевич

Ivan A. Andreev



 
v-andreev_07@mail.ru |



Лаборант-исследователь
Центр комплексных социальных исследований

Профиль автора в РИНЦ
>> Список всех упоминаний персоны на сайте


Профили автора

Curriculum Vitae

Ассистент кафедры философии, политологии и социологии, Национальный исследовательский университет «МЭИ», Москва, Россия

SQL Error: at /home/shef/isras.ru/html/dreamedit/includes/class.Magazines.php line 2820
Array
(
    [code] => 0
    [message] => 
    [query] => SELECT * FROM (
	(SELECT DISTINCT '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,' ' AS lang,'' AS doi  FROM isras2015.adm_pages_content AS c  INNER JOIN isras2015.adm_pages_content AS t ON t.page_id=c.page_id AND t.cv_name='title'  INNER JOIN isras2015.adm_pages_content AS y ON y.page_id=c.page_id AND y.cv_name='year' INNER JOIN isras2015.adm_pages_content AS m ON m.page_id=c.page_id AND m.cv_name='month'  INNER JOIN isras2015.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<2014) OR (pp.page_parent=577 AND y.cv_text<2014) OR (pp.page_parent=579 AND y.cv_text<2014) OR (pp.page_parent=580 AND y.cv_text<2014) OR (pp.page_parent=581 AND y.cv_text<2014) OR (pp.page_parent=582 AND y.cv_text<2014) OR (pp.page_parent=584 AND y.cv_text<2014) OR (pp.page_parent=989 AND y.cv_text<2014) OR (pp.page_parent=1224 AND y.cv_text<2014) OR (pp.page_parent=1360 AND y.cv_text<2014) OR (pp.page_parent=1225 AND y.cv_text<2014) OR (pp.page_parent=1508 AND y.cv_text<2014) OR (pp.page_parent=1659 AND y.cv_text<2014) OR (pp.page_parent=1799 AND y.cv_text<2014) OR (pp.page_parent=2205 AND y.cv_text<2014) OR (pp.page_parent=2354 AND y.cv_text<2014) OR (pp.page_parent=887 AND y.cv_text<1990) OR (pp.page_parent=1837 AND y.cv_text<1900) OR (pp.page_parent=1698 AND y.cv_text<1900) OR (pp.page_parent=637 AND y.cv_text<2013) OR (pp.page_parent=784 AND y.cv_text<2013) OR (pp.page_parent=982 AND y.cv_text<2013) OR (pp.page_parent=1344 AND y.cv_text<2013) OR (pp.page_parent=1506 AND y.cv_text<2013) OR (pp.page_parent=1649 AND y.cv_text<2013) OR (pp.page_parent=1786 AND y.cv_text<2013) OR (pp.page_parent=2185 AND y.cv_text<2013) OR (pp.page_parent=2357 AND y.cv_text<2013) OR (pp.page_parent=826 AND y.cv_text<1900) OR (pp.page_parent=921 AND y.cv_text<1900) OR (pp.page_parent=1090 AND y.cv_text<2022) OR (pp.page_parent=247 AND y.cv_text<1900)) 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 '%И Андреев %'  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,IF(substring(name,1,1)<>'«',INTERVAL(191,ASCII(name)),INTERVAL(191,ASCII(substring(name,2)))) as lang, doi  FROM  isras2015.`publ` WHERE IFNULL(imp,0)<>'on' AND  (publ.status=1 OR publ.status2=1) AND  year > 2020 AND  (((avtor LIKE '2346
%' OR avtor LIKE '%
2346
%') AND (SELECT count(id) FROM isras2015.publ AS p WHERE p.parent_id=publ.id )=0 ) OR (editors like '2346
%' OR editors like'%
2346
%') ) ) UNION ALL ( SELECT 'v' AS 'type',page_id,name,CONCAT(' // ',j_name,'. ',year,'. № ',number,', C. ',pages) AS name2, people AS avtor,year,'*' AS visible,'' AS full,' ' AS lang, doi FROM vestnik.`adm_article` WHERE (people LIKE '2346
%' OR people LIKE '%
2346' OR people LIKE '%
2346
%') AND date_public <> '' AND year > 2020) UNION ALL ( SELECT 'socis' AS 'type',a.page_id,a.name,CONCAT(' // ',a.j_name,'. ',a.year,'. № ',a.number,', C. ',a.pages) AS name2, a.people AS avtor,a.year,'*' AS visible,'' AS full,' ' AS lang, doi FROM socis.`adm_article` AS a WHERE date_public <> '' AND year > 2020 AND (a.people LIKE (SELECT CONCAT(id,'
%') FROM socis.persona WHERE (persona.surname='Андреев' OR persona.surname='Андреев' OR persona.surname='Андрёёв' OR persona.surname='') AND persona.name='Иван' AND persona.fname='Андреевич') OR a.people LIKE (SELECT CONCAT('%
',id,'
%') FROM socis.persona WHERE (persona.surname='Андреев' OR persona.surname='Андреев' OR persona.surname='Андрёёв' OR persona.surname='') AND persona.name='Иван' AND persona.fname='Андреевич'))) ) AS z ORDER BY YEAR desc, type desc,lang, name asc [context] => /home/shef/isras.ru/html/dreamedit/includes/class.Magazines.php line 2820 )