====== select * from Mls where DistrictID=2243 and PropertyFor='Sale' and CategoryID=3 group by CompanyCode ORDER BY UpdateStamp DESC =============

====== select * from Mls where RecycleBin=0 and Active=1 and RegionID>=0 and PropertyFor like '%sale%' and CityID in (45) and PropertyFor like '%sale%' and DistrictID in (2243) and PropertyFor like '%sale%' and CategoryID in (3) order by UpdateStamp DESC LIMIT 0,20 =============