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