OPÉRATION TSNIOUT : Votre mission, si vous l'acceptez...

5 => SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = :id_content AND id_table = :id_table

---

4 => SELECT * FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 ORDER BY ordre ASC

---

3 => 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

---

3 => SELECT data FROM classement_historique WHERE time >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 1 DAY) AND type = :type ORDER BY time ASC LIMIT 1

---

2 => 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

---

2 => SELECT id_categorie as id, id_categorie as value FROM torahbox.categorie_content WHERE id_content = :id_content AND id_table = :id_table

---

2 => SELECT nom FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 AND enfant = 1 ORDER BY ordre ASC LIMIT 1

---

2 => SELECT nom FROM evenement_tarif WHERE id_evenement = :id_evenement AND active = 1 AND bebe = 1 ORDER BY ordre ASC 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 = '26583' ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,8

---

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-04 08:45:10' 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 nom_source FROM source WHERE id_source = :id_source LIMIT 1

---

1 => SELECT a.id_categorie_content, b.id_parent, b.id_page, b.id_categorie, b.nom_categorie, a.default_categorie FROM torahbox.categorie_content a LEFT JOIN torahbox.categorie b ON b.id_categorie = a.id_categorie WHERE (a.id_content = :id_content AND a.id_table = :id_table) ORDER BY a.default_categorie DESC

---

1 => SELECT a.id_content FROM categorie_content a LEFT JOIN torahboxbeta.campagne19_livres b ON b.campagne19_livres_id = a.id_content WHERE a.id_table = 'campagne19_livres' AND b.campagne19_livres_type = 1 AND a.id_categorie IN (244) AND b.campagne19_livres_status = 1 ORDER BY rand() LIMIT 1

---

1 => SELECT * FROM torahboxbeta.campagne19_livres WHERE campagne19_livres_id = 365 AND campagne19_livres_status IN (-1,0,1) LIMIT 1

---

1 => SELECT id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND id_content = :id_content LIMIT 1

---

1 => SELECT * FROM article_quizz WHERE id_article = :id_article AND active = 1 ORDER BY time_add ASC

---

1 => SELECT id_tag as id, id_tag as value FROM tag_content WHERE id_content = :id_content AND id_table = :id_table

---

1 => SELECT b.id_article FROM tag_content a LEFT JOIN article b ON b.id_article = a.id_content WHERE b.time_pub <= '2026-08-04 08:45:10' AND a.id_content != :id_content AND a.id_table = :id_table AND a.id_tag IN (287,4622,8194,13061) GROUP BY b.id_article ORDER BY b.time_pub DESC

---

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,2) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-04 08:45:10' AND a.active = 1 AND a.langue_article = 'FR' AND a.id_article IN (33150,33038,32955,32817,32727) HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,8

---

1 => SELECT a.*, a.pays_evenement as id_pays, b.pays_titre as pays_evenement, b.pays_iso2 as iso_pays_evenement, c.nom_etablissement, c.note_etablissement, IF(a.id_etablissement>0,c.adresse_etablissement,a.adresse_evenement) as adresse_evenement, IF(a.id_etablissement>0,c.cp_etablissement,a.cp_evenement) as cp_evenement, IF(a.id_etablissement>0,c.ville_etablissement,a.ville_evenement) as ville_evenement FROM evenement a LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement LEFT JOIN evenement_etablissement c ON c.id_etablissement = a.id_etablissement WHERE (DATE(a.time_evenement) >= '2026-08-04' OR DATE(a.time_evenement_fin) >= '2026-08-04') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (2,3) AND DATE(a.time_evenement) >= '2026-08-04' ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 3

---

1 => SELECT a.*, a.pays_evenement as id_pays, b.pays_titre as pays_evenement, b.pays_iso2 as iso_pays_evenement, c.nom_etablissement, c.note_etablissement, IF(a.id_etablissement>0,c.adresse_etablissement,a.adresse_evenement) as adresse_evenement, IF(a.id_etablissement>0,c.cp_etablissement,a.cp_evenement) as cp_evenement, IF(a.id_etablissement>0,c.ville_etablissement,a.ville_evenement) as ville_evenement FROM evenement a LEFT JOIN torahboxbeta.pays b ON b.pays_id = a.pays_evenement LEFT JOIN evenement_etablissement c ON c.id_etablissement = a.id_etablissement WHERE (DATE(a.time_evenement) >= '2026-08-04' OR DATE(a.time_evenement_fin) >= '2026-08-04') AND a.extranet_evenement = 0 AND a.visible = 1 AND a.active = 1 AND a.type_evenement IN (1) AND DATE(a.time_evenement) >= '2026-08-04' ORDER BY a.pinned_evenement DESC, a.time_evenement ASC LIMIT 5

---

1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN article b ON b.id_article = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---

1 => SELECT a.id_content, b.id_article, b.titre_article as title, b.alias_article, b.id_auteur, (SELECT CONCAT(titre_auteur,prenom_auteur,' ',nom_auteur) FROM auteur WHERE id_auteur = b.id_auteur) as nom_auteur, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN article b ON b.id_article = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---

1 => SELECT a.id_content, b.id_question, b.titre_question as title, b.titre_question, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_content AND id_table = 'qr_question' AND default_categorie = 1) as id_categorie_default FROM classement a RIGHT JOIN qr_question b ON b.id_question = a.id_content WHERE a.type = :type ORDER BY a.rank ASC LIMIT 9

---

1 => SELECT key_calendrier, nom_calendrier FROM calendrier

---