Rav Daniel SCEMAMA

08-08-2026 01:52 | 0.2317s | 3.64Mo | PAGE 0 | VILLE 197799 | MYSQL:61 | URL:0

24 => 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 = '1198' ORDER BY c.numero_chapitre ASC

2 => 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 = '1254' ORDER BY c.numero_chapitre ASC

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 *, CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) as nom_auteur FROM auteur WHERE id_auteur = :id_auteur 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,2) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-08 01:52:37' AND a.active = 1 AND a.langue_article = 'FR' AND a.id_auteur = '567' AND a.type_article != 'article' HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 5680,20

1 => SELECT (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,2) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-08 01:52:37' AND a.active = 1 AND a.langue_article = 'FR' AND a.id_auteur = '567' AND a.type_article != 'article' HAVING id_categorie_default > 0

1 => SELECT a.id_question, a.titre_question FROM qr_question a LEFT JOIN tb.membre b ON b.id = a.id_membre LEFT JOIN qr_reponse c ON c.id_reponse = a.id_reponse WHERE c.id_auteur = :id_auteur AND a.active = 1 AND a.statut = 5 AND a.time_pub <= '2026-08-08 01:52:37' ORDER BY a.time_pub DESC LIMIT 26

1 => SHOW FULL COLUMNS FROM moussar_fichier

1 => SHOW FULL COLUMNS FROM moussar_chapitre

1 => SHOW FULL COLUMNS FROM moussar_livre

1 => SHOW FULL COLUMNS FROM auteur

1 => SELECT SQL_CALC_FOUND_ROWS a.id_fichier, c.id_livre, c.nom_livre, c.alias_livre, b.id_chapitre, b.nom_chapitre, a.source_fichier, a.duree_fichier, IF(a.id_auteur > 0,a.id_auteur,c.id_auteur) as id_auteur, a.time_add, CONCAT(d.titre_auteur,d.prenom_auteur,' ',d.nom_auteur) as nom_auteur FROM moussar_fichier a LEFT JOIN moussar_chapitre b ON b.id_chapitre = a.id_article LEFT JOIN moussar_livre c ON c.id_livre = b.id_livre LEFT JOIN auteur d ON d.id_auteur = IF(a.id_auteur > 0,a.id_auteur,c.id_auteur) WHERE b.active = 1 AND c.active = 1 AND a.source_fichier LIKE '%.mp4' HAVING id_auteur = :id_auteur ORDER BY a.time_add DESC LIMIT 3408,12

1 => SELECT FOUND_ROWS() AS total

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 = '25' AND c.id_chapitre = '1206' 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 = '26' AND c.id_chapitre = '1240' 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 = '26' AND c.id_chapitre = '3842' 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 = '26' AND c.id_chapitre = '1257' ORDER BY c.numero_chapitre ASC

Rav Daniel SCEMAMA

Rav Daniel SCEMAMA : 13 résultats

étude sur texte : 3546 résultats