SELECT
	ITEM_POPULAR_RANK AS RANK
	, ITEM_CODE AS CODE
	, ITEM_NAME AS NAME
FROM
	ITEM
WHERE
	SALE_END_DATE IS NOT NULL
ORDER BY
	RANK
	, CODE