Fêtes Juives - 'Hagim

34 => SELECT * FROM youtube WHERE id_youtube = :id LIMIT 1

---

2 => SELECT typecampagne_id as id_campagne, typecampagne_titre as nom_campagne FROM torahboxbeta.typecampagne WHERE typecampagne_id = :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-04 00:22:53' 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 AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248,4655,52195,52166,8611,18516,52157) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248,4655,52195,52166,8611,18516,52157,8595,22045,8787,8715,21828,4619) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248,4655,52195,52166,8611,18516,52157,8595,22045,8787,8715,21828,4619,2200,47994,15824,2189,49266,52506) AND a.type_article IN ('article','youtube') 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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248,4655,52195,52166,8611,18516,52157,8595,22045,8787,8715,21828,4619,2200,47994,15824,2189,49266,52506,52705,52695,52651,15951,52665,32898) AND a.type_article IN ('article','youtube') HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 160,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-04 00:22:53' 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,52054,26550,9282,7697,10463,26646,12439,4517,50822,12544,50778,50884,16248,3445,33483,5113,16441,9717,16524,3696,2416,483,9730,2415,14938,27693,33247,6609,27577,27670,495,5204,2505,5191,16563,33579,490,9814,3703,12939,491,47947,9837,9453,45550,16573,9986,49162,166,51337,46039,51336,51250,34365,51359,17331,46321,13674,587,29552,632,4150,10917,642,46594,11182,49555,51845,30101,4381,8183,8111,2964,4607,52052,296,738,8466,44248,4655,52195,52166,8611,18516,52157,8595,22045,8787,8715,21828,4619,2200,47994,15824,2189,49266,52506,52705,52695,52651,15951,52665,32898) AND a.type_article IN ('article','youtube') HAVING id_categorie_default > 0

---