Recordset is empty<br />SELECT c.id, lac.title, lac.body1, lac.body2, COALESCE(c.valid_from, c.posted) AS valid_from, c.content_type_id, cc.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 cc.id SEPARATOR ',') AS category_ids FROM t_contents AS c LEFT JOIN t_content_types AS ct ON c.content_type_id=ct.id LEFT JOIN t_contents_in_categories AS cic ON c.id=cic.content_id AND c.content_type_id=cic.content_type_id LEFT JOIN t_content_categories AS cc ON cic.content_category_id=cc.id LEFT JOIN t_locale_additional AS la ON (la.table_name='content_categories' AND cc.id=la.table_id AND la.lang_id='1') LEFT JOIN t_locale_additional AS lac ON (lac.table_name='contents' AND c.id=lac.table_id AND lac.lang_id='1') WHERE c.is_visible=1 AND c.content_type_id='8' GROUP BY c.id ORDER BY COALESCE(c.valid_from, c.posted) DESC, c.id DESC LIMIT 20,10