SELECT
    ITEM_POPULAR_RANK AS RANK
    ,ITEM_CODE AS CODE
    ,ITEM_NAME AS NAME
    ,RECOMMEND_ITEM_RANK AS RCM_NAME
FROM
    ITEM
ORDER BY
    ITEM_POPULAR_RANK
    ,ITEM_CODE DESC;