SELECT * FROM re WHERE re_type=1 AND ad_type=1 AND city_id=1 AND price<=500000 AND re_area<=10000 AND area_price<=10000 AND bedrooms<=2 AND bedrooms>=2 AND sector_id IN (53,56,59,78) AND district_id IN (5) AND ad_status=1 AND Public='Y' AND '2018-06-21 20:16:23' BETWEEN update_dt AND end_dt ORDER BY update_dt DESC LIMIT 0 ,20