Ermäßigung bei Anmeldung 4 Monate vor der Abreise

!!!!!!!!!SELECT * FROM tb_date_trek WHERE id_trek = '92' AND (statut_date_trek = '1' OR statut_date_trek = '2' OR statut_date_trek = '3' OR statut_date_trek = '4' OR statut_date_trek = '5') AND date_debut_trek >= '2026-07-26' AND archive_date_trek != 'OUI' AND date_trek_personnalisable !='OUI' ORDER BY date_debut_trek ASC