Películas en Cine en Guanajuato | México

SELECT mx_cinemex_films.film_name, mx_cinemex_films.film_name_clean, mx_cinemex_films.trailer_url, mx_cinemex_films.poster, mx_cinemex_films.synopsis, mx_cinemex_films.actores FROM mx_cinemex_showtimes LEFT JOIN mx_cinemex_theaters ON mx_cinemex_theaters.theater_id = mx_cinemex_showtimes.theater_id LEFT JOIN mx_cinemex_cities ON mx_cinemex_cities.city_id = mx_cinemex_theaters.city_id LEFT JOIN mx_cinemex_films ON mx_cinemex_films.film_id = mx_cinemex_showtimes.film_id WHERE mx_cinemex_cities.city_name = 'Guanajuato' AND mx_cinemex_showtimes.showtime >= 1398315600 UNION SELECT cinepolis_films.film_name, cinepolis_films.film_name_clean, cinepolis_films.trailer_url, cinepolis_films.poster, cinepolis_films.synopsis, cinepolis_films.actores FROM cinepolis_showtimes LEFT JOIN cinepolis_theaters ON cinepolis_theaters.theater_id = cinepolis_showtimes.theater_id LEFT JOIN cinepolis_cities ON cinepolis_cities.city_id = cinepolis_theaters.city_id LEFT JOIN cinepolis_films ON cinepolis_films.film_id = cinepolis_showtimes.film_id WHERE cinepolis_cities.city_name = 'Guanajuato' AND cinepolis_showtimes.showtime >= 1398315600 UNION SELECT mx_cinemark_films.film_name, mx_cinemark_films.film_name_clean, mx_cinemark_films.trailer_url, mx_cinemark_films.poster, mx_cinemark_films.synopsis, mx_cinemark_films.actores FROM mx_cinemark_showtimes LEFT JOIN mx_cinemark_theaters ON mx_cinemark_theaters.theater_id = mx_cinemark_showtimes.theater_id LEFT JOIN mx_cinemark_cities ON mx_cinemark_cities.city_id = mx_cinemark_theaters.city_id LEFT JOIN mx_cinemark_films ON mx_cinemark_films.film_id = mx_cinemark_showtimes.film_id WHERE mx_cinemark_cities.city_name = 'Guanajuato' AND mx_cinemark_showtimes.showtime >= 1398315600 order by film_name_clean
Table 'carteler_moviesdatab.mx_cinemark_showtimes' doesn't exist