SELECT		ProductID				AS 'ProductID',
					ProductGroupID	AS 'ProductGroupID',
					ProductName			AS 'ProductName',
					Colour					AS 'Colour',
					ImageFileName		AS 'ImageFilename'
FROM			Product
WHERE			Active			= 'Yes'
AND				ShowOnWeb		= 'Yes'
{{#Term}}
AND			(
					LOWER( ProductID ) 		  = '{{{.}}}' 		OR
					LOWER( ProductName ) LIKE '%{{{.}}}%'  OR
					LOWER( Colour ) 			  = '{{{.}}}' 		OR
					LOWER( Keywords ) 	 LIKE '%{{{.}}}%'
				)
{{/Term}}
ORDER BY 	ProductID			