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;