SELECT
      ITEM_POPULAR_RANK AS RANK
    , ITEM_CODE AS CODE
    , ITEM_NAME AS NAME
FROM
    ITEM
WHERE 
    SALE_END_DATE is null
ORDER BY
    ITEM_POPULAR_RANK asc,
    ITEM_CODE asc
;