CINEMAGIC CINEMAGIC AJIJIC

CARTELERA DE CINES EN AJIJIC – MÉXICO

Dirección CINEMAGIC  Cinemagic Ajijic Carretera Ote. 54, 45920 Ajijic, Jal., Mexico
Teléfono +52 376 766 0438

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 Ajijic’ AND mx_cinemagic_showtimes.showtime >= 1566363600 order by mx_cinemagic_films.film_name, mx_cinemagic_showtimes.is_3d, mx_cinemagic_showtimes.subtitle, mx_cinemagic_showtimes.showtime | Fecha query: August 21, 2019, 12:00 am