Shabatik Ekev 2026

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 * FROM shabatik WHERE time_pub <= :date AND active = 1 ORDER BY time_pub DESC LIMIT 1

---

1 => SELECT a.titre_shabatik, a.fichier_pdf, b.id_categorie FROM categorie_content b LEFT JOIN shabatik a ON a.id_shabatik = b.id_content WHERE b.id_table = 'shabatik' 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

---