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