CINEMAGIC CINEMAGIC ZACATLÁN

CARTELERA DE CINES EN ZACATLÁN – MÉXICO

Dirección CINEMAGIC  Cinemagic Zacatlán Plaza Mágica. Nigromante no. 2, Col. Centro. Zacatlán, Puebla. México.
Teléfono (797) 975 4445

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 Zacatlán’ AND mx_cinemagic_showtimes.showtime >= 1542520800 order by mx_cinemagic_films.film_name, mx_cinemagic_showtimes.is_3d, mx_cinemagic_showtimes.subtitle, mx_cinemagic_showtimes.showtime | Fecha query: November 18, 2018, 12:00 am