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