Etudes & Ethique Juive

121 => SELECT id_fichier, type_fichier, source_fichier, taille_fichier, duree_fichier FROM fichier WHERE id_article = :id_article AND active = 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 ordre_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-09 00:19:39' 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 = '10' LIMIT 1) = 1 AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '11' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '13' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '12' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '14' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '15' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '16' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '17' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '18' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '19' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '20' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '119' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '124' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '201' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '202' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '203' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '205' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '206' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '208' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202,29537,7011,15552,13124,6915,6874) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '209' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202,29537,7011,15552,13124,6915,6874,14738) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 = '213' LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202,29537,7011,15552,13124,6915,6874,14738,33812,7126,5172,5144,6508,30446) AND a.type_article IN ('audio_video','video','audio') 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-09 00:19:39' 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 (9,213,211,209,208,207,206,205,203,202,201,124,119,20,19,18,17,16,15,14,12,13,11,10) LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202,29537,7011,15552,13124,6915,6874,14738,33812,7126,5172,5144,6508,30446,34157,33815,33813,4074,27759,4351) AND a.type_article IN ('audio_video','video','audio') HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 5648,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-09 00:19:39' 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 (9,213,211,209,208,207,206,205,203,202,201,124,119,20,19,18,17,16,15,14,12,13,11,10) LIMIT 1) = 1 AND a.id_article NOT IN (51040,8660,50395,6530,4968,44642,52694,52504,4624,1091,17223,51661,51157,51156,51029,51028,50989,50962,7720,13086,15164,12727,7985,2516,14390,11658,28928,16438,50742,50740,52435,14394,31756,6337,51994,13751,48036,52654,32484,51974,51975,51746,16727,51216,50310,50166,50145,50085,3439,10321,36476,11630,9120,14388,31171,12722,12424,29602,11919,24800,51473,51286,51236,50943,50743,50688,6672,50408,6730,48043,48041,45138,2977,13158,10999,13156,13157,13418,52401,30379,52755,34507,6172,31112,52668,8089,3600,51990,34173,9341,32973,5382,5533,5532,5383,12082,52281,48569,47401,2783,46203,46202,29537,7011,15552,13124,6915,6874,14738,33812,7126,5172,5144,6508,30446,34157,33815,33813,4074,27759,4351) AND a.type_article IN ('audio_video','video','audio') HAVING id_categorie_default > 0

---