SELECT		ProductID			AS 'ProductID',
			Colour				AS 'Colour'
FROM		Product
WHERE		ProductGroupID		= '{{{ProductGroupID}}}'
AND			LOWER( ProductID )	<> LOWER( '{{{ProductID}}}' )
AND			Active				= 'Yes'
AND			ShowOnWeb			= 'Yes'
ORDER BY	Colour