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;