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
;