SELECT		ProductID		AS 'ProductID',
			ProductGroupID	AS 'ProductGroupID',
			ProductName		AS 'ProductName',
			Colour			AS 'Colour',
			Materials		AS 'Materials',
			Keywords		AS 'Keywords',
			IsSale			AS 'IsSale',
			IsNew			AS 'IsNew',
			IsEco			AS 'IsEco',
			IsExpress		AS 'IsExpress',
			IsReach			AS 'IsReach',
			ImageFileName	AS 'ImageFileName'
FROM		Product
WHERE		Active			= 'Yes'
AND			ShowOnWeb		= 'Yes'
{{#HaveProductIDs}}
AND			LOWER( ProductID ) IN ( {{{ProductIDList}}} )
{{/HaveProductIDs}}
ORDER BY	Colour,
			ProductID