Hotelsuche

Error: SELECT SQL_CALC_FOUND_ROWS db_booking_countries.countrycode ,db_booking_countries.languagecode , db_booking_countries.area AS name_kontinent , db_booking_countries.name AS name_land , db_booking_cities.name AS name_stadt , db_booking_cities.city_id , db_booking_hotels.address , db_booking_hotels.checkin_to , db_booking_hotels.checkin_from , db_booking_hotels.checkout_from , db_booking_hotels.checkout_to , db_booking_hotels.class , db_booking_hotels.currencycode , db_booking_hotels.hotel_id , db_booking_hotels.location_latitude , db_booking_hotels.location_longitude , db_booking_hotels.maxrate , db_booking_hotels.minrate , db_booking_hotels.name AS name_hotel , db_booking_hotels.nr_rooms , db_booking_hotels.preferred , db_booking_hotels.ranking , db_booking_hotels.review_nr , db_booking_hotels.review_score , db_booking_hotels.zip , db_booking_hotels.url , db_booking_hotelphotos.url_square60 , db_booking_hotelphotos.url_max300 FROM db_booking_countries INNER JOIN db_booking_cities ON (db_booking_countries.countrycode = db_booking_cities.countrycode) INNER JOIN db_booking_hotels ON (db_booking_cities.city_id = db_booking_hotels.city_id) LEFT JOIN db_booking_hotelphotos ON (db_booking_hotels.hotel_id = db_booking_hotelphotos.hotel_id) WHERE (db_booking_countries.languagecode ='de' AND db_booking_cities.languagecode ='de' AND db_booking_hotels.city_id = AND db_booking_hotels.preferred = 1 ) ORDER BY db_booking_hotels.review_score DESC LIMIT 0, 20

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 db_booking_hotels.preferred = 1 ) ORDER BY db_booking' at line 47