select ITEM_POPULAR_RANK as RANK,ITEM_CODE as CODE,ITEM_NAME as NAME, RECOMMEND_ITEM_RANK as RCM_RANK
from ITEM
order by ITEM_POPULAR_RANK ASC, ITEM_CODE desc;