string(0) ""
string(2853) "SELECT   Product.ProductSN,  
	 					Product.UOMID AS ProductUOMID,  
	 					Product.ProductID,  
	 					Product.StatusSN AS StateID, 
	 					Product.IsStocked,
	 					Product.MaterialGroup,
	 					Product2Company.VKORG,
	 					Product2Company.onRequest,
	 					Product2ClassificationGroup.ClassificationGroupSN AS ProductGroupSN,
	 					SDZ_MaterialGroup2ProductArea.ProductArea as ProductArea,
	 					Attribute.AttributeID,
	 					Attribute.description AS AttributeDescription,
	 					Attribute.IsForComparison, 
	 					Attribute.IsForDetails,  
	 					Attribute.Type,  
	 					Attribute.UoMID AS AttributeUoMID,  
	 					Attribute.OrderNo AS AttributeOrderNo, 
	 					Attribute.IsForSearch,  
	 					Attribute.IsMultivalued,  
	 					Attribute.IsMultiLanguage, 
	 					Attribute.AttributeSectionSN,
	 					ProductAttributeValue.value AS Value, 
	 					ProductAttributeValue.ValueNeutral AS ValueNeutral, 
	 					ProductAttributeValue.OrderNo,
	 					Attribute.AttributeSectionID,
						Attribute.AttributeSectionOrderNo AS AttributeSectionOrderNo,  
						Attribute.AttributeSectionName AS AttributeSectionName, 
						Attribute.AttributeSectionDescription AS AttributeSectionDescription,
                        getPrice(Product.ProductID, 0,'0001') AS PriceSalesOrg,
						getPrice(Product.ProductID, 0,'0001') AS Price 	FROM    Product 	  		INNER JOIN  Product2ClassificationGroup    	  			ON	Product2ClassificationGroup.ProductSN = Product.ProductSN 	  		INNER JOIN  Product2Company    	  			ON	Product2Company.ProductSN = Product.ProductSN 				AND Product2Company.CompanyID = '0001'			INNER JOIN ClassificationGroup 				ON ClassificationGroup.ClassificationGroupSN = Product2ClassificationGroup.ClassificationGroupSN 				AND ClassificationGroup.LanguageID = 'en' AND ClassificationGroup.ClassificationID = 'Onlinekatalog' AND ClassificationGroup.ClassificationGroupSN > 0 	  		INNER JOIN  ProductAttributeValue ON ( 	  					ProductAttributeValue.ProductSN = Product.ProductSN 	 					AND (ifNull(ProductAttributeValue.LanguageID,'en') = 'en') 	  		) 	  		INNER JOIN Attribute ON ( 	  					Attribute.AttributeID = ProductAttributeValue.AttributeID 					AND Attribute.LanguageID = 'en'	  		) 
						LEFT JOIN SDZ_MaterialGroup2ProductArea ON SDZ_MaterialGroup2ProductArea.Materialgroup = Product.MaterialGroup WHERE  Product.ProductSN = '12087' AND isVisibleClassificationGroup(Product2ClassificationGroup.ClassificationGroupSN, 'XXXXX', '0001') = 1 			AND ClassificationGroup.SdzShopNumProducts > 0 			AND ProductAttributeValue.value is not null 			AND Product.ProductID NOT IN (	SELECT ProductID
				FROM SDZ_ProductExclusion
				WHERE CountryID = 'XXXXX'
				AND CompanyID = '0001')  ORDER BY  AttributeSectionOrderNo, Attribute.AttributeSectionID, AttributeID, cast(ProductAttributeValue.OrderNo AS SIGNED) 

"