Ketouvim (hagiographes) » Chroniques II (Divrei Hayamim 2)

34 => SELECT * FROM torah_commentaire WHERE id_verset = :id_verset AND langue_commentaire = :langue

---

2 => SELECT a.*, b.alias_collection FROM torah_livre a LEFT JOIN torah_collection b ON b.id_collection = a.id_collection WHERE a.id_collection = :id_collection ORDER BY a.id_livre ASC

---

2 => SELECT id_collection FROM torah_livre WHERE id_livre = :id_livre LIMIT 1

---

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 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 torah_collection WHERE alias_collection = 'ketouvim' AND visible = 1 ORDER BY ordre_collection ASC

---

1 => SELECT a.*, b.alias_collection FROM torah_livre a LEFT JOIN torah_collection b ON b.id_collection = a.id_collection WHERE a.id_collection = :id_collection AND a.alias_livre = 'chroniques-ii' ORDER BY a.id_livre ASC

---

1 => SELECT * FROM torah_collection WHERE 1 AND visible = 1 ORDER BY ordre_collection ASC

---

1 => SELECT c.id_chapitre, c.numero_fr_chapitre, a.*, b.alias_collection, c.numero_fr_chapitre as numero_chapitre, (SELECT nom_fr_paracha FROM torah_paracha WHERE id_livre = a.id_livre AND section_paracha LIKE CONCAT(c.numero_fr_chapitre,':%')) as paracha FROM torah_chapitre c LEFT JOIN torah_livre a ON a.id_livre = c.id_livre LEFT JOIN torah_collection b ON b.id_collection = a.id_collection WHERE c.id_livre = :id_livre ORDER BY c.numero_fr_chapitre ASC

---

1 => SELECT c.id_chapitre, c.numero_fr_chapitre, a.*, b.alias_collection, c.numero_fr_chapitre as numero_chapitre, (SELECT nom_fr_paracha FROM torah_paracha WHERE id_livre = a.id_livre AND section_paracha LIKE CONCAT(c.numero_fr_chapitre,':%')) as paracha FROM torah_chapitre c LEFT JOIN torah_livre a ON a.id_livre = c.id_livre LEFT JOIN torah_collection b ON b.id_collection = a.id_collection WHERE c.id_livre = :id_livre HAVING numero_chapitre = '18' ORDER BY c.numero_fr_chapitre ASC

---

1 => SELECT a.* FROM torah_verset a LEFT JOIN torah_chapitre b ON b.id_chapitre = a.id_chapitre WHERE b.numero_fr_chapitre = :numero_chapitre AND b.id_livre = :id_livre

---