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