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