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;