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 id_page, alias FROM page WHERE alias != '' AND active = 1

---

1 => SELECT a.id_categorie, a.id_page, b.image as image_page, a.id_parent, a.alias_categorie, a.nom_categorie, a.menu_categorie, a.nom_phonetique_categorie, a.nom_principal_categorie, a.photo_categorie FROM torahbox.categorie a LEFT JOIN torahbox.page b ON b.id_page = a.id_page ORDER BY a.id_parent ASC, a.ordre_categorie ASC

---