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

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 '495
%' OR avtor LIKE '%
495
%')
								  AND (SELECT count(id) FROM isras2015.publ AS p WHERE p.parent_id=publ.id
								 
								 )=0 )
								 
								 OR 
								 (editors like '495
%' OR editors like'%
495
%')
								 ) )  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 '495
%' OR people LIKE '%
495' OR people LIKE '%
495
%')
    		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
)