and p.cid = 1 and p.bid = 7 and p.mid = 8 and (p.area > 1000 and p.area <= 3000) and (p.month_area_price > 10000) and (p.least_rent_time <= 3)