04-08-2026 20:48 |
0.6742s | 0.92Mo | PAGE 3 | VILLE 197799 |
MYSQL:13 |
URL:32 => 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 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 = 'kritout'
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 = '6'
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=kritout%2F6&token=e19dacf6cedd267395a6578b94ea00d6
1 => https://broadcast.torah-box.com/media.php?folder=daf-yomi%2Fkritout%2Fle-daf-eclair&details=0&token=e19dacf6cedd267395a6578b94ea00d6
1 => https://broadcast.torah-box.com/talmud.php?q=kritout&token=e19dacf6cedd267395a6578b94ea00d6
