SELECT * FROM re WHERE ad_type=3 AND re_type=1 AND rooms>=4 AND rooms<=4 AND ad_status=1 AND Public='Y' AND '2019-10-15 12:36:44' BETWEEN update_dt AND end_dt ORDER BY update_dt DESC LIMIT 0 ,20