SELECT * FROM tc_contents LEFT JOIN content_image ON tc_contents.con_id = content_image.id_content LEFT JOIN tc_image ON content_image.id_image = tc_image.id WHERE content_image.active_thumbnail = 'THUMB' AND con_id = '%E2%80%9C' AND con_lan = 'en' AND con_module = '' GROUP BY tc_contents.con_id ORDER BY tc_contents.con_order DESC