select
  ITEM_POPULAR_RANK as RANK
 ,ITEM_CODE as CODE
 ,ITEM_NAME as NAME
from
    ITEM as main
where
    SALE_END_DATE is null
order by
ITEM_POPULAR_RANK asc
,ITEM_CODE asc