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 >= 1586235600 order by mx_cinemagic_films.film_name, mx_cinemagic_showtimes.is_3d, mx_cinemagic_showtimes.subtitle, mx_cinemagic_showtimes.showtime | Fecha query: April 7, 2020, 12:00 am