Feuillet du Rav Biderman Ekev 5786

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 id_categorie FROM categorie_content WHERE id_table = 'biderman' AND id_content = a.id_biderman LIMIT 1) as id_categorie FROM biderman a WHERE a.time_pub <= :date AND a.active = 1 ORDER BY a.time_pub DESC LIMIT 1

---

1 => SELECT a.titre, a.fichier_pdf, b.id_categorie FROM categorie_content b LEFT JOIN biderman a ON a.id_biderman = b.id_content WHERE b.id_table = 'biderman' AND a.time_pub <= CURRENT_DATE AND a.active = 1 ORDER BY a.time_pub DESC

---

1 => SELECT id_categorie as id, nom_fr_paracha as value FROM torah_paracha ORDER BY nom_fr_paracha ASC

---