mon compte
SELECT `press`.*, `country`.`label_fr` as country_labelFROM (`press`)LEFT JOIN `country` ON `country`.`id` = `press`.`country_id`WHERE `press`.`status` = 'active'GROUP BY `press`.`id`ORDER BY `date` DESC