select count(a.idx) as cnt from red_estat_item_default a, red_estat_item_info b where a.idx=b.idx and a.open=1 and (locate(concat('@',3ì.Â,'@'), concat(a.tradeidx,'@'))) and a.trade_type='5' order by a.ranking desc