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 ASC
    , CODE DESC;