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',
			VideoFileName	AS 'VideoFileName'
FROM		Product
WHERE		Active			= 'Yes'
AND			ShowOnWeb		= 'Yes'
{{#KeyWords}}
AND			LOCATE( UPPER( '{{{.}}}' ), UPPER( Keywords ) ) <> 0
{{/KeyWords}}
{{#Attribute}}
AND			Is{{{Attribute}}} = 'Yes'
{{/Attribute}}
ORDER BY	Colour,
			ProductName,
			ProductID