TEST OPEN APP
SELECT * FROM mandats LEFT JOIN affaires ON (affaires.id = affaire_id) WHERE mandats.date_fin > '2026-08-24 00:00:00' AND affaires.internet = '1' AND mandats.archive = '0' AND mandats.date_debut > '2026-02-24' ORDER BY date_debut DESC;