Napaka pri odpiranju strani.

Če želite ponovno naložiti stran kliknite tukaj.

Za težavo se opravičujemo.

A Database Error Occurred

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=164) INNER JOIN cities_distance ON (cities_distance.langID=1 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` = '164' GROUP BY cinemas.cinemaID ORDER BY hasSchedule DESC, cities.sortOrder, cinemas.name