Грибов Денис Евгеньевич



SQL Error: at /home/shef/isras.ru/html/site_template/cmpl_tmp/1pers.html.php line 130
Array
(
    [code] => 0
    [message] => 
    [query] => SELECT * FROM (
					SELECT a.*,pp.icont_text AS pers,
					IF(IFNULL(a.verdict,0)=0 AND IFNULL(a.verdict_date,'')='',0,
					IF (IFNULL(a.verdict,0)=0 AND IFNULL(a.verdict_date,'')<>'',2,IFNULL(a.verdict,0))) AS verdict00,a.comment AS comment00,
                    IFNULL(sp.icont_text,0) AS spisok_sort,
                    IFNULL(dirsp.icont_text,a.item_data) AS dirsp,year_end AS year_end00,d.icont_text AS sort   					
					FROM inter2009.profile_data AS a 
					INNER JOIN inter2009.adm_directories_content AS d ON d.el_id=a.item_id AND d.icont_var='sort'
					INNER JOIN inter2009.adm_directories_content AS pp ON pp.el_id=a.type AND pp.icont_var='pers' AND IFNULL(pp.icont_text,'') <>'' 
					
					INNER JOIN inter2009.adm_directories_content AS sp ON sp.el_id=a.item_id AND sp.icont_var='spisok' AND IFNULL(sp.icont_text,'')<>'' 
					LEFT OUTER JOIN inter2009.adm_directories_content AS dirsp ON dirsp.el_id=a.item_data AND dirsp.icont_var='text' 
					WHERE a.fio=1603 AND verdict=1  ORDER BY  	a.type, a.id_record,d.icont_text ) AS z 
				  ORDER BY 
				  verdict00 DESC,
				  z.year_end,type,id_record,sort 
    [context] => /home/shef/isras.ru/html/site_template/cmpl_tmp/1pers.html.php line 130
)