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
    , code desc
;