12-08-2026 10:35 |
2.5159s | 12.09Mo | PAGE 0 | VILLE 197799 |
MYSQL:89 |
URL:237 => 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-21' 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-21') 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 (20101029,20101030)
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-12'
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-12 10:35:01' AND a.active = 1 AND a.langue_article = 'FR' AND DATE(a.time_pub) = '2026-08-12'
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-29' 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 (20260812)
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-29') AND celebre_auteur = 1
ORDER BY date_deces_auteur ASC, celebre_auteur DESC
1 => SELECT * FROM histoire_juive WHERE date_histoire_juive LIKE '%-08-12' ORDER BY date_histoire_juive ASC
1 => SELECT * FROM chavouatov WHERE active = '1' AND time_pub <= '2026-08-12 10:35:01' AND time_pub > DATE_ADD('2026-08-12 10:35:01', 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=2010&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=2010&nbr_j=100&mode=j&lat=39%C2%B057%27N&long=82%C2%B059%27O&gmt=-5&chgt=no
