Traité Nedarim

29 => SELECT source_fichier FROM moussar_fichier WHERE id_article = :id_article AND SUBSTRING_INDEX(source_fichier, '.', -1) = 'pdf' LIMIT 1

---

9 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_chapitre = '1548' ORDER BY c.numero_chapitre ASC

---

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

---

3 => 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

---

3 => SELECT data FROM classement_historique WHERE time >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 1 DAY) AND type = :type ORDER BY time ASC LIMIT 1

---

2 => SELECT nom FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 AND enfant = 1 ORDER BY ordre ASC LIMIT 1

---

2 => SELECT nom FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 AND bebe = 1 ORDER BY ordre ASC 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 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 AND a.alias_livre = 'traite-nedarim' ORDER BY a.date_pub DESC, a.nom_livre ASC

---

1 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_livre = '32' AND c.id_parent = '0' ORDER BY c.numero_chapitre ASC

---

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

---

1 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_livre = '32' AND c.id_chapitre = '1555' ORDER BY c.numero_chapitre ASC

---

1 => SELECT c.*, a.*, (SELECT COUNT(*) FROM moussar_chapitre WHERE id_parent = c.id_chapitre) as sous_chapitre, (SELECT MIN(numero_chapitre) FROM moussar_chapitre WHERE id_livre = c.id_livre) as min_numero_chapitre, IF(c.id_parent > 0, (SELECT nom_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as nom_chapitre_parent, IF(c.id_parent > 0, (SELECT numero_chapitre FROM moussar_chapitre WHERE id_chapitre = c.id_parent), null) as numero_chapitre_parent FROM moussar_chapitre c LEFT JOIN moussar_livre a ON a.id_livre = c.id_livre WHERE c.active = 1 AND c.id_livre = '32' AND c.id_parent = '1548' ORDER BY c.numero_chapitre ASC

---

1 => 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.*, (SELECT taille_fichier FROM moussar_fichier WHERE id_article = a.id_article AND source_fichier = replace(a.source_fichier,'.mp4','.mp3')) as taille_fichier_mp3 FROM moussar_fichier a WHERE a.id_article = :id_article AND SUBSTRING_INDEX(a.source_fichier, '.', -1) = 'mp4' ORDER BY a.id_fichier ASC

---

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 (DATE(a.time_evenement) >= '2026-08-05' OR DATE(a.time_evenement_fin) >= '2026-08-05') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (2,3) AND DATE(a.time_evenement) >= '2026-08-05' ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 3

---

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 (DATE(a.time_evenement) >= '2026-08-05' OR DATE(a.time_evenement_fin) >= '2026-08-05') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (1) AND DATE(a.time_evenement) >= '2026-08-05' ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 5

---

1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN article b ON b.id_article = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---

1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article, b.id_auteur, (SELECT CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) FROM auteur WHERE id_auteur = b.id_auteur) as nom_auteur, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN article b ON b.id_article = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---

1 => SELECT a.id_content, b.id_question, b.titre_question as title, b.titre_question, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'qr_question' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN qr_question b ON b.id_question = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---