MMC SUN MALL GUADALUPE

CARTELERA DE CINES EN 01800-7108888 – MÉXICO

Dirección   MMC Sun Mall Guadalupe Av. Pablo Livas No. 7601 Oriente Esq. Av. Prof. Israel Cavazos Garza, Col. Tres Caminos Guadalupe, N.L. México., ir con Waze Waze link
Teléfono 01800-7108888

SELECT * FROM mx_cinemex_showtimes LEFT JOIN mx_cinemex_theaters ON mx_cinemex_theaters.theater_id = mx_cinemex_showtimes.theater_id LEFT JOIN mx_cinemex_films ON mx_cinemex_films.film_id = mx_cinemex_showtimes.film_id WHERE mx_cinemex_theaters.theater_name = ‘MMC Sun Mall Guadalupe’ AND mx_cinemex_showtimes.showtime >= 1599800400 order by mx_cinemex_films.film_name, mx_cinemex_showtimes.is_3d, mx_cinemex_showtimes.subtitle, mx_cinemex_showtimes.showtime | Fecha query: September 11, 2020, 12:00 am