Rav 'Haïm Yossef David AZOULAY ('HIDA)

15 => 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.*, 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 = 24 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 801 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 277 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 64 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1005 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 449 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 681 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 437 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 508 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 668 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 593 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 83 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 655 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 471 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 385 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 915 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 521 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1758 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 819 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 620 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1097 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 844 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 537 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1575 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 950 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1259 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 858 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 860 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 2235 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1303 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1062 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 859 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 2210 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 2397 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 436 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 1883 AND c.id_table = 'qr_question' AND c.type_source = 'livre') OR (c.id_source = 210 AND c.id_table = 'qr_question' AND c.type_source = 'auteur')) GROUP BY a.id_question ORDER BY a.time_pub DESC LIMIT 45,15

---

1 => SELECT FOUND_ROWS() AS total

---