and p.cid = 1 and p.bid = 4 and p.mid = 7   and (p.month_area_price > 500 and p.month_area_price <= 1000)