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