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;