03-08-2026 23:28 |
0.0632s | 2.86Mo | PAGE 76 | VILLE 197799 |
MYSQL:45 |
URL:028 => SELECT source_fichier FROM moussar_fichier WHERE id_article = :id_article AND SUBSTRING_INDEX(source_fichier, '.', -1) = 'pdf' LIMIT 1
8 => 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 = '2546'
ORDER BY c.numero_chapitre ASC
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 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-houlin'
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 = '49' 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 = '49' AND c.id_chapitre = '2549'
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 = '49' AND c.id_parent = '2546'
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
