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,item_code