SELECT `youtube_links`.* FROM `youtube_links` LEFT JOIN `youtube_links_lang` `t` ON `youtube_links`.`id` = `t`.`parent_id` WHERE (`status`=1) AND (`t`.`language`='en') GROUP BY `youtube_links`.`id` ORDER BY `published_at` DESC, `id` DESC