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
;