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 asc,
    code asc;