SELECT
        ITEM_POPULAR_RANK AS RANK
       ,ITEM_CODE AS CODE
       ,ITEM_NAME AS NAME
    FROM
        ITEM
    WHERE
        SALE_END_DATE IS NULL
    ORDER BY
        RANK
       ,CODE