Index: AX/Uitgaand/PM/Product/impl/ProductIterator.cls.xml
===================================================================
diff -u -r40702 -r40720
--- AX/Uitgaand/PM/Product/impl/ProductIterator.cls.xml	(.../ProductIterator.cls.xml)	(revision 40702)
+++ AX/Uitgaand/PM/Product/impl/ProductIterator.cls.xml	(.../ProductIterator.cls.xml)	(revision 40720)
@@ -39,7 +39,12 @@
 <Private>1</Private>
 <Implementation><![CDATA[
 	#dim SqlTableName As TECH.String = ##class(TECH.CompiledClassUtils).GetSQLTableName("Prod.Product")
-	#Dim SqlStatement as %String = "SELECT IdentNummer, OmschrijvingN1, OmschrijvingN2, KortTekst FROM "_SqlTableName_" WHERE ID IN ('1432226')"
+	#dim SqlTableName2 As TECH.String = ##class(TECH.CompiledClassUtils).GetSQLTableName("Prod.ProductTekst")
+	#Dim SqlStatement as %String
+	Set SqlStatement = "SELECT a.IdentNummer, a.OmschrijvingN1, a.OmschrijvingN2, b.OmschrijvingN3, b.OmschrijvingN4, b.OmschrijvingN5, KortTekst FROM "
+		_SqlTableName_" a, "_SqlTableName2_" b WHERE a.ProductNr = b.ProductNr AND a.ID IN ('1432225','1432226','1425096','1425095','682391','1359867','1168696','1168689','830507','1155640','161442'"
+		_",'906194','709825','924268','1124771','1038806','1039173','1039208','1247980','353741','353743','353744','254245','254258','1259381'"
+		_",'161441','665626','1067709','1067714','268026','1168369','668615','878186','878220','1169509','1194443','383880','830257')"
 	Set ..ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement))
 ]]></Implementation>
 </Method>