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
;