SELECT * FROM RoomList WHERE price2>0 and thestatus<>'3' and usetype='商場舖' and area2 between 0 and 99999 and price2 between 0 and 99999999 and (qsdistst&refno like '%%' or address like '%%' or area like '%%' or area2 like '%%' or price2 like '%%' or building like '%%' or EstateNo like '%%') ORDER BY in_date desc
