Live Torah-Box

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 live WHERE active = 1 AND zoom_live = 0 AND (DATE_ADD(CURRENT_TIMESTAMP,INTERVAL 2 HOUR) >= time_debut AND time_fin >= CURRENT_TIMESTAMP) ORDER BY time_debut ASC LIMIT 1

---

1 => SELECT * FROM live WHERE time_debut >= CURRENT_TIMESTAMP AND active = 1 AND zoom_live = 0 ORDER BY time_debut ASC LIMIT 4

---

1 => SELECT a.*, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as nom_auteur FROM live a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur WHERE a.time_debut <= CURRENT_TIMESTAMP AND a.active = 1 AND a.zoom_live = 0 ORDER BY a.time_fin DESC LIMIT 6

---