03-08-2026 19:19 |
0.4449s | 2.03Mo | PAGE 30 | VILLE 197799 |
MYSQL:10 |
URL:01 => 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.*, CONCAT(a.titre_auteur,a.prenom_auteur,' ',a.nom_auteur) as nom_auteur,
(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 = 'auteur' AND a1.id_source = a.id_auteur AND b1.statut = 5 AND b1.active = 1 AND b1.time_pub <= CURRENT_TIMESTAMP) as count_reponse
FROM auteur a WHERE a.id_auteur = :id LIMIT 1
1 => SELECT b.id_source_livre, b.nom_source_livre, COUNT(DISTINCT a.id_content) 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 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 = 1751 AND c.id_table = 'qr_question' AND c.type_source = 'auteur')) GROUP BY a.id_question ORDER BY a.time_pub DESC LIMIT 0,15
1 => SELECT FOUND_ROWS() AS total
