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;