CINE HOYTS CASA COSTANERA

CARTELERA DE CINES EN SANTIAGO ORIENTE – CHILE

Dirección CINE HOYTS  Casa Costanera Centro Comercial Casa Costanera. Avenida Nueva Costanera 3900 Local C 150. Vitacura, Santiago, Chile
Teléfono 6005000400

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 = ‘Casa Costanera’ AND cl_cinehoyts_showtimes.showtime >= 1508295600 order by cl_cinehoyts_films.film_name, cl_cinehoyts_showtimes.is_3d, cl_cinehoyts_showtimes.subtitle, cl_cinehoyts_showtimes.showtime | Fecha query: October 18, 2017, 12:00 am