6 => SELECT a.id_categorie, a.id_parent, a.nom_categorie, (SELECT COUNT(*) FROM moussar_categorie b WHERE b.id_parent = a.id_categorie) as count_children FROM moussar_categorie a WHERE a.id_parent = :id_parent ORDER BY a.id_categorie ASC

---

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.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_livre = a.id_livre AND id_parent > 0) as sous_chapitre, (SELECT DATE(MAX(time_upd)) FROM moussar_chapitre WHERE id_livre = a.id_livre) as max_time_upd FROM moussar_livre a WHERE a.active = 1 AND a.date_pub <= CURRENT_DATE ORDER BY a.date_pub DESC, a.nom_livre ASC

---