Questions au Dan COHEN

37 => SELECT numero_talmud as numero, lettre_talmud as lettre FROM torah_talmud WHERE id_livre = :id_livre ORDER BY numero ASC, lettre ASC

---

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

---

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

---

3 => SELECT a.*, b.id_categorie, c.description_categorie FROM calendrier a LEFT JOIN categorie_content b ON (b.id_content = a.id_calendrier AND b.id_table = 'calendrier' AND b.default_categorie = '1') LEFT JOIN categorie c ON c.id_categorie = b.id_categorie WHERE nom_calendrier = :nom_calendrier LIMIT 1

---

2 => SELECT nom_categorie as nom, alias_categorie as alias FROM categorie WHERE nom_categorie LIKE :paracha LIMIT 1

---

2 => SELECT section, contenu, source FROM torahboxbeta.hok_leisrael WHERE paracha_id = :paracha_id AND yom = :yom ORDER BY position ASC

---

2 => SELECT source_fichier FROM moussar_fichier WHERE id_article = :id_article AND SUBSTRING_INDEX(source_fichier, '.', -1) = 'pdf' 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 CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) FROM auteur WHERE id_auteur = :id_auteur LIMIT 1

---

1 => SHOW FULL COLUMNS FROM qr_question

---

1 => SHOW FULL COLUMNS FROM tb.membre

---

1 => SHOW FULL COLUMNS FROM qr_reponse

---

1 => SHOW FULL COLUMNS FROM auteur

---

1 => SELECT SQL_CALC_FOUND_ROWS a.*, d.texte_reponse, b.prenom, b.nom, e.id_auteur, (SELECT id_categorie FROM categorie_content WHERE id_table = 'qr_question' AND id_content = a.id_question ORDER BY default_categorie DESC LIMIT 1) as id_categorie, e.titre_auteur, e.prenom_auteur, e.nom_auteur as nom_auteur2, IF(a.pinned>0 AND DATE_ADD(a.time_pinned,INTERVAL a.pinned DAY) >= CURRENT_DATE,1,0) as ranking, CONCAT(e.titre_auteur,e.prenom_auteur,' ',e.nom_auteur) as nom_auteur FROM qr_question a LEFT JOIN tb.membre b ON b.id = a.id_membre LEFT JOIN qr_reponse d ON d.id_reponse = a.id_reponse LEFT JOIN auteur e ON e.id_auteur = d.id_auteur WHERE a.statut = 5 AND a.active = 1 AND a.time_pub <= '2026-08-04 21:49:35' AND d.id_auteur = 1615 ORDER BY ranking DESC, a.time_pub DESC LIMIT 375,15

---

1 => SELECT FOUND_ROWS() AS total

---

1 => SELECT a.campagne19_livres_id FROM torahboxbeta.campagne19_livres a WHERE a.campagne19_livres_status = 1 AND a.campagne19_livres_type = 1 ORDER BY rand() LIMIT 1

---

1 => SELECT * FROM torahboxbeta.campagne19_livres WHERE campagne19_livres_id = 41 AND campagne19_livres_status IN (-1,0,1) LIMIT 1

---

1 => SELECT * FROM daf_michnayot WHERE date = :alias LIMIT 1

---

1 => SELECT nom_fr_livre as nom, description_livre as description, seder_fr_livre as seder FROM torah_livre WHERE id_collection = 5 AND alias_livre = :alias LIMIT 1

---

1 => SELECT *, nom_fr_livre as nom_livre, nom2_fr_livre as nom2_livre FROM torah_livre WHERE id_collection = 4

---

1 => SELECT key_calendrier, nom_calendrier FROM calendrier

---

1 => SELECT * FROM magazine WHERE active = 1 AND time_pub <= CURRENT_TIMESTAMP ORDER BY time_pub DESC LIMIT 1

---

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.date_chapitre = '2026-08-04' 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_chapitre = '3228' ORDER BY c.numero_chapitre 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 * FROM dirchou WHERE date_dirchou = :date_dirchou LIMIT 1

---

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

---

1 => SELECT a.*, 0 as count_quizz, m.alias_media, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as nom_auteur, b.titre_auteur, b.prenom_auteur, b.nom_auteur as nom_auteur2, b.nom_en_auteur, b.id_auteur, b.publicite_auteur, b.sexe_auteur, b.langue_auteur, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM torahbox.article a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur LEFT JOIN media m ON m.id_media = a.id_media WHERE a.site_article IN (0,1) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-04 21:49:35' AND a.active = 1 AND a.langue_article = 'FR' AND DATE(a.time_pub) = '2026-08-04' HAVING id_categorie_default > 0 AND id_categorie_default = '532' ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,1

---

1 => SELECT id_fichier, type_fichier, source_fichier, taille_fichier, duree_fichier FROM fichier WHERE id_article = :id_article AND active = 1

---

1 => SELECT texte FROM moussar_jour WHERE jour = '12-21' LIMIT 1

---

1 => SELECT a.cal_date, b.*, c.sect_titre FROM torahboxbeta.echethayil_calendrier a LEFT JOIN torahboxbeta.echethayil_contenu b ON b.cont_id = a.cal_num_dia LEFT JOIN torahboxbeta.echethayil_section c ON c.sect_id = b.cont_sectionid WHERE a.cal_date IN (20260804) ORDER BY a.cal_date ASC, b.cont_id ASC

---

1 => SELECT id_auteur, CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) as nom_auteur, celebre_auteur, date_deces_auteur, annee_deces_auteur, page_hiloula_auteur FROM auteur WHERE date_deces_auteur IN ('12-21') AND celebre_auteur = 1 ORDER BY date_deces_auteur ASC, celebre_auteur DESC

---

1 => SELECT * FROM histoire_juive WHERE date_histoire_juive LIKE '%-08-04' ORDER BY date_histoire_juive ASC

---

1 => SELECT * FROM chavouatov WHERE active = '1' AND time_pub <= '2026-08-04 21:49:35' AND time_pub > DATE_ADD('2026-08-04 21:49:35', INTERVAL -7 DAY) ORDER BY time_pub DESC LIMIT 1

---

1 => SELECT a.id_citation, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as auteur, a.texte_citation as texte FROM citation a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur WHERE a.date_citation <= CURRENT_DATE AND a.active = 1 ORDER BY a.date_citation DESC LIMIT 1

---

1 => SELECT DISTINCT(a.id_membre), a.texte_comment, b.url_comment_page, c.nom, c.prenom, d.titre_article FROM comment a LEFT JOIN comment_page b ON b.id_comment_page = a.id_comment_page LEFT JOIN tb.membre c ON c.id = a.id_membre LEFT JOIN article d ON d.id_article = b.id_content WHERE a.active = 1 AND a.interet = 1 AND DATE(a.time_add) >= DATE_SUB(CURRENT_DATE,INTERVAL 24 MONTH) AND LENGTH(a.texte_comment) BETWEEN 30 AND 200 AND b.id_table = 'article' AND d.site_article IN (0,1) ORDER BY a.time_add DESC LIMIT 20

---

1 => SELECT id_banniere, texte_banniere FROM banniere WHERE active = 1 AND CURRENT_DATE BETWEEN date_start AND date_end AND taille_banniere = 'link_header' ORDER BY ordre_banniere ASC

---

1 => SELECT zoom_live FROM live WHERE active = 1 AND CURRENT_TIMESTAMP BETWEEN time_debut AND time_fin ORDER BY time_debut ASC LIMIT 1

---

1 => SELECT id_live, time_debut, time_fin FROM live WHERE active = 1 AND popup_live = 1 AND CURRENT_TIMESTAMP BETWEEN time_debut AND time_fin ORDER BY time_debut ASC LIMIT 1

---

1 => SELECT a.id_calendrier, a.nom_calendrier, a.message_calendrier, a.key_calendrier, a.fete_calendrier, a.listing_calendrier, a.yomtov_calendrier, b.id_categorie FROM calendrier a LEFT JOIN categorie_content b ON b.id_content = a.id_calendrier AND b.id_table = 'calendrier'

---