select ITEM_POPULAR_RANK as RANK,ITEM_CODE as CODE,ITEM_NAME as NAME,RECOMMEND_ITEM_RANK as RCM_RANK
from ITEM
where ITEM_POPULAR_RANK
ORDER BY ITEM_POPULAR_RANK ASC,ITEM_CODE DESC