29 Octobre 2020 - 11 Hechvan 5781

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

---

2 => SELECT texte FROM moussar_jour WHERE jour = '02-11' 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 key_calendrier, nom_calendrier FROM calendrier

---

1 => SELECT id_ville FROM torahboxbeta.ville WHERE place_id = :place_id LIMIT 1

---

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 ('02-11') AND celebre_auteur = 1 ORDER BY date_deces_auteur ASC, celebre_auteur DESC

---

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 (20201029) ORDER BY a.cal_date ASC, b.cont_id ASC

---

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

---

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 * 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-07' 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 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-07 10:35:44' AND a.active = 1 AND a.langue_article = 'FR' AND DATE(a.time_pub) = '2026-08-07' 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-24' 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 (20260807,20260808) 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-24') AND celebre_auteur = 1 ORDER BY date_deces_auteur ASC, celebre_auteur DESC

---

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

---

1 => SELECT * FROM chavouatov WHERE active = '1' AND time_pub <= '2026-08-07 10:35:44' AND time_pub > DATE_ADD('2026-08-07 10:35:44', 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'

---

1 => SELECT photo_hiloula_auteur FROM auteur WHERE id_auteur = :id_auteur LIMIT 1

---

1 => http://roger.stioui.free.fr/Torah-Box-tos/calendrier.php?jc=29&mc=10&ac=2020&nbr_j=100&mode=j&lat=48%C2%B051%27N&long=02%C2%B021%27E&gmt=1&chgt=no

---

1 => http://roger.stioui.free.fr/Torah-Box-tos/calendrier.php?jc=29&mc=10&ac=2020&nbr_j=100&mode=j&lat=39%C2%B057%27N&long=82%C2%B059%27O&gmt=-5&chgt=no

---