select * from Property where RecycleBin=0 and Active=1 and CategoryID='10' and PropertyFor like '%Rent%' and CountryID='1' and RegionID>=1 and and PriceMonth>='0' and PriceMonth<='999999999' and BedroomsNo>='1' and BedroomsNo<='99' and SurfaceArea>='100' and SurfaceArea<='500' and Compound>=0 and PriceDay>=0 order by ID DESC LIMIT 0,10
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 PriceMonth>='0' and PriceMonth<='999999999' and BedroomsNo>='1' and Bedrooms' at line 1

Select All