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;