Halakhot Guédolot - Rav Shimon KIARA (3 réponses)

3 => 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 id_ville FROM torahboxbeta.ville WHERE place_id = :place_id LIMIT 1

---

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

---