Институт социологии
Российской академии наук

Сводка новостей






Страницы:   предыдущая  ←    1  2  3  4  5  6  7  8  9  10  11  12  13    → следующая    


SQL Error: at /home/shef/isras.ru/html/dreamedit/includes/class.Events.php line 206
Array
(
    [code] => 0
    [message] => 
    [query] => SELECT DISTINCT * FROM
			(SELECT  DISTINCT 'a' as REC,'1' AS type, ie.el_id AS elid, ie.el_id AS el_id,ie.itype_id,
				IF((ie.itype_id=2 OR ie.itype_id=8)AND id2.icont_text>id.icont_text,id2.icont_text,id.icont_text) AS date,
				IFNULL(id2.icont_text,0) AS date2,'' AS name FROM  isras2015.adm_ilines_element AS ie,  isras2015.adm_ilines_content AS ic INNER JOIN isras2015.adm_ilines_content AS id ON id.el_id=ic.el_id AND (id.icont_var='date' OR id.icont_var='date2' OR id.icont_var='date3' )
			AND date(id.icont_text) >= date('20070101') AND date(id.icont_text) <= date('20181231') LEFT OUTER JOIN isras2015.adm_ilines_content AS id2 ON id2.el_id=ic.el_id AND (id2.icont_var='date2' OR id2.icont_var='date3')INNER JOIN isras2015.adm_ilines_content AS ss ON ss.el_id=ic.el_id AND ss.icont_var='status' AND ss.icont_text=1  LEFT OUTER JOIN isras2015.adm_ilines_content AS s2 ON s2.el_id=ic.el_id AND s2.icont_var='status2'   INNER JOIN isras2015.adm_ilines_element AS e ON e.el_id=ic.el_id WHERE ( ie.itype_id=2 OR  ie.itype_id=3 OR  ie.itype_id=14 OR  ie.itype_id=15 OR  ie.itype_id=16 OR  ie.itype_id=5 OR  ie.itype_id=50 OR  ie.itype_id=49 OR  ie.itype_id=51 OR  ie.itype_id=8) AND ie.el_id = ic.el_id  AND (ic.icont_var  = 'date' OR ic.icont_var='date2') AND ic.icont_text <> '' AND ic.icont_text IS NOT NULL  AND (e.itype_id<> 15 OR s2.icont_text=1)  AND ie.itype_id<>14 AND ie.itype_id<>49 GROUP BY ie.el_id   UNION ALL   SELECT 'b' AS rec,IF(IFNULL(id2.icont_text,'')<>'',2,3) AS type,ie.el_id, ie.el_id AS el_id,ie.itype_id,
			IF(IFNULL(id2.icont_text,'')<>'',id2.icont_text,id3.icont_text) AS date,
			
			IF(IFNULL(id2.icont_text,'')<>'',id2.icont_text,id3.icont_text) AS date2,'' AS name
				FROM isras2015.adm_ilines_element AS ie
				INNER JOIN isras2015.adm_ilines_content AS id ON id.el_id=ie.el_id AND id.icont_var='date'
				LEFT OUTER JOIN isras2015.adm_ilines_content AS id2 ON id2.el_id=ie.el_id AND id2.icont_var='date2'
				INNER JOIN isras2015.adm_ilines_content AS id3 ON id3.el_id=ie.el_id AND id3.icont_var='date3'
				INNER JOIN isras2015.adm_ilines_content AS ss ON ss.el_id=ie.el_id AND ss.icont_var='status' AND ss.icont_text=1
				WHERE ie.itype_id=14 	AND (SUBSTRING(REPLACE(IF(IFNULL(id2.icont_text,'') ='',id3.icont_text,id2.icont_text),'.',''),1,8)) >= ('20070101') 
			    AND (SUBSTRING(REPLACE(IF(IFNULL(id2.icont_text,'') ='',id3.icont_text,id2.icont_text),'.',''),1,8)) <= ('20181231')  GROUP BY ie.el_id  UNION ALL

			SELECT DISTINCT 'c' AS rec,'1' AS type,'0' AS el_id,'0' AS el_id,ie.itype_id,
			d.icont_text AS date,dt.icont_text AS date2,c.icont_text AS name
			FROM isras2015.adm_ilines_element AS ie 
			INNER JOIN isras2015.adm_ilines_content AS c ON c.el_id=ie.el_id AND c.icont_var='title'
			INNER JOIN isras2015.adm_ilines_content AS d ON d.el_id=ie.el_id AND d.icont_var='date'
			INNER JOIN isras2015.adm_ilines_content AS dt ON dt.el_id=ie.el_id AND dt.icont_var='dates' 
			INNER JOIN isras2015.adm_ilines_content AS ss ON ss.el_id=ie.el_id AND ss.icont_var='status' AND ss.icont_text=1
			WHERE (ie.itype_id=49) 	AND REPLACE(d.icont_text,'.','')>=20070101 AND REPLACE(d.icont_text,'.','')<=20181231 GROUP BY c.icont_text  UNION ALL

			SELECT DISTINCT 'd' AS rec,'1' AS type,'0' AS el_id,'0' AS el_id,ie.itype_id,
			d.icont_text AS date,dt.icont_text AS date2,tt.icont_text AS name
			FROM isras2015.adm_ilines_element AS ie 
			INNER JOIN isras2015.adm_ilines_content AS c ON c.el_id=ie.el_id AND c.icont_var='title'
			INNER JOIN isras2015.adm_ilines_content AS d ON d.el_id=ie.el_id AND d.icont_var='date'
			INNER JOIN isras2015.adm_ilines_content AS dt ON dt.el_id=ie.el_id AND dt.icont_var='dates' 
			INNER JOIN isras2015.adm_ilines_content AS tt ON tt.el_id=ie.el_id AND tt.icont_var='prev_text' 
			INNER JOIN isras2015.adm_ilines_content AS ss ON ss.el_id=ie.el_id AND ss.icont_var='status' AND ss.icont_text=1
					WHERE (ie.itype_id=57) 	AND REPLACE(d.icont_text,'.','')>=20070101 AND REPLACE(d.icont_text,'.','')<=20181231 GROUP BY c.icont_text  UNION ALL  SELECT 'pr' AS rec,'1' AS type,'0' AS el_id,ID as elid,'99' AS itype_id, REPLACE(post_date,'-','.') AS date,
				'0' AS date2,post_content AS name FROM gb_cherryfram.wp_posts AS p 
				LEFT OUTER JOIN  gb_cherryfram.wp_postmeta AS pp ON pp.post_id=p.ID AND meta_key='my_team_info' 
					WHERE 
					 IFNULL(meta_value,'')<>'Общество' AND (post_type='testi' OR post_type='post' OR post_type='team') AND post_status='publish'  AND REPLACE(post_date,'-','')>=20070101 AND REPLACE(post_date,'-','')<=20181231	) AS t  ORDER BY IF(date>'2018.07.22',date,99999999) ASC,  IF(date<='2018.07.22',date,'0') DESC  LIMIT 100, 20   
    [context] => /home/shef/isras.ru/html/dreamedit/includes/class.Events.php line 206
)