SELECT * FROM cinema_films LEFT JOIN cinema_horaires ON cinema_horaires.id_film = cinema_films.id_film WHERE date_sortie <= CURDATE() AND date_sortie > '2024-07-20' AND affiche="O" AND etat="O" AND cinema_horaires.jour >= CURDATE() GROUP BY cinema_films.id_film ORDER BY date_sortie DESC
Envie d'afficher votre publicité ?
Contactez-nous