Весь список

2026

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 'WHERE IFNULL(ss.icont_text,0)<>1 AND t.icont_var='title' AND (p.icont_tex' at line 19 at /home/shef/isras.ru/html/site_template/cmpl_tmp/science.html.php line 164

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 'WHERE IFNULL(ss.icont_text,0)<>1 AND t.icont_var='title' AND 
				  (p.icont_tex' at line 19
    [query] => SELECT t.icont_text AS title,SUBSTRING(d.icont_text,1,10) AS date,
                  IFNULL(dd.icont_text,SUBSTRING(d.icont_text,1,10)) AS dates, 
				  o.icont_text AS org,IFNULL(f.icont_text,'') AS full,
                   r.icont_text AS prev_text,l.icont_text AS link,
                  p.icont_text AS people,k.icont_text AS doclad, t.el_id AS id,pgm.icont_text AS pgm  				   
                  FROM adm_ilines_content AS t
				  INNER JOIN adm_ilines_element AS e ON e.el_id=t.el_id AND e.itype_id=49 
				  INNER JOIN adm_ilines_content AS d ON d.el_id=t.el_id AND d.icont_var='date'
				  INNER JOIN adm_ilines_content AS dd ON dd.el_id=t.el_id AND dd.icont_var='dates'
				  INNER JOIN adm_ilines_content AS l ON l.el_id=t.el_id AND l.icont_var='link'
				  INNER JOIN adm_ilines_content AS o ON o.el_id=t.el_id AND o.icont_var='org'
				  INNER JOIN adm_ilines_content AS r ON r.el_id=t.el_id AND r.icont_var='prev_text'
				  INNER JOIN adm_ilines_content AS p ON p.el_id=t.el_id AND p.icont_var='people'
				  INNER JOIN adm_ilines_content AS k ON k.el_id=t.el_id AND k.icont_var='doclad'
				  INNER JOIN adm_ilines_content AS s ON s.el_id=t.el_id AND s.icont_var='status' AND s.icont_text=1
				  LEFT OUTER JOIN adm_ilines_content AS ss ON ss.el_id=t.el_id AND ss.icont_var='status2' 
				  LEFT OUTER JOIN adm_ilines_content AS f ON f.el_id=t.el_id AND f.icont_var='full_text'
				   LEFT OUTER JOIN adm_ilines_content AS pgm ON pgm.el_id=t.el_id AND pgm.icont_var='pgm'
				  WHERE WHERE IFNULL(ss.icont_text,0)<>1 AND t.icont_var='title' AND 
				  (p.icont_text LIKE '2430
%' OR p.icont_text LIKE '%
2430
%')  ORDER BY SUBSTRING(d.icont_text,1,10) DESC,t.icont_text ASC,k.icont_text DESC
    [context] => /home/shef/isras.ru/html/site_template/cmpl_tmp/science.html.php line 164
)