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