CINE HOYTS ANTOFAGASTA PLAZA

CARTELERA DE CINES EN NORTE Y CENTRO DE CHILE – CHILE

Dirección CINE HOYTS  Antofagasta Plaza Mall Plaza Antofagasta. Av. Balmaceda 2355, Local C-300. Antofagasta. Chile.
Teléfono (2) 600 5000 400, cel (02) 2 756 0400.

SELECT * FROM cl_cinehoyts_showtimes LEFT JOIN cl_cinehoyts_theaters ON cl_cinehoyts_theaters.theater_id = cl_cinehoyts_showtimes.theater_id LEFT JOIN cl_cinehoyts_films ON cl_cinehoyts_films.film_id = cl_cinehoyts_showtimes.film_id WHERE cl_cinehoyts_theaters.theater_name = ‘Antofagasta Plaza’ AND cl_cinehoyts_showtimes.showtime >= 1500782400 order by cl_cinehoyts_films.film_name, cl_cinehoyts_showtimes.is_3d, cl_cinehoyts_showtimes.subtitle, cl_cinehoyts_showtimes.showtime | Fecha query: July 23, 2017, 12:00 am

Comparta con amigos