05-08-2026 11:57 |
0.5338s | 1.15Mo | PAGE 0 | VILLE 197799 |
MYSQL:14 |
URL:12 => 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.alias_collection
FROM torah_livre a
LEFT JOIN torah_collection b ON b.id_collection = a.id_collection
WHERE a.id_collection = :id_collection
ORDER BY a.id_livre ASC
2 => SELECT id_collection FROM torah_livre WHERE id_livre = :id_livre LIMIT 1
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 * FROM torah_collection WHERE alias_collection = 'talmud' AND visible = 1 ORDER BY ordre_collection ASC
1 => SELECT a.*, b.alias_collection
FROM torah_livre a
LEFT JOIN torah_collection b ON b.id_collection = a.id_collection
WHERE a.id_collection = :id_collection AND a.alias_livre = 'pessa-him'
ORDER BY a.id_livre ASC
1 => SELECT * FROM torah_collection WHERE 1 AND visible = 1 ORDER BY ordre_collection ASC
1 => SELECT a.id_talmud, a.fichier_talmud, a.numero_talmud, b.alias_livre, c.id_collection, c.alias_collection, a.numero_talmud as numero_chapitre
FROM torah_talmud a
LEFT JOIN torah_livre b ON b.id_livre = a.id_livre
LEFT JOIN torah_collection c ON c.id_collection = b.id_collection
WHERE b.id_livre = :id_livre
GROUP BY a.numero_talmud
ORDER BY a.numero_talmud ASC
1 => SELECT a.id_talmud, a.fichier_talmud, a.numero_talmud, b.alias_livre, c.id_collection, c.alias_collection, a.numero_talmud as numero_chapitre
FROM torah_talmud a
LEFT JOIN torah_livre b ON b.id_livre = a.id_livre
LEFT JOIN torah_collection c ON c.id_collection = b.id_collection
WHERE b.id_livre = :id_livre
GROUP BY a.numero_talmud
HAVING numero_chapitre = '37'
ORDER BY a.numero_talmud ASC
1 => SELECT a.id_talmud, a.id_livre, a.numero_talmud, a.lettre_talmud, a.fichier_talmud,
b.alias_livre, c.alias_collection
FROM torah_talmud a
LEFT JOIN torah_livre b ON b.id_livre = a.id_livre
LEFT JOIN torah_collection c ON c.id_collection = b.id_collection
WHERE a.numero_talmud = :numero_talmud AND a.id_livre = :id_livre
1 => https://broadcast.torah-box.com/daf-hayomi.php?q=pessa-him%2F37&token=e19dacf6cedd267395a6578b94ea00d6
