05-08-2026 21:49 |
6.7063s | 4.24Mo | PAGE 0 | VILLE 1 |
MYSQL:99 |
URL:153 => SELECT id_fichier, type_fichier, source_fichier, taille_fichier, duree_fichier FROM fichier WHERE id_article = :id_article AND active = 1
19 => SELECT * FROM youtube WHERE id_youtube = :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 date_categorie, description_categorie FROM categorie WHERE id_categorie = :id_categorie LIMIT 1
1 => SELECT id_categorie, date_categorie FROM categorie WHERE id_parent = :id_parent AND active = 1 ORDER BY ordre_categorie ASC
1 => SELECT id_categorie, nom_categorie, date_categorie FROM categorie WHERE id_parent = :id_parent AND active = '1' ORDER BY date_categorie 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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '200'
LIMIT 1) = 1
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '195'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '27'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '28'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '29'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '30'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '123'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '31'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '32'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '33'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '34'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '111'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '35'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '36'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '39'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '41'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '43'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466,4655,52195,52166,8611,18516,30928)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
1 => SELECT typecampagne_id as id_campagne, typecampagne_titre as nom_campagne FROM torahboxbeta.typecampagne WHERE typecampagne_id = :id 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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '44'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466,4655,52195,52166,8611,18516,30928,8595,31756,22045,8787,8715,21828)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '45'
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466,4655,52195,52166,8611,18516,30928,8595,31756,22045,8787,8715,21828,2200,6441,47994,3380,15864,3316)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,6
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-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie IN (8,200,195,123,111,45,44,43,41,39,36,35,34,33,32,31,30,29,28,27)
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466,4655,52195,52166,8611,18516,30928,8595,31756,22045,8787,8715,21828,2200,6441,47994,3380,15864,3316,52705,48036,45140,45162,16052,6705)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 2160,16
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) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-05 21:49:15' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie)
FROM categorie_content
WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie IN (8,200,195,123,111,45,44,43,41,39,36,35,34,33,32,31,30,29,28,27)
LIMIT 1) = 1 AND a.id_article NOT IN (36754,3102,52088,52095,52049,6387,26550,12468,9282,33017,7697,9358,4517,50822,12544,50778,50884,16248,3445,7018,33483,5113,3544,16441,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,35196,27577,12965,2671,27494,27489,5200,6972,490,7167,9814,33588,45556,3703,5204,47947,9837,9453,33580,45557,10454,10352,49162,34243,13579,3810,34365,51359,13698,4055,17331,34363,29552,51547,5722,4161,632,4150,11182,51555,2919,49555,14591,42291,51845,30101,4381,8183,8111,2964,51992,4607,52052,296,738,8466,4655,52195,52166,8611,18516,30928,8595,31756,22045,8787,8715,21828,2200,6441,47994,3380,15864,3316,52705,48036,45140,45162,16052,6705)
HAVING id_categorie_default > 0
1 => https://maps.googleapis.com/maps/api/geocode/json?latlng=%2C&sensor=0&language=fr&key=AIzaSyBntS3fl6_iJlRqlmHjxLYgSq3VT-ZDses
![[MP3] Paracha & Haftara de Souccoth, Chémini Atséret & Sim'ha Torah à écouter](https://media.torah-box.com/165x90/kriat-hatorah-2052.webp)
