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