SELECT 		ProductID 													AS 'ProductID',
					ProductGroupID											AS 'ProductGroupID',
					ProductName													AS 'ProductName',
					TRIM( TRAILING ',' FROM Keywords ) 	AS 'Keywords',
					Colour															AS 'Colour',
					ImageFileName												AS 'ImageFilename'
FROM 			Product
WHERE 		Active 		= 'Yes'
AND 			ShowOnWeb = 'Yes'
AND 			LOCATE( '{{{Keyword}}}', LOWER( Keywords ) ) > 0
ORDER BY 	ProductID,
					ProductName