SELECT	ProductID				AS 'ProductID',
		ProductGroupID			AS 'ProductGroupID',
		ProductName				AS 'ProductName',
		ProductDescription		AS 'ProductDescription',
		Keywords				AS 'Keywords',
		Active					AS 'Active',
		Colour					AS 'Colour',
		Materials				AS 'Materials',
		IsSale					AS 'IsSale',
		IsNew					AS 'IsNew',
		IsEco					AS 'IsEco',
		IsExpress				AS 'IsExpress',
		IsReach					AS 'IsReach',
		ShowOnWeb				AS 'ShowOnWeb',
		ImageFileName			AS 'ImageFileName',
		VideoFileName			AS 'VideoFileName',
		Dimensions				AS 'ProductDimensions',
		Weight					AS 'Weight',
		MaximumWeight			AS 'MaximumWeight',
		Volume					AS 'Volume',
		LogoPosition			AS 'LogoPosition',
		UVMaximumPrintArea		AS 'UVMaximumPrintArea',
		PrintArea				AS 'PrintArea',
		PrintCode				AS 'PrintCode',
		BrandingMethods			AS 'BrandingMethods',
		IF( 
			LOCATE( 'Transfer', BrandingMethods ) = 0,
			'No',
			'Yes'
		  )						AS 'UVApplies',
		IF( 
			LOCATE( 'Screen Print', BrandingMethods ) = 0,
			'No',
			'Yes'
		  )						AS 'ScreenPrintApplies',
		Plain100				AS 'Plain100',
		Plain250				AS 'Plain250',
		Plain500				AS 'Plain500',
		Plain1000				AS 'Plain1000',
		Screenprint100			AS 'SC100',
		Screenprint250			AS 'SC250',
		Screenprint500			AS 'SC500',
		Screenprint1000			AS 'SC1000',
		UV100					AS 'UV100',
		UV250					AS 'UV250',
		UV500					AS 'UV500',
		UV1000					AS 'UV1000',
		UpsellProductGroupID	AS 'UpsellProductGroupID',
		DownsellProductGroupID	AS 'DownsellProductGroupID',
		TariffCode				AS 'TariffCode',
		CountryOfOrigin			AS 'CountryOfOrigin',
		CarbonGMPerPiece		AS 'CarbonGMPerPiece'
FROM	Product
WHERE	ProductID = '{{{ProductID}}}'