Roch Hodech Elloul avec Rabbi Meir Elkouby à Jérusalem

2 => SELECT nom, fichier as src FROM evenement_fichier WHERE id_evenement = :id_evenement AND active = 1 AND type = :type ORDER BY ordre ASC

---

1 => SELECT id_ville FROM torahboxbeta.ville WHERE place_id = :place_id LIMIT 1

---

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 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 a.extranet_evenement = 0 AND a.id_evenement = 1822 ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 20

---

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

---