Carteleras de Cine

SELECT * FROM mx_cinemagic_showtimes LEFT JOIN mx_cinemagic_theaters ON mx_cinemagic_theaters.theater_id = mx_cinemagic_showtimes.theater_id LEFT JOIN mx_cinemagic_films ON mx_cinemagic_films.film_id = mx_cinemagic_showtimes.film_id WHERE mx_cinemagic_theaters.theater_name = ‘Cinemagic Zacatlan’ AND mx_cinemagic_showtimes.showtime >= 1679637600 order by mx_cinemagic_films.film_name, mx_cinemagic_showtimes.is_3d, mx_cinemagic_showtimes.subtitle, mx_cinemagic_showtimes.showtime | Fecha query: March 24, 2023, 12:00 am