select 
	ITEM_POPULAR_RANK as RANK,
	ITEM_CODE as CODE,
	ITEM_NAME as NAME,
	RECOMMEND_ITEM_RANK as RCM_RANK
from  ITEM
ORDER BY RANK ASC,CODE DESC;