SELECT c.id, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'content_content' AND td.field='title' AND td.doc_id = c.id AND td.language_id = 593), c.title) title, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'content_content' AND td.field='description' AND td.doc_id = c.id AND td.language_id = 593), c.description) description, IFNULL((SELECT text FROM translations_data td WHERE td.group_name = 'content_content' AND td.field='html' AND td.doc_id = c.id AND td.language_id = 593), c.html) html, DATE_FORMAT(c.date, '%e/%c/%Y') ddate, c.permalink FROM content c WHERE c.shop_id = 1 AND c.exposed <> 'YES' AND c.content_category_id = (SELECT id FROM content_categories WHERE title = 'News') AND (593 =593 OR (SELECT text FROM translations_data td WHERE td.group_name = 'content_content' AND td.field='title' AND td.doc_id = c.id AND td.language_id = 593) <> '') ORDER BY c.date DESC LIMIT 0,5;