Les aventures de Benny (épisode 13) : Choftim

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 => SHOW FULL COLUMNS FROM torahbox_stats.content

---

1 => INSERT INTO torahbox_stats.content (`id_content`, `id_table`, `id_membre`, `ip`, `uuid`) VALUES (:id_content, :id_table, :id_membre, :ip, :uuid)

---

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.id_article = '6784' ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,8

---

1 => SELECT id_fichier, type_fichier, source_fichier, taille_fichier, duree_fichier FROM fichier WHERE id_article = :id_article AND active = 1

---

1 => SELECT a.id_article, a.titre_article, a.alias_article FROM article a LEFT JOIN categorie_content b ON (b.id_content = a.id_article AND b.id_table = 'article') WHERE DATE(a.time_pub) != '0000-00-00' AND a.id_article != :id_article AND b.id_categorie = :id_categorie AND b.default_categorie = '1' AND a.time_pub BETWEEN :time_pub AND '2026-08-03 19:20:45' AND a.active = '1' ORDER BY a.time_pub ASC LIMIT 1

---

1 => SELECT a.id_article, a.titre_article, a.alias_article FROM article a LEFT JOIN categorie_content b ON (b.id_content = a.id_article AND b.id_table = 'article') WHERE DATE(a.time_pub) != '0000-00-00' AND a.id_article != :id_article AND b.id_categorie = :id_categorie AND b.default_categorie = '1' AND a.time_pub < :time_pub AND a.active = '1' ORDER BY a.time_pub DESC LIMIT 1

---

1 => SELECT id_article_groupe FROM article_groupe_content WHERE id_article = :id_article LIMIT 1

---

1 => SELECT a.id_categorie, COUNT(*) as count FROM categorie_content a LEFT JOIN article b ON b.id_article = a.id_content WHERE a.id_categorie != 215 AND a.id_table = 'article' AND b.active = 1 AND b.time_pub <= '2026-08-03 19:20:45' AND (SELECT c.id_categorie FROM categorie_content c WHERE c.default_categorie = 1 AND c.id_table = a.id_table AND c.id_content = a.id_content LIMIT 1) = 215 GROUP BY a.id_categorie

---