select ITEM_POPULAR_RANK as RANK, ITEM_CODE AS CODE, ITEM_NAME AS NAME FROM ITEM
WHERE RANK != '0'
ORDER BY RANK ASC, CODE ASC;