string(0) ""
string(2629) "	SELECT 	
		Product.ProductSN, Product.UOMID AS ProductUOMID, Product.ProductID, Product.MaterialGroup,
	   	Product.StatusSN AS StateID, Product.IsStocked,  Attribute.AttributeID,
	   	Attribute.IsForComparison, Attribute.IsForDetails,  Attribute.Type,  Attribute.UoMID AS AttributeUoMID,
	   Attribute.OrderNo AS AttributeOrderNo, Attribute.IsForSearch, Attribute.IsMultivalued,
	   Attribute.IsMultiLanguage, Attribute.AttributeSectionSN,  Attribute.description AS AttributeDescription,
	   Attribute.AttributeSectionID,   Attribute.AttributeSectionOrderNo AS AttributeSectionOrderNo,
	   Attribute.AttributeSectionName AS AttributeSectionName,
	   Attribute.AttributeSectionDescription AS AttributeSectionDescription,
	   ProductAttributeValue.value AS Value,
	   ProductAttributeValue.ValueNeutral AS ValueNeutral,
	   Product2ClassificationGroup.ClassificationGroupSN AS ProductGroupSN,
	   Product2ClassificationGroup.ClassificationGroupSN  AS ChapterSN , 
       getPrice(Product.ProductID, 0,'0001') AS PriceSalesOrg,
	   getPrice(Product.ProductID, 0,'0001') AS Price,
	   Product2ClassificationGroup.onRequest As onRequest,
	   SDZ_MaterialGroup2ProductArea.ProductArea
	FROM
	   Product
	INNER JOIN   (
		SELECT 
		    Product2ClassificationGroup.ClassificationGroupSN, 
		    Product2ClassificationGroup.ProductSN, 
		    Product2ClassificationGroup.OrderNo,
		    Product2Company.onRequest
		FROM 
			Product2ClassificationGroup
		INNER JOIN Product
			ON Product.ProductSN = Product2ClassificationGroup.ProductSN
			AND Product.StatusSN = '4'
			AND Product.ProductID NOT IN (	SELECT ProductID
				FROM SDZ_ProductExclusion
				WHERE CountryID = 'XXXXX'
				AND CompanyID = '0001')	
  		INNER JOIN  Product2Company    
			ON	Product2Company.ProductSN = Product.ProductSN 
			AND Product2Company.CompanyID = '0001'
	    WHERE
	   		Product2ClassificationGroup.ClassificationGroupSN = '4411'
	   		
	   		ORDER BY ProductID
	   		LIMIT 0 , 12
	   
	   ) AS Product2ClassificationGroup
	   ON (
	   	Product.ProductSN = Product2ClassificationGroup.ProductSN 
	   )
	INNER JOIN  ProductAttributeValue 
		ON ( 
			ProductAttributeValue.ProductSN = Product.ProductSN 
	   		AND (ProductAttributeValue.LanguageID  = 'en') 
	   	)
	INNER JOIN  Attribute 
		ON ( 
			Attribute.AttributeID = ProductAttributeValue.AttributeID )
	      	AND (Attribute.LanguageID  = 'en') 
	LEFT JOIN SDZ_MaterialGroup2ProductArea ON SDZ_MaterialGroup2ProductArea.Materialgroup = Product.MaterialGroup
          
	ORDER BY  
			Product.ProductID, 	AttributeSectionOrderNo
		    

"