SELECT		ProductID		AS 'ProductID',
			ProductGroupID	AS 'ProductGroupID',
			ProductName		AS 'ProductName',
			Colour			AS 'Colour',
			IsSale			AS 'IsSale',
			IsNew			AS 'IsNew',
			IsEco			AS 'IsEco',
			IsExpress		AS 'IsExpress',
			IsReach			AS 'IsReach',
			ImageFileName	AS 'ImageFileName'
FROM		Product
WHERE		ProductGroupID	= '{{{ProductGroupID}}}'
AND			Active			= 'Yes'
AND			ShowOnWeb		= 'Yes'
ORDER BY	Colour,
			ProductName,
			ProductID