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;