select
    item_popular_rank as RANK,
    item_code as CODE,
    item_name as NAME,
    recommend_item_rank as RCM_RANK
from
    item
order by
    RANK asc,
    CODE desc