select
    item_popular_rank as rank
    ,item_code as code
    ,item_name as name
from
    item
where
    sale_end_date is not null
order by
    1, 2