and p.cid = 5 and p.bid = 7 and p.mid = 8  and (p.area > 500 and p.area <= 1000)