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