Recordset is empty
SELECT, lac.title, lac.body1, lac.body2, COALESCE(c.valid_from, c.posted) AS valid_from, c.content_type_id, AS catid, COALESCE(la.title,cc.title) AS category, GROUP_CONCAT(DISTINCT cc.title SEPARATOR ',') AS categories, COALESCE(la.url, cc.url) AS katurl, ct.kwd AS ctkwd, ct.url, ct.table_name, GROUP_CONCAT(DISTINCT SEPARATOR ',') AS category_ids FROM t_contents AS c LEFT JOIN t_content_types AS ct ON LEFT JOIN t_contents_in_categories AS cic ON AND c.content_type_id=cic.content_type_id LEFT JOIN t_content_categories AS cc ON LEFT JOIN t_locale_additional AS la ON (la.table_name='content_categories' AND AND la.lang_id='1') LEFT JOIN t_locale_additional AS lac ON (lac.table_name='contents' AND AND lac.lang_id='1') WHERE c.is_visible=1 AND c.content_type_id='8' GROUP BY ORDER BY COALESCE(c.valid_from, c.posted) DESC, DESC LIMIT 20,10