{"content":"\n\n\n\n\n\n\n\n\n","results":{"response":{"docs":[],"numFound":0,"start":0}},"facets":[],"pluginName":"Displayresult","query":" select * from (select 'tx_news_domain_model_news' as type,'2' as content_element_id,uid,t3ver_label,hidden,deleted,starttime,endtime,(SELECT concat(',',concat(GROUP_CONCAT(distinct category.uid SEPARATOR ','),',')) FROM `sys_category` category left join sys_category_record_mm on category.uid = uid_local where sys_category_record_mm.uid_foreign = tx_news_domain_model_news.uid and tablenames ='tx_news_domain_model_news') as category_stringM,crdate,tstamp,teaser,title,bodytext,datetime,istopnews,cim_news_start_date,cim_news_end_date,pid,archive,map_longitude,map_latitude, '' as cim_base_desc_page, '' as description, '' as private_element, '' as type_element,(SELECT GROUP_CONCAT(distinct sys_file.identifier SEPARATOR ',') FROM `sys_file_reference` inner join sys_file on sys_file_reference.uid_local=sys_file.uid where tablenames = 'tx_news_domain_model_news' and fieldname = 'fal_media' and tx_news_domain_model_news.uid = uid_foreign and sys_file_reference.deleted = 0 and sys_file_reference.hidden = 0 ) as media, '' as address, '' as telephone, '' as permanences, '' as website, '' as schedule, '' as kml_file,mapgenerator_value, '' as link, '' as libelle, '' as reponse, '' as budget, '' as email, '' as element, '' as item_uid, '' as fe_user, '' as contributes, '' as experts, '' as town_delegation, '' as urban_area_delegation, '' as doktype,(SELECT a.map_latitude FROM `tx_news_domain_model_news` n inner join tx_cimassociation_domain_model_association a on a.uid=n.cim_news_place where a.deleted = 0 and a.hidden = 0 and n.uid = tx_news_domain_model_news.uid) as news_place_lat,(SELECT a.map_longitude FROM `tx_news_domain_model_news` n inner join tx_cimassociation_domain_model_association a on a.uid=n.cim_news_place where a.deleted = 0 and a.hidden = 0 and n.uid = tx_news_domain_model_news.uid) as news_place_lon, '' as logo, '' as start_date, '' as end_date, '' as themes, '' as classifications, '' as nb_votes_1, '' as nb_votes_2, '' as nb_votes_3,sorting from tx_news_domain_model_news) as tableElement where 1=1 and t3ver_label = '' and hidden = 0 and deleted = 0 and starttime<=1591235739 AND (endtime=0 OR endtime>1591235739) and pid IN (10) AND archive < UNIX_TIMESTAMP() and archive <> 0 ORDER BY cim_news_start_date asc LIMIT 0, 20"}