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, CODE;