Béréchit - Genèse

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

---

1 => SELECT id_ville FROM torahboxbeta.ville WHERE place_id = :place_id LIMIT 1

---

1 => SELECT a.*, b.pays_id FROM torahboxbeta.ville a LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville WHERE a.id_ville = :id_ville LIMIT 1

---

1 => SELECT id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1

---

1 => SELECT 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-03 23:25:13' 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 = '51' 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-03 23:25:13' 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 = '52' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948) 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-03 23:25:13' 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 = '53' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971) 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-03 23:25:13' 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 = '54' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025) 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-03 23:25:13' 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 = '55' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081) 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-03 23:25:13' 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 = '56' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812) 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-03 23:25:13' 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 = '57' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139) 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-03 23:25:13' 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 = '58' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932) 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-03 23:25:13' 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 = '59' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239) 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-03 23:25:13' 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 = '60' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239,17171,34120,49031,51274,51158,51148) 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-03 23:25:13' 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 = '61' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239,17171,34120,49031,51274,51158,51148,10465,51350,34207,49121,51275,51302) 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-03 23:25:13' 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 = '62' LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239,17171,34120,49031,51274,51158,51148,10465,51350,34207,49121,51275,51302,34339,13679,28647,51401,34265,49158) 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-03 23:25:13' 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 (48,62,61,60,59,58,57,56,55,54,53,52,51) LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239,17171,34120,49031,51274,51158,51148,10465,51350,34207,49121,51275,51302,34339,13679,28647,51401,34265,49158,17347,51431,34306,49193,51418,51421) AND a.type_article IN ('article','youtube') HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 128,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-03 23:25:13' 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 (48,62,61,60,59,58,57,56,55,54,53,52,51) LIMIT 1) = 1 AND a.id_article NOT IN (41179,50934,50954,33375,50956,50948,501,13064,50986,33625,50998,50971,51062,10055,33645,51054,2543,51025,10077,51131,2562,33751,2558,51081,51151,16871,51167,13247,33774,48812,51201,10198,51210,33852,48861,51139,51249,10279,33996,10299,51211,48932,51273,10335,34058,48983,51212,51239,17171,34120,49031,51274,51158,51148,10465,51350,34207,49121,51275,51302,34339,13679,28647,51401,34265,49158,17347,51431,34306,49193,51418,51421) AND a.type_article IN ('article','youtube') HAVING id_categorie_default > 0

---