CINEMARK CINEMARK MALLPLAZA MIRADOR BIO BIO

CARTELERA DE CINES EN CONCEPCIÓN – CHILE

Dirección CINEMARK  Cinemark Mallplaza Mirador Bio Bio Mall Plaza Mirador Biobio. Los Carrera Poniente 301 local CN200. Concepción. Chile.
Teléfono (41) 290 6274

SELECT * FROM cl_cinemark_showtimes LEFT JOIN cl_cinemark_theaters ON cl_cinemark_theaters.theater_id = cl_cinemark_showtimes.theater_id LEFT JOIN cl_cinemark_films ON cl_cinemark_films.film_id = cl_cinemark_showtimes.film_id WHERE cl_cinemark_theaters.theater_name = ‘Cinemark Mallplaza Mirador Bio Bio’ AND cl_cinemark_showtimes.showtime >= 1558497600 order by cl_cinemark_films.film_name, cl_cinemark_showtimes.is_3d, cl_cinemark_showtimes.subtitle, cl_cinemark_showtimes.showtime | Fecha query: May 22, 2019, 12:00 am