SELECT `actualite`.*, `actualite__lang`.* FROM `actualite` JOIN `actualite__lang` ON `actualite__lang`.`rid_actualite` = `actualite`.`id_actualite` WHERE `afficher` = 1 AND (`date_debut` = "0000-00-00" OR `date_debut` <= "2018-12-15") AND (`date_fin` = "0000-00-00" OR `date_fin` >= "2018-12-15") AND `rid_lang` = 'en' GROUP BY `id_actualite` ORDER BY `date_debut` DESC LIMIT 10