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;