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 ) where ztzimers.`active` = '1' and ztzimers.instance_id='0' AND tz_sub.sub_id_31 =1 AND ( price.price2 BETWEEN AND OR price.price4 BETWEEN 601 AND 700 OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND OR price.price2 BETWEEN AND ) GROUP BY ztzimers.id 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.price4 BETWEEN 601 AND 700 OR price.price2 BETWEEN AND ' at line 4