03-08-2026 19:18 |
0.4394s | 1.81Mo | PAGE 14 | VILLE 197799 |
MYSQL:12 |
URL:02 => 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.*, 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 a.*,
(SELECT COUNT(DISTINCT a1.id_content)
FROM source_content a1
LEFT JOIN qr_question b1 ON b1.id_question = a1.id_content
WHERE a1.id_table = 'qr_question' AND a1.type_source = 'livre' AND a1.id_source = a.id_source_livre AND b1.statut = 5 AND b1.active = 1 AND b1.time_pub <= CURRENT_TIMESTAMP) as count_reponse,
b.id_auteur, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as nom_auteur
FROM source_livre a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur
WHERE a.id_source_livre = :id LIMIT 1
1 => SELECT b.id_source_livre, b.nom_source_livre, COUNT(*) as count_source_livre
FROM source_content a
LEFT JOIN source_livre b ON b.id_source_livre = a.id_source
LEFT JOIN qr_question c ON c.id_question = a.id_content
WHERE a.id_table = 'qr_question' AND a.type_source = 'livre' AND b.id_auteur = :id_auteur AND b.id_source_livre != :id_source_livre AND c.statut = 5 AND c.active = 1 AND c.time_pub <= CURRENT_TIMESTAMP
GROUP BY a.id_source
ORDER BY count_source_livre DESC
1 => SHOW FULL COLUMNS FROM source_content
1 => SHOW FULL COLUMNS FROM qr_question
1 => SHOW FULL COLUMNS FROM qr_reponse
1 => SHOW FULL COLUMNS FROM auteur
1 => SELECT SQL_CALC_FOUND_ROWS a.*, e.id_auteur, CONCAT(e.titre_auteur,e.prenom_auteur,' ',e.nom_auteur) as nom_auteur FROM source_content c LEFT JOIN qr_question a ON a.id_question = c.id_content 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 <= CURRENT_TIMESTAMP AND c.id_source = 1083 AND c.id_table = 'qr_question' AND c.type_source = 'livre' GROUP BY a.id_question ORDER BY a.time_pub DESC LIMIT 0,15
1 => SELECT FOUND_ROWS() AS total
