Discount if booked 4 months before departure

!!!!!!!!!SELECT * FROM tb_date_trek WHERE id_trek = '93' 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-06-11' AND archive_date_trek != 'OUI' AND date_trek_personnalisable !='OUI' ORDER BY date_debut_trek ASC

* Price per person (without insurance)