Michna Beroura 3 - מִשְׁנָה בְּרוּרָה ג

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 * FROM dirchou WHERE id_dirchou = :id_dirchou LIMIT 1

---

1 => SELECT * FROM dirchou_fichier WHERE id_dirchou = :id_dirchou AND active = 1 ORDER BY type_fichier ASC

---

1 => SELECT id_dirchou, titre_dirchou FROM dirchou WHERE date_dirchou < :date_dirchou ORDER BY date_dirchou DESC LIMIT 1

---

1 => SELECT id_dirchou, titre_dirchou FROM dirchou WHERE date_dirchou > :date_dirchou ORDER BY date_dirchou ASC LIMIT 1

---