SELECT a.*, b.template as template,b.color, c.identifiant as menu_identifiant, d.slug as slug, e.label as page_label, e.link as page_link FROM menu_page a LEFT JOIN page b ON (b.id = a.page_id) LEFT JOIN menu c ON (c.id = a.menu_id) LEFT JOIN page_lang d ON (d.page_id = b.id AND d.langue_id ='fr') LEFT JOIN menu_page_lang e ON (e.menu_page_id = a.id AND d.langue_id ='fr') WHERE (a.online = 1 AND a.date_online < '2026-02-10 03:26:00' AND (c.identifiant IN ()))