and p.cid = 3 and p.bid = 7 and p.mid = 24  and (p.area > 500 and p.area <= 1000)