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 asc,
 ITEM_CODE desc
;