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 ASC,ITEM_CODE ASC;