>> Список всех упоминаний персоны на сайте

Curriculum Vitae

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AS z ORDER BY YEAR desc, type desc,lang, name asc' at line 22 at /home/shef/isras.ru/html/dreamedit/includes/class.Magazines.php line 2869

Array
(
    [code] => 1064
    [message] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) AS z   ORDER BY YEAR desc, type desc,lang, name asc' at line 22
    [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<2024) OR (pp.page_parent=247 AND y.cv_text<1900)) AND y.cv_text> 2022 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 > 2022 AND  (((avtor LIKE '167
%' OR avtor LIKE '%
167
%')
								  AND (SELECT count(id) FROM isras2015.publ AS p WHERE p.parent_id=publ.id
								 
								 )=0 )
								 
								 OR 
								 (editors like '167
%' OR editors like'%
167
%')
								 ) )  UNION ALL ( SELECT 'v' AS 'type',page_id,name,CONCAT(' // ',j_name,'. ',year,'. Том ',(year-2010+1),'. № ',
								 (number % 4 +1),'. C. ',pages) AS name2, 
								 people AS avtor,year,'*' AS visible,'' AS full,' ' AS lang, doi 
								 
					    		 FROM vestnik.`adm_article` WHERE
    		(people LIKE '167
%' OR people LIKE '%
167' OR people LIKE '%
167
%')
    		AND date_public <> '' AND  year > 2022) 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 > 2022 AND ) ) AS z   ORDER BY YEAR desc, type desc,lang, name asc 
    [context] => /home/shef/isras.ru/html/dreamedit/includes/class.Magazines.php line 2869
)