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