SELECT i.item_popular_rank RANK, i.item_code CODE, i.item_name NAME, i.recommend_item_rank RCM_RANK
FROM item i
ORDER BY i.item_popular_rank, i.item_code DESC;