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,RECOMMEND_ITEM_RANK DESC