Mille-Feuille de Chabbath... Ekev 5786

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

---

1 => SELECT titre, fichier_pdf FROM millefeuille WHERE time_pub <= CURRENT_DATE AND id_millefeuille != :id AND active = 1 ORDER BY time_pub DESC LIMIT 100

---