SELECT 
ITEM_POPULAR_RANK,
ITEM_CODE,
ITEM_NAME,
ITEM_TYPE,
STOCK_MANAGEMENT_TYPE,
TAX_TYPE,
TAX_NO,
DELIVERY_TYPE_NO,
RECOMMEND_ITEM_RANK
FROM
ITEM
ORDER BY ITEM_POPULAR_RANK ASC;