SELECT 
	ITEM_POPULAR_RANK AS RANK
	,ITEM_CODE AS CODE
	,ITEM_NAME AS NAME
FROM
	ITEM

WHERE 
	IFNULL(SALE_END_DATE,CURRENT_DATE) <=  strftime('%Y-%m-%d', CURRENT_DATE)
ORDER BY
	ITEM_POPULAR_RANK
	,ITEM_CODE