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 Huehuetoca’ AND mx_cinemagic_showtimes.showtime >= 1680156000 order by mx_cinemagic_films.film_name, mx_cinemagic_showtimes.is_3d, mx_cinemagic_showtimes.subtitle, mx_cinemagic_showtimes.showtime | Fecha query: March 30, 2023, 12:00 am