Les dernières questions

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

---

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 a.id_calendrier, a.nom_calendrier, a.message_calendrier, a.key_calendrier, a.fete_calendrier, a.listing_calendrier, a.yomtov_calendrier, b.id_categorie FROM calendrier a LEFT JOIN categorie_content b ON b.id_content = a.id_calendrier AND b.id_table = 'calendrier'

---

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

---

1 => SHOW FULL COLUMNS FROM qr_question

---

1 => SHOW FULL COLUMNS FROM tb.membre

---

1 => SHOW FULL COLUMNS FROM qr_reponse

---

1 => SHOW FULL COLUMNS FROM auteur

---

1 => SELECT SQL_CALC_FOUND_ROWS a.*, d.texte_reponse, b.prenom, b.nom, e.id_auteur, (SELECT id_categorie FROM categorie_content WHERE id_table = 'qr_question' AND id_content = a.id_question ORDER BY default_categorie DESC LIMIT 1) as id_categorie, e.titre_auteur, e.prenom_auteur, e.nom_auteur as nom_auteur2, IF(a.pinned>0 AND DATE_ADD(a.time_pinned,INTERVAL a.pinned DAY) >= CURRENT_DATE,1,0) as ranking, CONCAT(e.titre_auteur,e.prenom_auteur,' ',e.nom_auteur) as nom_auteur FROM qr_question a LEFT JOIN tb.membre b ON b.id = a.id_membre LEFT JOIN qr_reponse d ON d.id_reponse = a.id_reponse LEFT JOIN auteur e ON e.id_auteur = d.id_auteur WHERE a.statut = 5 AND a.active = 1 AND a.time_pub <= '2026-08-09 08:20:28' ORDER BY ranking DESC, a.time_pub DESC LIMIT 4980,15

---

1 => SELECT FOUND_ROWS() AS total

---

1 => SELECT a.campagne19_livres_id FROM torahboxbeta.campagne19_livres a WHERE a.campagne19_livres_status = 1 AND a.campagne19_livres_type = 1 ORDER BY rand() LIMIT 1

---

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

---

1 => SELECT key_calendrier, nom_calendrier FROM calendrier

---

1 => SELECT id_page, alias FROM page WHERE alias != '' AND active = 1

---

1 => SELECT a.id_categorie, a.id_page, b.image as image_page, a.id_parent, a.alias_categorie, a.nom_categorie, a.menu_categorie, a.nom_phonetique_categorie, a.nom_principal_categorie, a.photo_categorie FROM torahbox.categorie a LEFT JOIN torahbox.page b ON b.id_page = a.id_page ORDER BY a.id_parent ASC, a.ordre_categorie ASC

---

1 => SELECT a.*, b.id_categorie, c.description_categorie FROM calendrier a LEFT JOIN categorie_content b ON (b.id_content = a.id_calendrier AND b.id_table = 'calendrier' AND b.default_categorie = '1') LEFT JOIN categorie c ON c.id_categorie = b.id_categorie WHERE nom_calendrier = :nom_calendrier LIMIT 1

---