1 => SELECT a.*, b.pays_id FROM torahboxbeta.ville a LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville WHERE a.id_ville = :id_ville LIMIT 1

---

1 => SELECT id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1

---

1 => SELECT a.type_evenement as id, COUNT(*) as value FROM evenement a WHERE a.active = 1 AND a.visible = 1 AND (DATE(a.time_evenement) >= '2026-08-03' OR DATE(a.time_evenement_fin) >= '2026-08-03') GROUP BY id

---

1 => SELECT COUNT(*) as count, b.pays_id, b.pays_titre as titre, pays_iso2 as iso FROM evenement a LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement WHERE a.pays_evenement > 0 AND a.active = 1 AND a.visible = 1 AND (DATE(a.time_evenement) >= '2026-08-03' OR DATE(a.time_evenement_fin) >= '2026-08-03') GROUP BY a.pays_evenement

---

1 => SELECT a.*, a.pays_evenement as id_pays, b.pays_titre as pays_evenement, b.pays_iso2 as iso_pays_evenement, c.nom_etablissement, c.note_etablissement, IF(a.id_etablissement>0,c.adresse_etablissement,a.adresse_evenement) as adresse_evenement, IF(a.id_etablissement>0,c.cp_etablissement,a.cp_evenement) as cp_evenement, IF(a.id_etablissement>0,c.ville_etablissement,a.ville_evenement) as ville_evenement FROM evenement a LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement LEFT JOIN evenement_etablissement c ON c.id_etablissement = a.id_etablissement WHERE (DATE(a.time_evenement) >= '2026-08-03' OR DATE(a.time_evenement_fin) >= '2026-08-03') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.pays_evenement IN (20) ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 50

---

1 => SELECT * FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 ORDER BY ordre ASC

---