select
  ITEM_POPULAR_RANK as RANK
 ,ITEM_CODE as CODE
 ,ITEM_NAME as NAME
 ,RECOMMEND_ITEM_RANK as RCM_RANK
from
    ITEM as main
order by
     RANK asc
    ,CODE desc