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 '(SELECT * FROM (SELECT a.page_id,a.page_name,a.year,c.cv_text,a.journal,pc.' at line 3 at /home/shef/socis.isras.ru/html/dreamedit/includes/class.Magazine.php line 2106
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 '(SELECT * FROM
					(SELECT a.page_id,a.page_name,a.year,c.cv_text,a.journal,pc.' at line 3
    [query] => SELECT z.*,c1.cv_text AS subject, c3.cv_text AS cover,c4.cv_text AS annots,c5.cv_text AS about,
           c1e.cv_text AS subject_en,c4e.cv_text AS annots_en,c5e.cv_text AS about_en 	   
		   FROM s(SELECT * FROM
					(SELECT a.page_id,a.page_name,a.year,c.cv_text,a.journal,pc.cv_text AS page_summary,p.page_id AS pid,substring(a.j_name,9,(length(j_name)-9))
					      FROM adm_article AS a
					      INNER JOIN adm_article_content AS c ON c.page_id=a.page_id

					      LEFT OUTER JOIN adm_pages AS p ON p.page_template='magazine' AND p.page_name=IF(substring(j_name,1,7)='журнал ',substring(a.j_name,9,(length(j_name)-9)),a.j_name)
					      LEFT OUTER JOIN adm_pages_content AS pc ON pc.page_id=p.page_id AND pc.cv_name='SUMMARY_ID'
						  INNER JOIN adm_article_content AS oo ON oo.page_id=a.page_id AND oo.cv_name='order' AND IFNULL(oo.cv_text,0)<>'1' 
					      WHERE a.page_template='jnumber' AND a.journal=85 AND  a.page_status=1 AND c.cv_name='date_public') AS tt
			 ORDER BY cv_text DESC LIMIT 1) AS z 
			 INNER JOIN adm_article_content AS c1 ON c1.page_id=z.page_id AND c1.cv_name='subject' INNER JOIN adm_article_content AS c1e ON c1e.page_id=z.page_id AND c1e.cv_name='subject_en' INNER JOIN adm_article_content AS c3 ON c3.page_id=z.page_id AND c3.cv_name='icon' INNER JOIN adm_article_content AS c5 ON c5.page_id=z.page_id AND c5.cv_name='about' INNER JOIN adm_article_content AS c4 ON c4.page_id=z.page_id AND c4.cv_name='content' LEFT OUTER JOIN adm_article_content AS c5e ON c5e.page_id=z.page_id AND c5e.cv_name='about_en' LEFT OUTER JOIN adm_article_content AS c4e ON c4e.page_id=z.page_id AND c4e.cv_name='content_en'
    [context] => /home/shef/socis.isras.ru/html/dreamedit/includes/class.Magazine.php line 2106
)