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 )