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, ITEM_CODE desc
;