Ein fehler ist aufgetreten.

Zum Nachladen klicken Sie bitte hier.

Wir entschuldigen uns für die Unannehmlichkeiten entschuldigen.

Ein Datenbankfehler ist aufgetreten

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cities_distance.distance<0 ) as tmpSchedule ON (tmpSchedule.cinemaID = cin' at line 10

SELECT cinemas.name as cinemaName, cinemas.shortName as cinemaShort, cinemas.adress, cinemas.zip, cinemas.city, cinemas.tel, cinemas.hasSchedule, cinemas.isOpenAir, cinemas.url_code, cinemas.cinemaID, cities.cityName, cities.url_code as city_url_code FROM (cities INNER JOIN cinemas ON (cities.cityID = cinemas.cityID) LEFT OUTER JOIN ( SELECT schedule.scheduleID, schedule.movieID, schedule.scheduleDate, schedule.cinemaID FROM cinemas INNER JOIN schedule ON (cinemas.cinemaID = schedule.cinemaID) INNER JOIN cities ON (cinemas.cityID = cities.cityID AND cities.countryID=67) INNER JOIN cities_distance ON (cities_distance.langID=5 AND cities_distance.cityID = cities.cityID) WHERE cities_distance.cityID = AND cities_distance.distance<0 ) as tmpSchedule ON (tmpSchedule.cinemaID = cinemas.cinemaID) LEFT OUTER JOIN moviesgenres ON (tmpSchedule.movieID = moviesgenres.movieID)) WHERE `cities`.`countryID` = '67' AND `cities`.`regionID` = '13' GROUP BY cinemas.cinemaID ORDER BY hasSchedule DESC, cities.sortOrder, cinemas.name