CARTELERA DE CINES EN, LIMA, PERÚ DE CINEPLANET SANTA CLARA
Dirección Centro Comercial Real Plaza Santa Clara. Fundo La Estrella. Carretera Central – Ate (Altura del KM 10.5 carretera central – Al costado de Plaza Vea). Ate. Lima. Perú
Teléfono Aló Planet (01)624-9500

SELECT * FROM pe_cineplanet_showtimes LEFT JOIN pe_cineplanet_theaters ON pe_cineplanet_theaters.theater_id = pe_cineplanet_showtimes.theater_id LEFT JOIN pe_cineplanet_films ON pe_cineplanet_films.film_id = pe_cineplanet_showtimes.film_id WHERE pe_cineplanet_theaters.theater_name = ‘Santa Clara’ AND pe_cineplanet_showtimes.showtime >= 1440997200 order by pe_cineplanet_films.film_name, pe_cineplanet_showtimes.is_3d, pe_cineplanet_showtimes.subtitle, pe_cineplanet_showtimes.showtime | Fecha query: August 31, 2015, 12:00 am