SELECT ztzimers.id,ztzimers.name,ztzimers.url,ztzimers.phone1,ztzimers.cordes_zimmer,ztzimers.price_min,ztzimers.price_min_wday,ztzimers.city_id,ztzimers.area_id,ztzimers.summary,ztzimers.num_rates,ztzimers.amount, images.location img_location, images.show_pics_nums , areas.name areaName, areas.url areaUrl, yashuv.name cityName, yashuv.url cityUrl FROM ztzimers left join images on(ztzimers.id=images.tzimer_id) left join price on(ztzimers.id=price.`tzimer_id`) left join areas on(ztzimers.area_id=areas.id) left join yashuv on(ztzimers.city_id=yashuv.id) LEFT JOIN tzimers_sub_cat AS tz_sub ON (ztzimers.id=tz_sub.tzimer_id ) LEFT JOIN pricesMin ON (ztzimers.id = pricesMin.`idCabin`) where ztzimers.`active` = '1' and ztzimers.instance_id='0' AND ztzimers.city_id IN (240,254,274,141,249,109,252,258,259,260,201,194,160,130,322,101,112,100,449,231,185,257,224,236,220,161,111,211,184,316,239,129,250) AND ( (price.price4 BETWEEN AND ) OR (price.price3 BETWEEN AND ) OR (price.price2 BETWEEN AND ) OR (price.price1 BETWEEN AND )) GROUP BY ztzimers.id ORDER BY RAND() 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 ) OR (price.price3 BETWEEN AND ) OR (price.price2 BETWEEN AND ) OR (' at line 5