LINQ To SQL Samples - JOINOn This Page |
This sample uses foreign key navigation in the from clause to select all orders for customers in London.
Public Sub LinqToSqlJoin01()
Dim q = From c In db.Customers, o In c.Orders _
Where c.City = "London" _
Select o
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10289 CustomerID=BSBEV EmployeeID=7 OrderDate=8/26/1996 RequiredDate=9/23/1996 ShippedDate=8/28/1996 ShipVia=3 Freight=22.7700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10355 CustomerID=AROUT EmployeeID=6 OrderDate=11/15/1996 RequiredDate=12/13/1996 ShippedDate=11/20/1996 ShipVia=1 Freight=41.9500 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10359 CustomerID=SEVES EmployeeID=5 OrderDate=11/21/1996 RequiredDate=12/19/1996 ShippedDate=11/26/1996 ShipVia=3 Freight=288.4300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10364 CustomerID=EASTC EmployeeID=1 OrderDate=11/26/1996 RequiredDate=1/7/1997 ShippedDate=12/4/1996 ShipVia=1 Freight=71.9700 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10377 CustomerID=SEVES EmployeeID=1 OrderDate=12/9/1996 RequiredDate=1/6/1997 ShippedDate=12/13/1996 ShipVia=3 Freight=22.2100 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10383 CustomerID=AROUT EmployeeID=8 OrderDate=12/16/1996 RequiredDate=1/13/1997 ShippedDate=12/18/1996 ShipVia=3 Freight=34.2400 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10388 CustomerID=SEVES EmployeeID=2 OrderDate=12/19/1996 RequiredDate=1/16/1997 ShippedDate=12/20/1996 ShipVia=1 Freight=34.8600 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10400 CustomerID=EASTC EmployeeID=1 OrderDate=1/1/1997 RequiredDate=1/29/1997 ShippedDate=1/16/1997 ShipVia=3 Freight=83.9300 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10435 CustomerID=CONSH EmployeeID=8 OrderDate=2/4/1997 RequiredDate=3/18/1997 ShippedDate=2/7/1997 ShipVia=2 Freight=9.2100 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10453 CustomerID=AROUT EmployeeID=1 OrderDate=2/21/1997 RequiredDate=3/21/1997 ShippedDate=2/26/1997 ShipVia=2 Freight=25.3600 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10462 CustomerID=CONSH EmployeeID=2 OrderDate=3/3/1997 RequiredDate=3/31/1997 ShippedDate=3/18/1997 ShipVia=1 Freight=6.1700 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10471 CustomerID=BSBEV EmployeeID=2 OrderDate=3/11/1997 RequiredDate=4/8/1997 ShippedDate=3/18/1997 ShipVia=3 Freight=45.5900 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10472 CustomerID=SEVES EmployeeID=8 OrderDate=3/12/1997 RequiredDate=4/9/1997 ShippedDate=3/19/1997 ShipVia=1 Freight=4.2000 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10484 CustomerID=BSBEV EmployeeID=3 OrderDate=3/24/1997 RequiredDate=4/21/1997 ShippedDate=4/1/1997 ShipVia=3 Freight=6.8800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10517 CustomerID=NORTS EmployeeID=3 OrderDate=4/24/1997 RequiredDate=5/22/1997 ShippedDate=4/29/1997 ShipVia=3 Freight=32.0700 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10523 CustomerID=SEVES EmployeeID=7 OrderDate=5/1/1997 RequiredDate=5/29/1997 ShippedDate=5/30/1997 ShipVia=2 Freight=77.6300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10532 CustomerID=EASTC EmployeeID=7 OrderDate=5/9/1997 RequiredDate=6/6/1997 ShippedDate=5/12/1997 ShipVia=3 Freight=74.4600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10538 CustomerID=BSBEV EmployeeID=9 OrderDate=5/15/1997 RequiredDate=6/12/1997 ShippedDate=5/16/1997 ShipVia=3 Freight=4.8700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10539 CustomerID=BSBEV EmployeeID=6 OrderDate=5/16/1997 RequiredDate=6/13/1997 ShippedDate=5/23/1997 ShipVia=3 Freight=12.3600 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10547 CustomerID=SEVES EmployeeID=3 OrderDate=5/23/1997 RequiredDate=6/20/1997 ShippedDate=6/2/1997 ShipVia=2 Freight=178.4300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10558 CustomerID=AROUT EmployeeID=1 OrderDate=6/4/1997 RequiredDate=7/2/1997 ShippedDate=6/10/1997 ShipVia=2 Freight=72.9700 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10578 CustomerID=BSBEV EmployeeID=4 OrderDate=6/24/1997 RequiredDate=7/22/1997 ShippedDate=7/25/1997 ShipVia=3 Freight=29.6000 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10599 CustomerID=BSBEV EmployeeID=6 OrderDate=7/15/1997 RequiredDate=8/26/1997 ShippedDate=7/21/1997 ShipVia=3 Freight=29.9800 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10707 CustomerID=AROUT EmployeeID=4 OrderDate=10/16/1997 RequiredDate=10/30/1997 ShippedDate=10/23/1997 ShipVia=3 Freight=21.7400 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10726 CustomerID=EASTC EmployeeID=4 OrderDate=11/3/1997 RequiredDate=11/17/1997 ShippedDate=12/5/1997 ShipVia=1 Freight=16.5600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10741 CustomerID=AROUT EmployeeID=4 OrderDate=11/14/1997 RequiredDate=11/28/1997 ShippedDate=11/18/1997 ShipVia=3 Freight=10.9600 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10743 CustomerID=AROUT EmployeeID=1 OrderDate=11/17/1997 RequiredDate=12/15/1997 ShippedDate=11/21/1997 ShipVia=2 Freight=23.7200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10752 CustomerID=NORTS EmployeeID=2 OrderDate=11/24/1997 RequiredDate=12/22/1997 ShippedDate=11/28/1997 ShipVia=3 Freight=1.3900 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10768 CustomerID=AROUT EmployeeID=3 OrderDate=12/8/1997 RequiredDate=1/5/1998 ShippedDate=12/15/1997 ShipVia=2 Freight=146.3200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10793 CustomerID=AROUT EmployeeID=3 OrderDate=12/24/1997 RequiredDate=1/21/1998 ShippedDate=1/8/1998 ShipVia=3 Freight=4.5200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10800 CustomerID=SEVES EmployeeID=1 OrderDate=12/26/1997 RequiredDate=1/23/1998 ShippedDate=1/5/1998 ShipVia=3 Freight=137.4400 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10804 CustomerID=SEVES EmployeeID=6 OrderDate=12/30/1997 RequiredDate=1/27/1998 ShippedDate=1/7/1998 ShipVia=2 Freight=27.3300 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10848 CustomerID=CONSH EmployeeID=7 OrderDate=1/23/1998 RequiredDate=2/20/1998 ShippedDate=1/29/1998 ShipVia=2 Freight=38.2400 ShipName=Consolidated Holdings ShipAddress=Berkeley Gardens 12 Brewery ShipCity=London ShipRegion=null ShipPostalCode=WX1 6LT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10864 CustomerID=AROUT EmployeeID=4 OrderDate=2/2/1998 RequiredDate=3/2/1998 ShippedDate=2/9/1998 ShipVia=2 Freight=3.0400 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10869 CustomerID=SEVES EmployeeID=5 OrderDate=2/4/1998 RequiredDate=3/4/1998 ShippedDate=2/9/1998 ShipVia=1 Freight=143.2800 ShipName=Seven Seas Imports ShipAddress=90 Wadhurst Rd. ShipCity=London ShipRegion=null ShipPostalCode=OX15 4NB ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10920 CustomerID=AROUT EmployeeID=4 OrderDate=3/3/1998 RequiredDate=3/31/1998 ShippedDate=3/9/1998 ShipVia=2 Freight=29.6100 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10943 CustomerID=BSBEV EmployeeID=4 OrderDate=3/11/1998 RequiredDate=4/8/1998 ShippedDate=3/19/1998 ShipVia=2 Freight=2.1700 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10947 CustomerID=BSBEV EmployeeID=3 OrderDate=3/13/1998 RequiredDate=4/10/1998 ShippedDate=3/16/1998 ShipVia=2 Freight=3.2600 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10953 CustomerID=AROUT EmployeeID=9 OrderDate=3/16/1998 RequiredDate=3/30/1998 ShippedDate=3/25/1998 ShipVia=2 Freight=23.7200 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=10987 CustomerID=EASTC EmployeeID=8 OrderDate=3/31/1998 RequiredDate=4/28/1998 ShippedDate=4/6/1998 ShipVia=1 Freight=185.4800 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11016 CustomerID=AROUT EmployeeID=9 OrderDate=4/10/1998 RequiredDate=5/8/1998 ShippedDate=4/13/1998 ShipVia=2 Freight=33.8000 ShipName=Around the Horn ShipAddress=Brook Farm Stratford St. Mary ShipCity=Colchester ShipRegion=Essex ShipPostalCode=CO7 6JX ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11023 CustomerID=BSBEV EmployeeID=1 OrderDate=4/14/1998 RequiredDate=4/28/1998 ShippedDate=4/24/1998 ShipVia=2 Freight=123.8300 ShipName=B's Beverages ShipAddress=Fauntleroy Circus ShipCity=London ShipRegion=null ShipPostalCode=EC2 5NT ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11024 CustomerID=EASTC EmployeeID=4 OrderDate=4/15/1998 RequiredDate=5/13/1998 ShippedDate=4/20/1998 ShipVia=1 Freight=74.3600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11047 CustomerID=EASTC EmployeeID=7 OrderDate=4/24/1998 RequiredDate=5/22/1998 ShippedDate=5/1/1998 ShipVia=3 Freight=46.6200 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11056 CustomerID=EASTC EmployeeID=8 OrderDate=4/28/1998 RequiredDate=5/12/1998 ShippedDate=5/1/1998 ShipVia=2 Freight=278.9600 ShipName=Eastern Connection ShipAddress=35 King George ShipCity=London ShipRegion=null ShipPostalCode=WX3 6FW ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
OrderID=11057 CustomerID=NORTS EmployeeID=3 OrderDate=4/29/1998 RequiredDate=5/27/1998 ShippedDate=5/1/1998 ShipVia=3 Freight=4.1300 ShipName=North/South ShipAddress=South House 300 Queensbridge ShipCity=London ShipRegion=null ShipPostalCode=SW7 1RZ ShipCountry=UK Order_Details=... Employee={ } Customer={ } Shipper={ }
This sample uses foreign key navigation in the where clause to filter for Products whose Supplier is in the USA that are out of stock.
Public Sub LinqToSqlJoin02()
Dim q = From p In db.Products _
Where p.Supplier.Country = "USA" AndAlso p.UnitsInStock = 0
ObjectDumper.Write(q)
End Sub
Result:
ProductID=5 ProductName=Chef Anton's Gumbo Mix SupplierID=2 CategoryID=2 QuantityPerUnit=36 boxes UnitPrice=22.3500 UnitsInStock=0 UnitsOnOrder=0 ReorderLevel=0 Discontinued=True Order_Details=... Category={ } Supplier={ }
This sample uses foreign key navigation in the from clause to filter for employees in Seattle, and also list their territories.
Public Sub LinqToSqlJoin03()
Dim q = From e In db.Employees, et In e.EmployeeTerritories _
Where e.City = "Seattle" _
Select e.FirstName, e.LastName, et.Territory.TerritoryDescription
ObjectDumper.Write(q)
End Sub
Result:
FirstName=Nancy LastName=Davolio TerritoryDescription=Wilton
FirstName=Nancy LastName=Davolio TerritoryDescription=Neward
FirstName=Laura LastName=Callahan TerritoryDescription=Philadelphia
FirstName=Laura LastName=Callahan TerritoryDescription=Beachwood
FirstName=Laura LastName=Callahan TerritoryDescription=Findlay
FirstName=Laura LastName=Callahan TerritoryDescription=Racine
This sample uses foreign key navigation in the select clause to filter for pairs of employees where one employee reports to the other and where both employees are from the same City.
Public Sub LinqToSqlJoin04()
Dim q = From e1 In db.Employees, e2 In e1.Employees _
Where e1.City = e2.City _
Select FirstName1 = e1.FirstName, LastName1 = e1.LastName, _
FirstName2 = e2.FirstName, LastName2 = e2.LastName, e1.City
ObjectDumper.Write(q)
End Sub
Result:
City=London FirstName1=Steven FirstName2=Michael LastName1=Buchanan LastName2=Suyama
City=London FirstName1=Steven FirstName2=Robert LastName1=Buchanan LastName2=King
City=London FirstName1=Steven FirstName2=Anne LastName1=Buchanan LastName2=Dodsworth
This sample explictly joins two tables and projects results from both tables.
Public Sub LinqToSqlJoin05()
Dim q = From c In db.Customers _
Group Join o In db.Orders On c.CustomerID Equals o.CustomerID Into orders = Group _
Select New With {c.ContactName, .OrderCount = orders.Count()}
ObjectDumper.Write(q)
End Sub
Result:
ContactName=Maria Anders OrderCount=6
ContactName=Ana Trujillo OrderCount=4
ContactName=Antonio Moreno OrderCount=7
ContactName=Thomas Hardy OrderCount=13
ContactName=Christina Berglund OrderCount=18
ContactName=Hanna Moos OrderCount=7
ContactName=Frédérique Citeaux OrderCount=11
ContactName=Martín Sommer OrderCount=3
ContactName=Laurence Lebihan OrderCount=17
ContactName=Elizabeth Lincoln OrderCount=14
ContactName=Victoria Ashworth OrderCount=10
ContactName=Patricio Simpson OrderCount=6
ContactName=Francisco Chang OrderCount=1
ContactName=Yang Wang OrderCount=8
ContactName=Pedro Afonso OrderCount=5
ContactName=Elizabeth Brown OrderCount=3
ContactName=Sven Ottlieb OrderCount=6
ContactName=Janine Labrune OrderCount=4
ContactName=Ann Devon OrderCount=8
ContactName=Roland Mendel OrderCount=30
ContactName=Aria Cruz OrderCount=7
ContactName=Diego Roel OrderCount=0
ContactName=Martine Rancé OrderCount=5
ContactName=Maria Larsson OrderCount=19
ContactName=Peter Franken OrderCount=15
ContactName=Carine Schmitt OrderCount=3
ContactName=Paolo Accorti OrderCount=6
ContactName=Lino Rodriguez OrderCount=8
ContactName=Eduardo Saavedra OrderCount=5
ContactName=José Pedro Freyre OrderCount=10
ContactName=André Fonseca OrderCount=9
ContactName=Howard Snyder OrderCount=11
ContactName=Manuel Pereira OrderCount=2
ContactName=Mario Pontes OrderCount=14
ContactName=Carlos Hernández OrderCount=18
ContactName=Yoshi Latimer OrderCount=5
ContactName=Patricia McKenna OrderCount=19
ContactName=Helen Bennett OrderCount=10
ContactName=Philip Cramer OrderCount=14
ContactName=Daniel Tonini OrderCount=4
ContactName=Annette Roulet OrderCount=14
ContactName=Yoshi Tannamuri OrderCount=3
ContactName=John Steel OrderCount=2
ContactName=Renate Messner OrderCount=15
ContactName=Jaime Yorres OrderCount=4
ContactName=Carlos González OrderCount=14
ContactName=Felipe Izquierdo OrderCount=12
ContactName=Fran Wilson OrderCount=8
ContactName=Giovanni Rovelli OrderCount=10
ContactName=Catherine Dewey OrderCount=7
ContactName=Jean Fresnière OrderCount=13
ContactName=Alexander Feuer OrderCount=5
ContactName=Simon Crowther OrderCount=3
ContactName=Yvonne Moncada OrderCount=5
ContactName=Rene Phillips OrderCount=10
ContactName=Henriette Pfalzheim OrderCount=10
ContactName=Marie Bertrand OrderCount=0
ContactName=Guillermo Fernández OrderCount=6
ContactName=Georg Pipps OrderCount=10
ContactName=Isabel de Castro OrderCount=5
ContactName=Bernardo Batista OrderCount=9
ContactName=Lúcia Carvalho OrderCount=13
ContactName=Horst Kloss OrderCount=28
ContactName=Sergio Gutiérrez OrderCount=5
ContactName=Paula Wilson OrderCount=18
ContactName=Maurizio Moroni OrderCount=12
ContactName=Janete Limeira OrderCount=11
ContactName=Michael Holz OrderCount=10
ContactName=Alejandra Camino OrderCount=5
ContactName=Jonas Bergulfsen OrderCount=6
ContactName=Jose Pavarotti OrderCount=31
ContactName=Hari Kumar OrderCount=9
ContactName=Jytte Petersen OrderCount=7
ContactName=Dominique Perrier OrderCount=4
ContactName=Art Braunschweiger OrderCount=9
ContactName=Pascale Cartrain OrderCount=12
ContactName=Liz Nixon OrderCount=4
ContactName=Liu Wong OrderCount=3
ContactName=Karin Josephs OrderCount=6
ContactName=Miguel Angel Paolino OrderCount=10
ContactName=Anabela Domingues OrderCount=6
ContactName=Helvetius Nagy OrderCount=3
ContactName=Palle Ibsen OrderCount=11
ContactName=Mary Saveley OrderCount=10
ContactName=Paul Henriot OrderCount=5
ContactName=Rita Müller OrderCount=10
ContactName=Pirkko Koskitalo OrderCount=15
ContactName=Paula Parente OrderCount=9
ContactName=Karl Jablonski OrderCount=14
ContactName=Matti Karttunen OrderCount=7
ContactName=Zbyszek Piestrzeniewicz OrderCount=7
h
This sample explictly joins three tables and projects results from each of them.
Public Sub LinqToSqlJoin06()
Dim q = From c In db.Customers _
Group Join o In db.Orders On c.CustomerID Equals o.CustomerID Into ords = Group _
Group Join e In db.Employees On c.City Equals e.City Into emps = Group _
Select New With {c.ContactName, .ords = ords.Count(), .emps = emps.Count()}
ObjectDumper.Write(q)
End Sub
Result:
ContactName=Maria Anders emps=0 ords=6
ContactName=Ana Trujillo emps=0 ords=4
ContactName=Antonio Moreno emps=0 ords=7
ContactName=Thomas Hardy emps=4 ords=13
ContactName=Christina Berglund emps=0 ords=18
ContactName=Hanna Moos emps=0 ords=7
ContactName=Frédérique Citeaux emps=0 ords=11
ContactName=Martín Sommer emps=0 ords=3
ContactName=Laurence Lebihan emps=0 ords=17
ContactName=Elizabeth Lincoln emps=0 ords=14
ContactName=Victoria Ashworth emps=4 ords=10
ContactName=Patricio Simpson emps=0 ords=6
ContactName=Francisco Chang emps=0 ords=1
ContactName=Yang Wang emps=0 ords=8
ContactName=Pedro Afonso emps=0 ords=5
ContactName=Elizabeth Brown emps=4 ords=3
ContactName=Sven Ottlieb emps=0 ords=6
ContactName=Janine Labrune emps=0 ords=4
ContactName=Ann Devon emps=4 ords=8
ContactName=Roland Mendel emps=0 ords=30
ContactName=Aria Cruz emps=0 ords=7
ContactName=Diego Roel emps=0 ords=0
ContactName=Martine Rancé emps=0 ords=5
ContactName=Maria Larsson emps=0 ords=19
ContactName=Peter Franken emps=0 ords=15
ContactName=Carine Schmitt emps=0 ords=3
ContactName=Paolo Accorti emps=0 ords=6
ContactName=Lino Rodriguez emps=0 ords=8
ContactName=Eduardo Saavedra emps=0 ords=5
ContactName=José Pedro Freyre emps=0 ords=10
ContactName=André Fonseca emps=0 ords=9
ContactName=Howard Snyder emps=0 ords=11
ContactName=Manuel Pereira emps=0 ords=2
ContactName=Mario Pontes emps=0 ords=14
ContactName=Carlos Hernández emps=0 ords=18
ContactName=Yoshi Latimer emps=0 ords=5
ContactName=Patricia McKenna emps=0 ords=19
ContactName=Helen Bennett emps=0 ords=10
ContactName=Philip Cramer emps=0 ords=14
ContactName=Daniel Tonini emps=0 ords=4
ContactName=Annette Roulet emps=0 ords=14
ContactName=Yoshi Tannamuri emps=0 ords=3
ContactName=John Steel emps=0 ords=2
ContactName=Renate Messner emps=0 ords=15
ContactName=Jaime Yorres emps=0 ords=4
ContactName=Carlos González emps=0 ords=14
ContactName=Felipe Izquierdo emps=0 ords=12
ContactName=Fran Wilson emps=0 ords=8
ContactName=Giovanni Rovelli emps=0 ords=10
ContactName=Catherine Dewey emps=0 ords=7
ContactName=Jean Fresnière emps=0 ords=13
ContactName=Alexander Feuer emps=0 ords=5
ContactName=Simon Crowther emps=4 ords=3
ContactName=Yvonne Moncada emps=0 ords=5
ContactName=Rene Phillips emps=0 ords=10
ContactName=Henriette Pfalzheim emps=0 ords=10
ContactName=Marie Bertrand emps=0 ords=0
ContactName=Guillermo Fernández emps=0 ords=6
ContactName=Georg Pipps emps=0 ords=10
ContactName=Isabel de Castro emps=0 ords=5
ContactName=Bernardo Batista emps=0 ords=9
ContactName=Lúcia Carvalho emps=0 ords=13
ContactName=Horst Kloss emps=0 ords=28
ContactName=Sergio Gutiérrez emps=0 ords=5
ContactName=Paula Wilson emps=0 ords=18
ContactName=Maurizio Moroni emps=0 ords=12
ContactName=Janete Limeira emps=0 ords=11
ContactName=Michael Holz emps=0 ords=10
ContactName=Alejandra Camino emps=0 ords=5
ContactName=Jonas Bergulfsen emps=0 ords=6
ContactName=Jose Pavarotti emps=0 ords=31
ContactName=Hari Kumar emps=4 ords=9
ContactName=Jytte Petersen emps=0 ords=7
ContactName=Dominique Perrier emps=0 ords=4
ContactName=Art Braunschweiger emps=0 ords=9
ContactName=Pascale Cartrain emps=0 ords=12
ContactName=Liz Nixon emps=0 ords=4
ContactName=Liu Wong emps=0 ords=3
ContactName=Karin Josephs emps=0 ords=6
ContactName=Miguel Angel Paolino emps=0 ords=10
ContactName=Anabela Domingues emps=0 ords=6
ContactName=Helvetius Nagy emps=1 ords=3
ContactName=Palle Ibsen emps=0 ords=11
ContactName=Mary Saveley emps=0 ords=10
ContactName=Paul Henriot emps=0 ords=5
ContactName=Rita Müller emps=0 ords=10
ContactName=Pirkko Koskitalo emps=0 ords=15
ContactName=Paula Parente emps=0 ords=9
ContactName=Karl Jablonski emps=2 ords=14
ContactName=Matti Karttunen emps=0 ords=7
ContactName=Zbyszek Piestrzeniewicz emps=0 ords=7
This sample shows how to get LEFT OUTER JOIN by using DefaultIfEmpty(). The DefaultIfEmpty() method returns null when there is no Order for the Employee.
Public Sub LinqToSqlJoin07()
Dim q = From e In db.Employees _
Group Join o In db.Orders On e Equals o.Employee Into ords = Group _
From o In ords.DefaultIfEmpty _
Select New With {e.FirstName, e.LastName, .Order = o}
ObjectDumper.Write(q)
End Sub
Result:
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Nancy LastName=Davolio Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Andrew LastName=Fuller Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Janet LastName=Leverling Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Margaret LastName=Peacock Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Steven LastName=Buchanan Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Michael LastName=Suyama Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Robert LastName=King Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Laura LastName=Callahan Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
FirstName=Anne LastName=Dodsworth Order={ }
This sample projects a 'let' expression resulting from a join.
Public Sub LinqToSqlJoin08()
Dim q = From c In db.Customers _
Group Join o In db.Orders On c.CustomerID Equals o.CustomerID Into ords = Group _
Let z = c.City + c.Country _
From o In ords _
Select New With {c.ContactName, o.OrderID, z}
ObjectDumper.Write(q)
End Sub
Result:
ContactName=Maria Anders OrderID=10643 z=BerlinGermany
ContactName=Maria Anders OrderID=10692 z=BerlinGermany
ContactName=Maria Anders OrderID=10702 z=BerlinGermany
ContactName=Maria Anders OrderID=10835 z=BerlinGermany
ContactName=Maria Anders OrderID=10952 z=BerlinGermany
ContactName=Maria Anders OrderID=11011 z=BerlinGermany
ContactName=Ana Trujillo OrderID=10308 z=México D.F.Mexico
ContactName=Ana Trujillo OrderID=10625 z=México D.F.Mexico
ContactName=Ana Trujillo OrderID=10759 z=México D.F.Mexico
ContactName=Ana Trujillo OrderID=10926 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10365 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10507 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10535 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10573 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10677 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10682 z=México D.F.Mexico
ContactName=Antonio Moreno OrderID=10856 z=México D.F.Mexico
ContactName=Thomas Hardy OrderID=10355 z=LondonUK
ContactName=Thomas Hardy OrderID=10383 z=LondonUK
ContactName=Thomas Hardy OrderID=10453 z=LondonUK
ContactName=Thomas Hardy OrderID=10558 z=LondonUK
ContactName=Thomas Hardy OrderID=10707 z=LondonUK
ContactName=Thomas Hardy OrderID=10741 z=LondonUK
ContactName=Thomas Hardy OrderID=10743 z=LondonUK
ContactName=Thomas Hardy OrderID=10768 z=LondonUK
ContactName=Thomas Hardy OrderID=10793 z=LondonUK
ContactName=Thomas Hardy OrderID=10864 z=LondonUK
ContactName=Thomas Hardy OrderID=10920 z=LondonUK
ContactName=Thomas Hardy OrderID=10953 z=LondonUK
ContactName=Thomas Hardy OrderID=11016 z=LondonUK
ContactName=Christina Berglund OrderID=10278 z=LuleåSweden
ContactName=Christina Berglund OrderID=10280 z=LuleåSweden
ContactName=Christina Berglund OrderID=10384 z=LuleåSweden
ContactName=Christina Berglund OrderID=10444 z=LuleåSweden
ContactName=Christina Berglund OrderID=10445 z=LuleåSweden
ContactName=Christina Berglund OrderID=10524 z=LuleåSweden
ContactName=Christina Berglund OrderID=10572 z=LuleåSweden
ContactName=Christina Berglund OrderID=10626 z=LuleåSweden
ContactName=Christina Berglund OrderID=10654 z=LuleåSweden
ContactName=Christina Berglund OrderID=10672 z=LuleåSweden
ContactName=Christina Berglund OrderID=10689 z=LuleåSweden
ContactName=Christina Berglund OrderID=10733 z=LuleåSweden
ContactName=Christina Berglund OrderID=10778 z=LuleåSweden
ContactName=Christina Berglund OrderID=10837 z=LuleåSweden
ContactName=Christina Berglund OrderID=10857 z=LuleåSweden
ContactName=Christina Berglund OrderID=10866 z=LuleåSweden
ContactName=Christina Berglund OrderID=10875 z=LuleåSweden
ContactName=Christina Berglund OrderID=10924 z=LuleåSweden
ContactName=Hanna Moos OrderID=10501 z=MannheimGermany
ContactName=Hanna Moos OrderID=10509 z=MannheimGermany
ContactName=Hanna Moos OrderID=10582 z=MannheimGermany
ContactName=Hanna Moos OrderID=10614 z=MannheimGermany
ContactName=Hanna Moos OrderID=10853 z=MannheimGermany
ContactName=Hanna Moos OrderID=10956 z=MannheimGermany
ContactName=Hanna Moos OrderID=11058 z=MannheimGermany
ContactName=Frédérique Citeaux OrderID=10265 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10297 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10360 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10436 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10449 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10559 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10566 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10584 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10628 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10679 z=StrasbourgFrance
ContactName=Frédérique Citeaux OrderID=10826 z=StrasbourgFrance
ContactName=Martín Sommer OrderID=10326 z=MadridSpain
ContactName=Martín Sommer OrderID=10801 z=MadridSpain
ContactName=Martín Sommer OrderID=10970 z=MadridSpain
ContactName=Laurence Lebihan OrderID=10331 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10340 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10362 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10470 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10511 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10525 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10663 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10715 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10730 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10732 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10755 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10827 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10871 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10876 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10932 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=10940 z=MarseilleFrance
ContactName=Laurence Lebihan OrderID=11076 z=MarseilleFrance
ContactName=Elizabeth Lincoln OrderID=10389 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10410 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10411 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10431 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10492 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10742 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10918 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10944 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10949 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10975 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=10982 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=11027 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=11045 z=TsawassenCanada
ContactName=Elizabeth Lincoln OrderID=11048 z=TsawassenCanada
ContactName=Victoria Ashworth OrderID=10289 z=LondonUK
ContactName=Victoria Ashworth OrderID=10471 z=LondonUK
ContactName=Victoria Ashworth OrderID=10484 z=LondonUK
ContactName=Victoria Ashworth OrderID=10538 z=LondonUK
ContactName=Victoria Ashworth OrderID=10539 z=LondonUK
ContactName=Victoria Ashworth OrderID=10578 z=LondonUK
ContactName=Victoria Ashworth OrderID=10599 z=LondonUK
ContactName=Victoria Ashworth OrderID=10943 z=LondonUK
ContactName=Victoria Ashworth OrderID=10947 z=LondonUK
ContactName=Victoria Ashworth OrderID=11023 z=LondonUK
ContactName=Patricio Simpson OrderID=10521 z=Buenos AiresArgentina
ContactName=Patricio Simpson OrderID=10782 z=Buenos AiresArgentina
ContactName=Patricio Simpson OrderID=10819 z=Buenos AiresArgentina
ContactName=Patricio Simpson OrderID=10881 z=Buenos AiresArgentina
ContactName=Patricio Simpson OrderID=10937 z=Buenos AiresArgentina
ContactName=Patricio Simpson OrderID=11054 z=Buenos AiresArgentina
ContactName=Francisco Chang OrderID=10259 z=México D.F.Mexico
ContactName=Yang Wang OrderID=10254 z=BernSwitzerland
ContactName=Yang Wang OrderID=10370 z=BernSwitzerland
ContactName=Yang Wang OrderID=10519 z=BernSwitzerland
ContactName=Yang Wang OrderID=10731 z=BernSwitzerland
ContactName=Yang Wang OrderID=10746 z=BernSwitzerland
ContactName=Yang Wang OrderID=10966 z=BernSwitzerland
ContactName=Yang Wang OrderID=11029 z=BernSwitzerland
ContactName=Yang Wang OrderID=11041 z=BernSwitzerland
ContactName=Pedro Afonso OrderID=10290 z=Sao PauloBrazil
ContactName=Pedro Afonso OrderID=10466 z=Sao PauloBrazil
ContactName=Pedro Afonso OrderID=10494 z=Sao PauloBrazil
ContactName=Pedro Afonso OrderID=10969 z=Sao PauloBrazil
ContactName=Pedro Afonso OrderID=11042 z=Sao PauloBrazil
ContactName=Elizabeth Brown OrderID=10435 z=LondonUK
ContactName=Elizabeth Brown OrderID=10462 z=LondonUK
ContactName=Elizabeth Brown OrderID=10848 z=LondonUK
ContactName=Sven Ottlieb OrderID=10363 z=AachenGermany
ContactName=Sven Ottlieb OrderID=10391 z=AachenGermany
ContactName=Sven Ottlieb OrderID=10797 z=AachenGermany
ContactName=Sven Ottlieb OrderID=10825 z=AachenGermany
ContactName=Sven Ottlieb OrderID=11036 z=AachenGermany
ContactName=Sven Ottlieb OrderID=11067 z=AachenGermany
ContactName=Janine Labrune OrderID=10311 z=NantesFrance
ContactName=Janine Labrune OrderID=10609 z=NantesFrance
ContactName=Janine Labrune OrderID=10683 z=NantesFrance
ContactName=Janine Labrune OrderID=10890 z=NantesFrance
ContactName=Ann Devon OrderID=10364 z=LondonUK
ContactName=Ann Devon OrderID=10400 z=LondonUK
ContactName=Ann Devon OrderID=10532 z=LondonUK
ContactName=Ann Devon OrderID=10726 z=LondonUK
ContactName=Ann Devon OrderID=10987 z=LondonUK
ContactName=Ann Devon OrderID=11024 z=LondonUK
ContactName=Ann Devon OrderID=11047 z=LondonUK
ContactName=Ann Devon OrderID=11056 z=LondonUK
ContactName=Roland Mendel OrderID=10258 z=GrazAustria
ContactName=Roland Mendel OrderID=10263 z=GrazAustria
ContactName=Roland Mendel OrderID=10351 z=GrazAustria
ContactName=Roland Mendel OrderID=10368 z=GrazAustria
ContactName=Roland Mendel OrderID=10382 z=GrazAustria
ContactName=Roland Mendel OrderID=10390 z=GrazAustria
ContactName=Roland Mendel OrderID=10402 z=GrazAustria
ContactName=Roland Mendel OrderID=10403 z=GrazAustria
ContactName=Roland Mendel OrderID=10430 z=GrazAustria
ContactName=Roland Mendel OrderID=10442 z=GrazAustria
ContactName=Roland Mendel OrderID=10514 z=GrazAustria
ContactName=Roland Mendel OrderID=10571 z=GrazAustria
ContactName=Roland Mendel OrderID=10595 z=GrazAustria
ContactName=Roland Mendel OrderID=10633 z=GrazAustria
ContactName=Roland Mendel OrderID=10667 z=GrazAustria
ContactName=Roland Mendel OrderID=10698 z=GrazAustria
ContactName=Roland Mendel OrderID=10764 z=GrazAustria
ContactName=Roland Mendel OrderID=10771 z=GrazAustria
ContactName=Roland Mendel OrderID=10773 z=GrazAustria
ContactName=Roland Mendel OrderID=10776 z=GrazAustria
ContactName=Roland Mendel OrderID=10795 z=GrazAustria
ContactName=Roland Mendel OrderID=10836 z=GrazAustria
ContactName=Roland Mendel OrderID=10854 z=GrazAustria
ContactName=Roland Mendel OrderID=10895 z=GrazAustria
ContactName=Roland Mendel OrderID=10968 z=GrazAustria
ContactName=Roland Mendel OrderID=10979 z=GrazAustria
ContactName=Roland Mendel OrderID=10990 z=GrazAustria
ContactName=Roland Mendel OrderID=11008 z=GrazAustria
ContactName=Roland Mendel OrderID=11017 z=GrazAustria
ContactName=Roland Mendel OrderID=11072 z=GrazAustria
ContactName=Aria Cruz OrderID=10347 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10386 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10414 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10512 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10581 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10650 z=Sao PauloBrazil
ContactName=Aria Cruz OrderID=10725 z=Sao PauloBrazil
ContactName=Martine Rancé OrderID=10408 z=LilleFrance
ContactName=Martine Rancé OrderID=10480 z=LilleFrance
ContactName=Martine Rancé OrderID=10634 z=LilleFrance
ContactName=Martine Rancé OrderID=10763 z=LilleFrance
ContactName=Martine Rancé OrderID=10789 z=LilleFrance
ContactName=Maria Larsson OrderID=10264 z=BräckeSweden
ContactName=Maria Larsson OrderID=10327 z=BräckeSweden
ContactName=Maria Larsson OrderID=10378 z=BräckeSweden
ContactName=Maria Larsson OrderID=10434 z=BräckeSweden
ContactName=Maria Larsson OrderID=10460 z=BräckeSweden
ContactName=Maria Larsson OrderID=10533 z=BräckeSweden
ContactName=Maria Larsson OrderID=10561 z=BräckeSweden
ContactName=Maria Larsson OrderID=10703 z=BräckeSweden
ContactName=Maria Larsson OrderID=10762 z=BräckeSweden
ContactName=Maria Larsson OrderID=10774 z=BräckeSweden
ContactName=Maria Larsson OrderID=10824 z=BräckeSweden
ContactName=Maria Larsson OrderID=10880 z=BräckeSweden
ContactName=Maria Larsson OrderID=10902 z=BräckeSweden
ContactName=Maria Larsson OrderID=10955 z=BräckeSweden
ContactName=Maria Larsson OrderID=10977 z=BräckeSweden
ContactName=Maria Larsson OrderID=10980 z=BräckeSweden
ContactName=Maria Larsson OrderID=10993 z=BräckeSweden
ContactName=Maria Larsson OrderID=11001 z=BräckeSweden
ContactName=Maria Larsson OrderID=11050 z=BräckeSweden
ContactName=Peter Franken OrderID=10267 z=MünchenGermany
ContactName=Peter Franken OrderID=10337 z=MünchenGermany
ContactName=Peter Franken OrderID=10342 z=MünchenGermany
ContactName=Peter Franken OrderID=10396 z=MünchenGermany
ContactName=Peter Franken OrderID=10488 z=MünchenGermany
ContactName=Peter Franken OrderID=10560 z=MünchenGermany
ContactName=Peter Franken OrderID=10623 z=MünchenGermany
ContactName=Peter Franken OrderID=10653 z=MünchenGermany
ContactName=Peter Franken OrderID=10670 z=MünchenGermany
ContactName=Peter Franken OrderID=10675 z=MünchenGermany
ContactName=Peter Franken OrderID=10717 z=MünchenGermany
ContactName=Peter Franken OrderID=10791 z=MünchenGermany
ContactName=Peter Franken OrderID=10859 z=MünchenGermany
ContactName=Peter Franken OrderID=10929 z=MünchenGermany
ContactName=Peter Franken OrderID=11012 z=MünchenGermany
ContactName=Carine Schmitt OrderID=10671 z=NantesFrance
ContactName=Carine Schmitt OrderID=10860 z=NantesFrance
ContactName=Carine Schmitt OrderID=10971 z=NantesFrance
ContactName=Paolo Accorti OrderID=10422 z=TorinoItaly
ContactName=Paolo Accorti OrderID=10710 z=TorinoItaly
ContactName=Paolo Accorti OrderID=10753 z=TorinoItaly
ContactName=Paolo Accorti OrderID=10807 z=TorinoItaly
ContactName=Paolo Accorti OrderID=11026 z=TorinoItaly
ContactName=Paolo Accorti OrderID=11060 z=TorinoItaly
ContactName=Lino Rodriguez OrderID=10328 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10352 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10464 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10491 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10551 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10604 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10664 z=LisboaPortugal
ContactName=Lino Rodriguez OrderID=10963 z=LisboaPortugal
ContactName=Eduardo Saavedra OrderID=10366 z=BarcelonaSpain
ContactName=Eduardo Saavedra OrderID=10426 z=BarcelonaSpain
ContactName=Eduardo Saavedra OrderID=10568 z=BarcelonaSpain
ContactName=Eduardo Saavedra OrderID=10887 z=BarcelonaSpain
ContactName=Eduardo Saavedra OrderID=10928 z=BarcelonaSpain
ContactName=José Pedro Freyre OrderID=10303 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10550 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10629 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10872 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10874 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10888 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10911 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=10948 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=11009 z=SevillaSpain
ContactName=José Pedro Freyre OrderID=11037 z=SevillaSpain
ContactName=André Fonseca OrderID=10423 z=CampinasBrazil
ContactName=André Fonseca OrderID=10652 z=CampinasBrazil
ContactName=André Fonseca OrderID=10685 z=CampinasBrazil
ContactName=André Fonseca OrderID=10709 z=CampinasBrazil
ContactName=André Fonseca OrderID=10734 z=CampinasBrazil
ContactName=André Fonseca OrderID=10777 z=CampinasBrazil
ContactName=André Fonseca OrderID=10790 z=CampinasBrazil
ContactName=André Fonseca OrderID=10959 z=CampinasBrazil
ContactName=André Fonseca OrderID=11049 z=CampinasBrazil
ContactName=Howard Snyder OrderID=10528 z=EugeneUSA
ContactName=Howard Snyder OrderID=10589 z=EugeneUSA
ContactName=Howard Snyder OrderID=10616 z=EugeneUSA
ContactName=Howard Snyder OrderID=10617 z=EugeneUSA
ContactName=Howard Snyder OrderID=10656 z=EugeneUSA
ContactName=Howard Snyder OrderID=10681 z=EugeneUSA
ContactName=Howard Snyder OrderID=10816 z=EugeneUSA
ContactName=Howard Snyder OrderID=10936 z=EugeneUSA
ContactName=Howard Snyder OrderID=11006 z=EugeneUSA
ContactName=Howard Snyder OrderID=11040 z=EugeneUSA
ContactName=Howard Snyder OrderID=11061 z=EugeneUSA
ContactName=Manuel Pereira OrderID=10268 z=CaracasVenezuela
ContactName=Manuel Pereira OrderID=10785 z=CaracasVenezuela
ContactName=Mario Pontes OrderID=10250 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10253 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10541 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10645 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10690 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10770 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10783 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10886 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10903 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10922 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10925 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=10981 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=11022 z=Rio de JaneiroBrazil
ContactName=Mario Pontes OrderID=11052 z=Rio de JaneiroBrazil
ContactName=Carlos Hernández OrderID=10257 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10395 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10476 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10486 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10490 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10498 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10552 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10601 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10613 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10641 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10705 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10796 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10863 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10901 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10957 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10960 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=10976 z=San CristóbalVenezuela
ContactName=Carlos Hernández OrderID=11055 z=San CristóbalVenezuela
ContactName=Yoshi Latimer OrderID=10375 z=ElginUSA
ContactName=Yoshi Latimer OrderID=10394 z=ElginUSA
ContactName=Yoshi Latimer OrderID=10415 z=ElginUSA
ContactName=Yoshi Latimer OrderID=10600 z=ElginUSA
ContactName=Yoshi Latimer OrderID=10660 z=ElginUSA
ContactName=Patricia McKenna OrderID=10298 z=CorkIreland
ContactName=Patricia McKenna OrderID=10309 z=CorkIreland
ContactName=Patricia McKenna OrderID=10335 z=CorkIreland
ContactName=Patricia McKenna OrderID=10373 z=CorkIreland
ContactName=Patricia McKenna OrderID=10380 z=CorkIreland
ContactName=Patricia McKenna OrderID=10429 z=CorkIreland
ContactName=Patricia McKenna OrderID=10503 z=CorkIreland
ContactName=Patricia McKenna OrderID=10516 z=CorkIreland
ContactName=Patricia McKenna OrderID=10567 z=CorkIreland
ContactName=Patricia McKenna OrderID=10646 z=CorkIreland
ContactName=Patricia McKenna OrderID=10661 z=CorkIreland
ContactName=Patricia McKenna OrderID=10687 z=CorkIreland
ContactName=Patricia McKenna OrderID=10701 z=CorkIreland
ContactName=Patricia McKenna OrderID=10712 z=CorkIreland
ContactName=Patricia McKenna OrderID=10736 z=CorkIreland
ContactName=Patricia McKenna OrderID=10897 z=CorkIreland
ContactName=Patricia McKenna OrderID=10912 z=CorkIreland
ContactName=Patricia McKenna OrderID=10985 z=CorkIreland
ContactName=Patricia McKenna OrderID=11063 z=CorkIreland
ContactName=Helen Bennett OrderID=10315 z=CowesUK
ContactName=Helen Bennett OrderID=10318 z=CowesUK
ContactName=Helen Bennett OrderID=10321 z=CowesUK
ContactName=Helen Bennett OrderID=10473 z=CowesUK
ContactName=Helen Bennett OrderID=10621 z=CowesUK
ContactName=Helen Bennett OrderID=10674 z=CowesUK
ContactName=Helen Bennett OrderID=10749 z=CowesUK
ContactName=Helen Bennett OrderID=10798 z=CowesUK
ContactName=Helen Bennett OrderID=10829 z=CowesUK
ContactName=Helen Bennett OrderID=10933 z=CowesUK
ContactName=Philip Cramer OrderID=10323 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10325 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10456 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10457 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10468 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10506 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10542 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10630 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10718 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10799 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10817 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10849 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=10893 z=BrandenburgGermany
ContactName=Philip Cramer OrderID=11028 z=BrandenburgGermany
ContactName=Daniel Tonini OrderID=10858 z=VersaillesFrance
ContactName=Daniel Tonini OrderID=10927 z=VersaillesFrance
ContactName=Daniel Tonini OrderID=10972 z=VersaillesFrance
ContactName=Daniel Tonini OrderID=10973 z=VersaillesFrance
ContactName=Annette Roulet OrderID=10350 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10358 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10371 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10413 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10425 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10454 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10493 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10500 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10610 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10631 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10787 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10832 z=ToulouseFrance
ContactName=Annette Roulet OrderID=10923 z=ToulouseFrance
ContactName=Annette Roulet OrderID=11051 z=ToulouseFrance
ContactName=Yoshi Tannamuri OrderID=10495 z=VancouverCanada
ContactName=Yoshi Tannamuri OrderID=10620 z=VancouverCanada
ContactName=Yoshi Tannamuri OrderID=10810 z=VancouverCanada
ContactName=John Steel OrderID=10482 z=Walla WallaUSA
ContactName=John Steel OrderID=10545 z=Walla WallaUSA
ContactName=Renate Messner OrderID=10279 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10284 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10343 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10497 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10522 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10534 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10536 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10557 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10592 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10593 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10772 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10862 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10891 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=10934 z=Frankfurt a.M.Germany
ContactName=Renate Messner OrderID=11070 z=Frankfurt a.M.Germany
ContactName=Jaime Yorres OrderID=10579 z=San FranciscoUSA
ContactName=Jaime Yorres OrderID=10719 z=San FranciscoUSA
ContactName=Jaime Yorres OrderID=10735 z=San FranciscoUSA
ContactName=Jaime Yorres OrderID=10884 z=San FranciscoUSA
ContactName=Carlos González OrderID=10283 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10296 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10330 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10357 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10381 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10461 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10499 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10543 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10780 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10823 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10899 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=10997 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=11065 z=BarquisimetoVenezuela
ContactName=Carlos González OrderID=11071 z=BarquisimetoVenezuela
ContactName=Felipe Izquierdo OrderID=10405 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10485 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10638 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10697 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10729 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10811 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10838 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10840 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10919 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=10954 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=11014 z=I. de MargaritaVenezuela
ContactName=Felipe Izquierdo OrderID=11039 z=I. de MargaritaVenezuela
ContactName=Fran Wilson OrderID=10307 z=PortlandUSA
ContactName=Fran Wilson OrderID=10317 z=PortlandUSA
ContactName=Fran Wilson OrderID=10544 z=PortlandUSA
ContactName=Fran Wilson OrderID=10662 z=PortlandUSA
ContactName=Fran Wilson OrderID=10665 z=PortlandUSA
ContactName=Fran Wilson OrderID=10867 z=PortlandUSA
ContactName=Fran Wilson OrderID=10883 z=PortlandUSA
ContactName=Fran Wilson OrderID=11018 z=PortlandUSA
ContactName=Giovanni Rovelli OrderID=10275 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10300 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10404 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10467 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10635 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10754 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10784 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10818 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10939 z=BergamoItaly
ContactName=Giovanni Rovelli OrderID=10950 z=BergamoItaly
ContactName=Catherine Dewey OrderID=10529 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=10649 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=10760 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=10892 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=10896 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=10978 z=BruxellesBelgium
ContactName=Catherine Dewey OrderID=11004 z=BruxellesBelgium
ContactName=Jean Fresnière OrderID=10332 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10339 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10376 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10424 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10439 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10505 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10565 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10570 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10590 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10605 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10618 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10619 z=MontréalCanada
ContactName=Jean Fresnière OrderID=10724 z=MontréalCanada
ContactName=Alexander Feuer OrderID=10277 z=LeipzigGermany
ContactName=Alexander Feuer OrderID=10575 z=LeipzigGermany
ContactName=Alexander Feuer OrderID=10699 z=LeipzigGermany
ContactName=Alexander Feuer OrderID=10779 z=LeipzigGermany
ContactName=Alexander Feuer OrderID=10945 z=LeipzigGermany
ContactName=Simon Crowther OrderID=10517 z=LondonUK
ContactName=Simon Crowther OrderID=10752 z=LondonUK
ContactName=Simon Crowther OrderID=11057 z=LondonUK
ContactName=Yvonne Moncada OrderID=10409 z=Buenos AiresArgentina
ContactName=Yvonne Moncada OrderID=10531 z=Buenos AiresArgentina
ContactName=Yvonne Moncada OrderID=10898 z=Buenos AiresArgentina
ContactName=Yvonne Moncada OrderID=10958 z=Buenos AiresArgentina
ContactName=Yvonne Moncada OrderID=10986 z=Buenos AiresArgentina
ContactName=Rene Phillips OrderID=10305 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10338 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10441 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10594 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10680 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10706 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10808 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10855 z=AnchorageUSA
ContactName=Rene Phillips OrderID=10965 z=AnchorageUSA
ContactName=Rene Phillips OrderID=11034 z=AnchorageUSA
ContactName=Henriette Pfalzheim OrderID=10260 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10407 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10508 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10554 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10580 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10684 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10766 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10833 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=10999 z=KölnGermany
ContactName=Henriette Pfalzheim OrderID=11020 z=KölnGermany
ContactName=Guillermo Fernández OrderID=10322 z=México D.F.Mexico
ContactName=Guillermo Fernández OrderID=10354 z=México D.F.Mexico
ContactName=Guillermo Fernández OrderID=10474 z=México D.F.Mexico
ContactName=Guillermo Fernández OrderID=10502 z=México D.F.Mexico
ContactName=Guillermo Fernández OrderID=10995 z=México D.F.Mexico
ContactName=Guillermo Fernández OrderID=11073 z=México D.F.Mexico
ContactName=Georg Pipps OrderID=10353 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10392 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10427 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10489 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10530 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10597 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10686 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10747 z=SalzburgAustria
ContactName=Georg Pipps OrderID=10844 z=SalzburgAustria
ContactName=Georg Pipps OrderID=11053 z=SalzburgAustria
ContactName=Isabel de Castro OrderID=10336 z=LisboaPortugal
ContactName=Isabel de Castro OrderID=10397 z=LisboaPortugal
ContactName=Isabel de Castro OrderID=10433 z=LisboaPortugal
ContactName=Isabel de Castro OrderID=10477 z=LisboaPortugal
ContactName=Isabel de Castro OrderID=11007 z=LisboaPortugal
ContactName=Bernardo Batista OrderID=10261 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10291 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10379 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10421 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10587 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10647 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10720 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10794 z=Rio de JaneiroBrazil
ContactName=Bernardo Batista OrderID=10989 z=Rio de JaneiroBrazil
ContactName=Lúcia Carvalho OrderID=10372 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10406 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10487 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10637 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10659 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10704 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10728 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10786 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10868 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10913 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10914 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=10961 z=Sao PauloBrazil
ContactName=Lúcia Carvalho OrderID=11068 z=Sao PauloBrazil
ContactName=Horst Kloss OrderID=10273 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10285 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10286 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10313 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10345 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10361 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10418 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10451 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10515 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10527 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10540 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10549 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10588 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10658 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10691 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10694 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10721 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10745 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10765 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10788 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10845 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10865 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10878 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10938 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10962 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10991 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=10996 z=CunewaldeGermany
ContactName=Horst Kloss OrderID=11021 z=CunewaldeGermany
ContactName=Sergio Gutiérrez OrderID=10448 z=Buenos AiresArgentina
ContactName=Sergio Gutiérrez OrderID=10716 z=Buenos AiresArgentina
ContactName=Sergio Gutiérrez OrderID=10828 z=Buenos AiresArgentina
ContactName=Sergio Gutiérrez OrderID=10916 z=Buenos AiresArgentina
ContactName=Sergio Gutiérrez OrderID=11019 z=Buenos AiresArgentina
ContactName=Paula Wilson OrderID=10262 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10272 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10294 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10314 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10316 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10346 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10401 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10479 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10564 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10569 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10598 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10761 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10820 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10852 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10889 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=10988 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=11000 z=AlbuquerqueUSA
ContactName=Paula Wilson OrderID=11077 z=AlbuquerqueUSA
ContactName=Maurizio Moroni OrderID=10288 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10428 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10443 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10562 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10586 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10655 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10727 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10812 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10908 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=10942 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=11010 z=Reggio EmiliaItaly
ContactName=Maurizio Moroni OrderID=11062 z=Reggio EmiliaItaly
ContactName=Janete Limeira OrderID=10287 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10299 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10447 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10481 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10563 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10622 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10648 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10813 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10851 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=10877 z=Rio de JaneiroBrazil
ContactName=Janete Limeira OrderID=11059 z=Rio de JaneiroBrazil
ContactName=Michael Holz OrderID=10255 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10419 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10537 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10666 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10751 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10758 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10931 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=10951 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=11033 z=GenèveSwitzerland
ContactName=Michael Holz OrderID=11075 z=GenèveSwitzerland
ContactName=Alejandra Camino OrderID=10281 z=MadridSpain
ContactName=Alejandra Camino OrderID=10282 z=MadridSpain
ContactName=Alejandra Camino OrderID=10306 z=MadridSpain
ContactName=Alejandra Camino OrderID=10917 z=MadridSpain
ContactName=Alejandra Camino OrderID=11013 z=MadridSpain
ContactName=Jonas Bergulfsen OrderID=10387 z=StavernNorway
ContactName=Jonas Bergulfsen OrderID=10520 z=StavernNorway
ContactName=Jonas Bergulfsen OrderID=10639 z=StavernNorway
ContactName=Jonas Bergulfsen OrderID=10831 z=StavernNorway
ContactName=Jonas Bergulfsen OrderID=10909 z=StavernNorway
ContactName=Jonas Bergulfsen OrderID=11015 z=StavernNorway
ContactName=Jose Pavarotti OrderID=10324 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10393 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10398 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10440 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10452 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10510 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10555 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10603 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10607 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10612 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10627 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10657 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10678 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10700 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10711 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10713 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10714 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10722 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10748 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10757 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10815 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10847 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10882 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10894 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10941 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10983 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=10984 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=11002 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=11030 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=11031 z=BoiseUSA
ContactName=Jose Pavarotti OrderID=11064 z=BoiseUSA
ContactName=Hari Kumar OrderID=10359 z=LondonUK
ContactName=Hari Kumar OrderID=10377 z=LondonUK
ContactName=Hari Kumar OrderID=10388 z=LondonUK
ContactName=Hari Kumar OrderID=10472 z=LondonUK
ContactName=Hari Kumar OrderID=10523 z=LondonUK
ContactName=Hari Kumar OrderID=10547 z=LondonUK
ContactName=Hari Kumar OrderID=10800 z=LondonUK
ContactName=Hari Kumar OrderID=10804 z=LondonUK
ContactName=Hari Kumar OrderID=10869 z=LondonUK
ContactName=Jytte Petersen OrderID=10341 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=10417 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=10556 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=10642 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=10669 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=10802 z=KobenhavnDenmark
ContactName=Jytte Petersen OrderID=11074 z=KobenhavnDenmark
ContactName=Dominique Perrier OrderID=10738 z=ParisFrance
ContactName=Dominique Perrier OrderID=10907 z=ParisFrance
ContactName=Dominique Perrier OrderID=10964 z=ParisFrance
ContactName=Dominique Perrier OrderID=11043 z=ParisFrance
ContactName=Art Braunschweiger OrderID=10271 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10329 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10349 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10369 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10385 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10432 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10756 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10821 z=LanderUSA
ContactName=Art Braunschweiger OrderID=10974 z=LanderUSA
ContactName=Pascale Cartrain OrderID=10252 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10302 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10458 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10463 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10475 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10767 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10841 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10846 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10885 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=10930 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=11035 z=CharleroiBelgium
ContactName=Pascale Cartrain OrderID=11038 z=CharleroiBelgium
ContactName=Liz Nixon OrderID=10310 z=PortlandUSA
ContactName=Liz Nixon OrderID=10708 z=PortlandUSA
ContactName=Liz Nixon OrderID=10805 z=PortlandUSA
ContactName=Liz Nixon OrderID=10992 z=PortlandUSA
ContactName=Liu Wong OrderID=10624 z=ButteUSA
ContactName=Liu Wong OrderID=10775 z=ButteUSA
ContactName=Liu Wong OrderID=11003 z=ButteUSA
ContactName=Karin Josephs OrderID=10249 z=MünsterGermany
ContactName=Karin Josephs OrderID=10438 z=MünsterGermany
ContactName=Karin Josephs OrderID=10446 z=MünsterGermany
ContactName=Karin Josephs OrderID=10548 z=MünsterGermany
ContactName=Karin Josephs OrderID=10608 z=MünsterGermany
ContactName=Karin Josephs OrderID=10967 z=MünsterGermany
ContactName=Miguel Angel Paolino OrderID=10276 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10293 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10304 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10319 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10518 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10576 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10676 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10842 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=10915 z=México D.F.Mexico
ContactName=Miguel Angel Paolino OrderID=11069 z=México D.F.Mexico
ContactName=Anabela Domingues OrderID=10292 z=Sao PauloBrazil
ContactName=Anabela Domingues OrderID=10496 z=Sao PauloBrazil
ContactName=Anabela Domingues OrderID=10606 z=Sao PauloBrazil
ContactName=Anabela Domingues OrderID=10830 z=Sao PauloBrazil
ContactName=Anabela Domingues OrderID=10834 z=Sao PauloBrazil
ContactName=Anabela Domingues OrderID=10839 z=Sao PauloBrazil
ContactName=Helvetius Nagy OrderID=10574 z=KirklandUSA
ContactName=Helvetius Nagy OrderID=10577 z=KirklandUSA
ContactName=Helvetius Nagy OrderID=10822 z=KirklandUSA
ContactName=Palle Ibsen OrderID=10367 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10399 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10465 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10591 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10602 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10688 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10744 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10769 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10921 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10946 z=ÅrhusDenmark
ContactName=Palle Ibsen OrderID=10994 z=ÅrhusDenmark
ContactName=Mary Saveley OrderID=10251 z=LyonFrance
ContactName=Mary Saveley OrderID=10334 z=LyonFrance
ContactName=Mary Saveley OrderID=10450 z=LyonFrance
ContactName=Mary Saveley OrderID=10459 z=LyonFrance
ContactName=Mary Saveley OrderID=10478 z=LyonFrance
ContactName=Mary Saveley OrderID=10546 z=LyonFrance
ContactName=Mary Saveley OrderID=10806 z=LyonFrance
ContactName=Mary Saveley OrderID=10814 z=LyonFrance
ContactName=Mary Saveley OrderID=10843 z=LyonFrance
ContactName=Mary Saveley OrderID=10850 z=LyonFrance
ContactName=Paul Henriot OrderID=10248 z=ReimsFrance
ContactName=Paul Henriot OrderID=10274 z=ReimsFrance
ContactName=Paul Henriot OrderID=10295 z=ReimsFrance
ContactName=Paul Henriot OrderID=10737 z=ReimsFrance
ContactName=Paul Henriot OrderID=10739 z=ReimsFrance
ContactName=Rita Müller OrderID=10301 z=StuttgartGermany
ContactName=Rita Müller OrderID=10312 z=StuttgartGermany
ContactName=Rita Müller OrderID=10348 z=StuttgartGermany
ContactName=Rita Müller OrderID=10356 z=StuttgartGermany
ContactName=Rita Müller OrderID=10513 z=StuttgartGermany
ContactName=Rita Müller OrderID=10632 z=StuttgartGermany
ContactName=Rita Müller OrderID=10640 z=StuttgartGermany
ContactName=Rita Müller OrderID=10651 z=StuttgartGermany
ContactName=Rita Müller OrderID=10668 z=StuttgartGermany
ContactName=Rita Müller OrderID=11046 z=StuttgartGermany
ContactName=Pirkko Koskitalo OrderID=10270 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10320 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10333 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10412 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10416 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10437 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10455 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10526 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10553 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10583 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10636 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10750 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=10781 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=11025 z=OuluFinland
ContactName=Pirkko Koskitalo OrderID=11112 z=OuluFinland
ContactName=Paula Parente OrderID=10256 z=ResendeBrazil
ContactName=Paula Parente OrderID=10420 z=ResendeBrazil
ContactName=Paula Parente OrderID=10585 z=ResendeBrazil
ContactName=Paula Parente OrderID=10644 z=ResendeBrazil
ContactName=Paula Parente OrderID=10803 z=ResendeBrazil
ContactName=Paula Parente OrderID=10809 z=ResendeBrazil
ContactName=Paula Parente OrderID=10900 z=ResendeBrazil
ContactName=Paula Parente OrderID=10905 z=ResendeBrazil
ContactName=Paula Parente OrderID=10935 z=ResendeBrazil
ContactName=Karl Jablonski OrderID=10269 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10344 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10469 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10483 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10504 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10596 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10693 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10696 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10723 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10740 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10861 z=SeattleUSA
ContactName=Karl Jablonski OrderID=10904 z=SeattleUSA
ContactName=Karl Jablonski OrderID=11032 z=SeattleUSA
ContactName=Karl Jablonski OrderID=11066 z=SeattleUSA
ContactName=Matti Karttunen OrderID=10615 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=10673 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=10695 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=10873 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=10879 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=10910 z=HelsinkiFinland
ContactName=Matti Karttunen OrderID=11005 z=HelsinkiFinland
ContactName=Zbyszek Piestrzeniewicz OrderID=10374 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=10611 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=10792 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=10870 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=10906 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=10998 z=WarszawaPoland
ContactName=Zbyszek Piestrzeniewicz OrderID=11044 z=WarszawaPoland
This sample shows a join with a composite key.
Public Sub LinqToSqlJoin09()
Dim q = From o In db.Orders _
From p In db.Products _
Group Join d In db.Order_Details _
On New With {o.OrderID, p.ProductID} _
Equals New With {d.OrderID, d.ProductID} _
Into details = Group _
From d In details _
Select New With {o.OrderID, p.ProductID, d.UnitPrice}
ObjectDumper.Write(q)
End Sub
Result:
OrderID=10248 ProductID=11 UnitPrice=14.0000
OrderID=10248 ProductID=42 UnitPrice=9.8000
OrderID=10248 ProductID=72 UnitPrice=34.8000
OrderID=10249 ProductID=14 UnitPrice=18.6000
OrderID=10249 ProductID=51 UnitPrice=42.4000
OrderID=10250 ProductID=41 UnitPrice=7.7000
OrderID=10250 ProductID=51 UnitPrice=42.4000
OrderID=10250 ProductID=65 UnitPrice=16.8000
OrderID=10251 ProductID=22 UnitPrice=16.8000
OrderID=10251 ProductID=57 UnitPrice=15.6000
OrderID=10251 ProductID=65 UnitPrice=16.8000
OrderID=10252 ProductID=20 UnitPrice=64.8000
OrderID=10252 ProductID=33 UnitPrice=2.0000
OrderID=10252 ProductID=60 UnitPrice=27.2000
OrderID=10253 ProductID=31 UnitPrice=10.0000
OrderID=10253 ProductID=39 UnitPrice=14.4000
OrderID=10253 ProductID=49 UnitPrice=16.0000
OrderID=10254 ProductID=24 UnitPrice=3.6000
OrderID=10254 ProductID=55 UnitPrice=19.2000
OrderID=10254 ProductID=74 UnitPrice=8.0000
OrderID=10255 ProductID=2 UnitPrice=15.2000
OrderID=10255 ProductID=16 UnitPrice=13.9000
OrderID=10255 ProductID=36 UnitPrice=15.2000
OrderID=10255 ProductID=59 UnitPrice=44.0000
OrderID=10256 ProductID=53 UnitPrice=26.2000
OrderID=10256 ProductID=77 UnitPrice=10.4000
OrderID=10257 ProductID=27 UnitPrice=35.1000
OrderID=10257 ProductID=39 UnitPrice=14.4000
OrderID=10257 ProductID=77 UnitPrice=10.4000
OrderID=10258 ProductID=2 UnitPrice=15.2000
OrderID=10258 ProductID=5 UnitPrice=17.0000
OrderID=10258 ProductID=32 UnitPrice=25.6000
OrderID=10259 ProductID=21 UnitPrice=8.0000
OrderID=10259 ProductID=37 UnitPrice=20.8000
OrderID=10260 ProductID=41 UnitPrice=7.7000
OrderID=10260 ProductID=57 UnitPrice=15.6000
OrderID=10260 ProductID=62 UnitPrice=39.4000
OrderID=10260 ProductID=70 UnitPrice=12.0000
OrderID=10261 ProductID=21 UnitPrice=8.0000
OrderID=10261 ProductID=35 UnitPrice=14.4000
OrderID=10262 ProductID=5 UnitPrice=17.0000
OrderID=10262 ProductID=7 UnitPrice=24.0000
OrderID=10262 ProductID=56 UnitPrice=30.4000
OrderID=10263 ProductID=16 UnitPrice=13.9000
OrderID=10263 ProductID=24 UnitPrice=3.6000
OrderID=10263 ProductID=30 UnitPrice=20.7000
OrderID=10263 ProductID=74 UnitPrice=8.0000
OrderID=10264 ProductID=2 UnitPrice=15.2000
OrderID=10264 ProductID=41 UnitPrice=7.7000
OrderID=10265 ProductID=17 UnitPrice=31.2000
OrderID=10265 ProductID=70 UnitPrice=12.0000
OrderID=10267 ProductID=40 UnitPrice=14.7000
OrderID=10267 ProductID=59 UnitPrice=44.0000
OrderID=10267 ProductID=76 UnitPrice=14.4000
OrderID=10268 ProductID=29 UnitPrice=99.0000
OrderID=10268 ProductID=72 UnitPrice=27.8000
OrderID=10269 ProductID=33 UnitPrice=2.0000
OrderID=10269 ProductID=72 UnitPrice=27.8000
OrderID=10270 ProductID=36 UnitPrice=15.2000
OrderID=10270 ProductID=43 UnitPrice=36.8000
OrderID=10271 ProductID=33 UnitPrice=2.0000
OrderID=10272 ProductID=20 UnitPrice=64.8000
OrderID=10272 ProductID=31 UnitPrice=10.0000
OrderID=10272 ProductID=72 UnitPrice=27.8000
OrderID=10273 ProductID=10 UnitPrice=24.8000
OrderID=10273 ProductID=31 UnitPrice=10.0000
OrderID=10273 ProductID=33 UnitPrice=2.0000
OrderID=10273 ProductID=40 UnitPrice=14.7000
OrderID=10273 ProductID=76 UnitPrice=14.4000
OrderID=10274 ProductID=71 UnitPrice=17.2000
OrderID=10274 ProductID=72 UnitPrice=27.8000
OrderID=10275 ProductID=24 UnitPrice=3.6000
OrderID=10275 ProductID=59 UnitPrice=44.0000
OrderID=10276 ProductID=10 UnitPrice=24.8000
OrderID=10276 ProductID=13 UnitPrice=4.8000
OrderID=10277 ProductID=28 UnitPrice=36.4000
OrderID=10277 ProductID=62 UnitPrice=39.4000
OrderID=10278 ProductID=44 UnitPrice=15.5000
OrderID=10278 ProductID=59 UnitPrice=44.0000
OrderID=10278 ProductID=63 UnitPrice=35.1000
OrderID=10278 ProductID=73 UnitPrice=12.0000
OrderID=10279 ProductID=17 UnitPrice=31.2000
OrderID=10280 ProductID=24 UnitPrice=3.6000
OrderID=10280 ProductID=55 UnitPrice=19.2000
OrderID=10280 ProductID=75 UnitPrice=6.2000
OrderID=10281 ProductID=19 UnitPrice=7.3000
OrderID=10281 ProductID=24 UnitPrice=3.6000
OrderID=10281 ProductID=35 UnitPrice=14.4000
OrderID=10282 ProductID=30 UnitPrice=20.7000
OrderID=10282 ProductID=57 UnitPrice=15.6000
OrderID=10283 ProductID=15 UnitPrice=12.4000
OrderID=10283 ProductID=19 UnitPrice=7.3000
OrderID=10283 ProductID=60 UnitPrice=27.2000
OrderID=10283 ProductID=72 UnitPrice=27.8000
OrderID=10284 ProductID=27 UnitPrice=35.1000
OrderID=10284 ProductID=44 UnitPrice=15.5000
OrderID=10284 ProductID=60 UnitPrice=27.2000
OrderID=10284 ProductID=67 UnitPrice=11.2000
OrderID=10285 ProductID=1 UnitPrice=14.4000
OrderID=10285 ProductID=40 UnitPrice=14.7000
OrderID=10285 ProductID=53 UnitPrice=26.2000
OrderID=10286 ProductID=35 UnitPrice=14.4000
OrderID=10286 ProductID=62 UnitPrice=39.4000
OrderID=10287 ProductID=16 UnitPrice=13.9000
OrderID=10287 ProductID=34 UnitPrice=11.2000
OrderID=10287 ProductID=46 UnitPrice=9.6000
OrderID=10288 ProductID=54 UnitPrice=5.9000
OrderID=10288 ProductID=68 UnitPrice=10.0000
OrderID=10289 ProductID=3 UnitPrice=8.0000
OrderID=10289 ProductID=64 UnitPrice=26.6000
OrderID=10290 ProductID=5 UnitPrice=17.0000
OrderID=10290 ProductID=29 UnitPrice=99.0000
OrderID=10290 ProductID=49 UnitPrice=16.0000
OrderID=10290 ProductID=77 UnitPrice=10.4000
OrderID=10291 ProductID=13 UnitPrice=4.8000
OrderID=10291 ProductID=44 UnitPrice=15.5000
OrderID=10291 ProductID=51 UnitPrice=42.4000
OrderID=10292 ProductID=20 UnitPrice=64.8000
OrderID=10293 ProductID=18 UnitPrice=50.0000
OrderID=10293 ProductID=24 UnitPrice=3.6000
OrderID=10293 ProductID=63 UnitPrice=35.1000
OrderID=10293 ProductID=75 UnitPrice=6.2000
OrderID=10294 ProductID=1 UnitPrice=14.4000
OrderID=10294 ProductID=17 UnitPrice=31.2000
OrderID=10294 ProductID=43 UnitPrice=36.8000
OrderID=10294 ProductID=60 UnitPrice=27.2000
OrderID=10294 ProductID=75 UnitPrice=6.2000
OrderID=10295 ProductID=56 UnitPrice=30.4000
OrderID=10296 ProductID=11 UnitPrice=16.8000
OrderID=10296 ProductID=16 UnitPrice=13.9000
OrderID=10296 ProductID=69 UnitPrice=28.8000
OrderID=10297 ProductID=39 UnitPrice=14.4000
OrderID=10297 ProductID=72 UnitPrice=27.8000
OrderID=10298 ProductID=2 UnitPrice=15.2000
OrderID=10298 ProductID=36 UnitPrice=15.2000
OrderID=10298 ProductID=59 UnitPrice=44.0000
OrderID=10298 ProductID=62 UnitPrice=39.4000
OrderID=10299 ProductID=19 UnitPrice=7.3000
OrderID=10299 ProductID=70 UnitPrice=12.0000
OrderID=10300 ProductID=66 UnitPrice=13.6000
OrderID=10300 ProductID=68 UnitPrice=10.0000
OrderID=10301 ProductID=40 UnitPrice=14.7000
OrderID=10301 ProductID=56 UnitPrice=30.4000
OrderID=10302 ProductID=17 UnitPrice=31.2000
OrderID=10302 ProductID=28 UnitPrice=36.4000
OrderID=10302 ProductID=43 UnitPrice=36.8000
OrderID=10303 ProductID=40 UnitPrice=14.7000
OrderID=10303 ProductID=65 UnitPrice=16.8000
OrderID=10303 ProductID=68 UnitPrice=10.0000
OrderID=10304 ProductID=49 UnitPrice=16.0000
OrderID=10304 ProductID=59 UnitPrice=44.0000
OrderID=10304 ProductID=71 UnitPrice=17.2000
OrderID=10305 ProductID=18 UnitPrice=50.0000
OrderID=10305 ProductID=29 UnitPrice=99.0000
OrderID=10305 ProductID=39 UnitPrice=14.4000
OrderID=10306 ProductID=30 UnitPrice=20.7000
OrderID=10306 ProductID=53 UnitPrice=26.2000
OrderID=10306 ProductID=54 UnitPrice=5.9000
OrderID=10307 ProductID=62 UnitPrice=39.4000
OrderID=10307 ProductID=68 UnitPrice=10.0000
OrderID=10308 ProductID=69 UnitPrice=28.8000
OrderID=10308 ProductID=70 UnitPrice=12.0000
OrderID=10309 ProductID=4 UnitPrice=17.6000
OrderID=10309 ProductID=6 UnitPrice=20.0000
OrderID=10309 ProductID=42 UnitPrice=11.2000
OrderID=10309 ProductID=43 UnitPrice=36.8000
OrderID=10309 ProductID=71 UnitPrice=17.2000
OrderID=10310 ProductID=16 UnitPrice=13.9000
OrderID=10310 ProductID=62 UnitPrice=39.4000
OrderID=10311 ProductID=42 UnitPrice=11.2000
OrderID=10311 ProductID=69 UnitPrice=28.8000
OrderID=10312 ProductID=28 UnitPrice=36.4000
OrderID=10312 ProductID=43 UnitPrice=36.8000
OrderID=10312 ProductID=53 UnitPrice=26.2000
OrderID=10312 ProductID=75 UnitPrice=6.2000
OrderID=10313 ProductID=36 UnitPrice=15.2000
OrderID=10314 ProductID=32 UnitPrice=25.6000
OrderID=10314 ProductID=58 UnitPrice=10.6000
OrderID=10314 ProductID=62 UnitPrice=39.4000
OrderID=10315 ProductID=34 UnitPrice=11.2000
OrderID=10315 ProductID=70 UnitPrice=12.0000
OrderID=10316 ProductID=41 UnitPrice=7.7000
OrderID=10316 ProductID=62 UnitPrice=39.4000
OrderID=10317 ProductID=1 UnitPrice=14.4000
OrderID=10318 ProductID=41 UnitPrice=7.7000
OrderID=10318 ProductID=76 UnitPrice=14.4000
OrderID=10319 ProductID=17 UnitPrice=31.2000
OrderID=10319 ProductID=28 UnitPrice=36.4000
OrderID=10319 ProductID=76 UnitPrice=14.4000
OrderID=10320 ProductID=71 UnitPrice=17.2000
OrderID=10321 ProductID=35 UnitPrice=14.4000
OrderID=10322 ProductID=52 UnitPrice=5.6000
OrderID=10323 ProductID=15 UnitPrice=12.4000
OrderID=10323 ProductID=25 UnitPrice=11.2000
OrderID=10323 ProductID=39 UnitPrice=14.4000
OrderID=10324 ProductID=16 UnitPrice=13.9000
OrderID=10324 ProductID=35 UnitPrice=14.4000
OrderID=10324 ProductID=46 UnitPrice=9.6000
OrderID=10324 ProductID=59 UnitPrice=44.0000
OrderID=10324 ProductID=63 UnitPrice=35.1000
OrderID=10325 ProductID=6 UnitPrice=20.0000
OrderID=10325 ProductID=13 UnitPrice=4.8000
OrderID=10325 ProductID=14 UnitPrice=18.6000
OrderID=10325 ProductID=31 UnitPrice=10.0000
OrderID=10325 ProductID=72 UnitPrice=27.8000
OrderID=10326 ProductID=4 UnitPrice=17.6000
OrderID=10326 ProductID=57 UnitPrice=15.6000
OrderID=10326 ProductID=75 UnitPrice=6.2000
OrderID=10327 ProductID=2 UnitPrice=15.2000
OrderID=10327 ProductID=11 UnitPrice=16.8000
OrderID=10327 ProductID=30 UnitPrice=20.7000
OrderID=10327 ProductID=58 UnitPrice=10.6000
OrderID=10328 ProductID=59 UnitPrice=44.0000
OrderID=10328 ProductID=65 UnitPrice=16.8000
OrderID=10328 ProductID=68 UnitPrice=10.0000
OrderID=10329 ProductID=19 UnitPrice=7.3000
OrderID=10329 ProductID=30 UnitPrice=20.7000
OrderID=10329 ProductID=38 UnitPrice=210.8000
OrderID=10329 ProductID=56 UnitPrice=30.4000
OrderID=10330 ProductID=26 UnitPrice=24.9000
OrderID=10330 ProductID=72 UnitPrice=27.8000
OrderID=10331 ProductID=54 UnitPrice=5.9000
OrderID=10332 ProductID=18 UnitPrice=50.0000
OrderID=10332 ProductID=42 UnitPrice=11.2000
OrderID=10332 ProductID=47 UnitPrice=7.6000
OrderID=10333 ProductID=14 UnitPrice=18.6000
OrderID=10333 ProductID=21 UnitPrice=8.0000
OrderID=10333 ProductID=71 UnitPrice=17.2000
OrderID=10334 ProductID=52 UnitPrice=5.6000
OrderID=10334 ProductID=68 UnitPrice=10.0000
OrderID=10335 ProductID=2 UnitPrice=15.2000
OrderID=10335 ProductID=31 UnitPrice=10.0000
OrderID=10335 ProductID=32 UnitPrice=25.6000
OrderID=10335 ProductID=51 UnitPrice=42.4000
OrderID=10336 ProductID=4 UnitPrice=17.6000
OrderID=10337 ProductID=23 UnitPrice=7.2000
OrderID=10337 ProductID=26 UnitPrice=24.9000
OrderID=10337 ProductID=36 UnitPrice=15.2000
OrderID=10337 ProductID=37 UnitPrice=20.8000
OrderID=10337 ProductID=72 UnitPrice=27.8000
OrderID=10338 ProductID=17 UnitPrice=31.2000
OrderID=10338 ProductID=30 UnitPrice=20.7000
OrderID=10339 ProductID=4 UnitPrice=17.6000
OrderID=10339 ProductID=17 UnitPrice=31.2000
OrderID=10339 ProductID=62 UnitPrice=39.4000
OrderID=10340 ProductID=18 UnitPrice=50.0000
OrderID=10340 ProductID=41 UnitPrice=7.7000
OrderID=10340 ProductID=43 UnitPrice=36.8000
OrderID=10341 ProductID=33 UnitPrice=2.0000
OrderID=10341 ProductID=59 UnitPrice=44.0000
OrderID=10342 ProductID=2 UnitPrice=15.2000
OrderID=10342 ProductID=31 UnitPrice=10.0000
OrderID=10342 ProductID=36 UnitPrice=15.2000
OrderID=10342 ProductID=55 UnitPrice=19.2000
OrderID=10343 ProductID=64 UnitPrice=26.6000
OrderID=10343 ProductID=68 UnitPrice=10.0000
OrderID=10343 ProductID=76 UnitPrice=14.4000
OrderID=10344 ProductID=4 UnitPrice=17.6000
OrderID=10344 ProductID=8 UnitPrice=32.0000
OrderID=10345 ProductID=8 UnitPrice=32.0000
OrderID=10345 ProductID=19 UnitPrice=7.3000
OrderID=10345 ProductID=42 UnitPrice=11.2000
OrderID=10346 ProductID=17 UnitPrice=31.2000
OrderID=10346 ProductID=56 UnitPrice=30.4000
OrderID=10347 ProductID=25 UnitPrice=11.2000
OrderID=10347 ProductID=39 UnitPrice=14.4000
OrderID=10347 ProductID=40 UnitPrice=14.7000
OrderID=10347 ProductID=75 UnitPrice=6.2000
OrderID=10348 ProductID=1 UnitPrice=14.4000
OrderID=10348 ProductID=23 UnitPrice=7.2000
OrderID=10349 ProductID=54 UnitPrice=5.9000
OrderID=10350 ProductID=50 UnitPrice=13.0000
OrderID=10350 ProductID=69 UnitPrice=28.8000
OrderID=10351 ProductID=38 UnitPrice=210.8000
OrderID=10351 ProductID=41 UnitPrice=7.7000
OrderID=10351 ProductID=44 UnitPrice=15.5000
OrderID=10351 ProductID=65 UnitPrice=16.8000
OrderID=10352 ProductID=24 UnitPrice=3.6000
OrderID=10352 ProductID=54 UnitPrice=5.9000
OrderID=10353 ProductID=11 UnitPrice=16.8000
OrderID=10353 ProductID=38 UnitPrice=210.8000
OrderID=10354 ProductID=1 UnitPrice=14.4000
OrderID=10354 ProductID=29 UnitPrice=99.0000
OrderID=10355 ProductID=24 UnitPrice=3.6000
OrderID=10355 ProductID=57 UnitPrice=15.6000
OrderID=10356 ProductID=31 UnitPrice=10.0000
OrderID=10356 ProductID=55 UnitPrice=19.2000
OrderID=10356 ProductID=69 UnitPrice=28.8000
OrderID=10357 ProductID=10 UnitPrice=24.8000
OrderID=10357 ProductID=26 UnitPrice=24.9000
OrderID=10357 ProductID=60 UnitPrice=27.2000
OrderID=10358 ProductID=24 UnitPrice=3.6000
OrderID=10358 ProductID=34 UnitPrice=11.2000
OrderID=10358 ProductID=36 UnitPrice=15.2000
OrderID=10359 ProductID=16 UnitPrice=13.9000
OrderID=10359 ProductID=31 UnitPrice=10.0000
OrderID=10359 ProductID=60 UnitPrice=27.2000
OrderID=10360 ProductID=28 UnitPrice=36.4000
OrderID=10360 ProductID=29 UnitPrice=99.0000
OrderID=10360 ProductID=38 UnitPrice=210.8000
OrderID=10360 ProductID=49 UnitPrice=16.0000
OrderID=10360 ProductID=54 UnitPrice=5.9000
OrderID=10361 ProductID=39 UnitPrice=14.4000
OrderID=10361 ProductID=60 UnitPrice=27.2000
OrderID=10362 ProductID=25 UnitPrice=11.2000
OrderID=10362 ProductID=51 UnitPrice=42.4000
OrderID=10362 ProductID=54 UnitPrice=5.9000
OrderID=10363 ProductID=31 UnitPrice=10.0000
OrderID=10363 ProductID=75 UnitPrice=6.2000
OrderID=10363 ProductID=76 UnitPrice=14.4000
OrderID=10364 ProductID=69 UnitPrice=28.8000
OrderID=10364 ProductID=71 UnitPrice=17.2000
OrderID=10365 ProductID=11 UnitPrice=16.8000
OrderID=10366 ProductID=65 UnitPrice=16.8000
OrderID=10366 ProductID=77 UnitPrice=10.4000
OrderID=10367 ProductID=34 UnitPrice=11.2000
OrderID=10367 ProductID=54 UnitPrice=5.9000
OrderID=10367 ProductID=65 UnitPrice=16.8000
OrderID=10367 ProductID=77 UnitPrice=10.4000
OrderID=10368 ProductID=21 UnitPrice=8.0000
OrderID=10368 ProductID=28 UnitPrice=36.4000
OrderID=10368 ProductID=57 UnitPrice=15.6000
OrderID=10368 ProductID=64 UnitPrice=26.6000
OrderID=10369 ProductID=29 UnitPrice=99.0000
OrderID=10369 ProductID=56 UnitPrice=30.4000
OrderID=10370 ProductID=1 UnitPrice=14.4000
OrderID=10370 ProductID=64 UnitPrice=26.6000
OrderID=10370 ProductID=74 UnitPrice=8.0000
OrderID=10371 ProductID=36 UnitPrice=15.2000
OrderID=10372 ProductID=20 UnitPrice=64.8000
OrderID=10372 ProductID=38 UnitPrice=210.8000
OrderID=10372 ProductID=60 UnitPrice=27.2000
OrderID=10372 ProductID=72 UnitPrice=27.8000
OrderID=10373 ProductID=58 UnitPrice=10.6000
OrderID=10373 ProductID=71 UnitPrice=17.2000
OrderID=10374 ProductID=31 UnitPrice=10.0000
OrderID=10374 ProductID=58 UnitPrice=10.6000
OrderID=10375 ProductID=14 UnitPrice=18.6000
OrderID=10375 ProductID=54 UnitPrice=5.9000
OrderID=10376 ProductID=31 UnitPrice=10.0000
OrderID=10377 ProductID=28 UnitPrice=36.4000
OrderID=10377 ProductID=39 UnitPrice=14.4000
OrderID=10378 ProductID=71 UnitPrice=17.2000
OrderID=10379 ProductID=41 UnitPrice=7.7000
OrderID=10379 ProductID=63 UnitPrice=35.1000
OrderID=10379 ProductID=65 UnitPrice=16.8000
OrderID=10380 ProductID=30 UnitPrice=20.7000
OrderID=10380 ProductID=53 UnitPrice=26.2000
OrderID=10380 ProductID=60 UnitPrice=27.2000
OrderID=10380 ProductID=70 UnitPrice=12.0000
OrderID=10381 ProductID=74 UnitPrice=8.0000
OrderID=10382 ProductID=5 UnitPrice=17.0000
OrderID=10382 ProductID=18 UnitPrice=50.0000
OrderID=10382 ProductID=29 UnitPrice=99.0000
OrderID=10382 ProductID=33 UnitPrice=2.0000
OrderID=10382 ProductID=74 UnitPrice=8.0000
OrderID=10383 ProductID=13 UnitPrice=4.8000
OrderID=10383 ProductID=50 UnitPrice=13.0000
OrderID=10383 ProductID=56 UnitPrice=30.4000
OrderID=10384 ProductID=20 UnitPrice=64.8000
OrderID=10384 ProductID=60 UnitPrice=27.2000
OrderID=10385 ProductID=7 UnitPrice=24.0000
OrderID=10385 ProductID=60 UnitPrice=27.2000
OrderID=10385 ProductID=68 UnitPrice=10.0000
OrderID=10386 ProductID=24 UnitPrice=3.6000
OrderID=10386 ProductID=34 UnitPrice=11.2000
OrderID=10387 ProductID=24 UnitPrice=3.6000
OrderID=10387 ProductID=28 UnitPrice=36.4000
OrderID=10387 ProductID=59 UnitPrice=44.0000
OrderID=10387 ProductID=71 UnitPrice=17.2000
OrderID=10388 ProductID=45 UnitPrice=7.6000
OrderID=10388 ProductID=52 UnitPrice=5.6000
OrderID=10388 ProductID=53 UnitPrice=26.2000
OrderID=10389 ProductID=10 UnitPrice=24.8000
OrderID=10389 ProductID=55 UnitPrice=19.2000
OrderID=10389 ProductID=62 UnitPrice=39.4000
OrderID=10389 ProductID=70 UnitPrice=12.0000
OrderID=10390 ProductID=31 UnitPrice=10.0000
OrderID=10390 ProductID=35 UnitPrice=14.4000
OrderID=10390 ProductID=46 UnitPrice=9.6000
OrderID=10390 ProductID=72 UnitPrice=27.8000
OrderID=10391 ProductID=13 UnitPrice=4.8000
OrderID=10392 ProductID=69 UnitPrice=28.8000
OrderID=10393 ProductID=2 UnitPrice=15.2000
OrderID=10393 ProductID=14 UnitPrice=18.6000
OrderID=10393 ProductID=25 UnitPrice=11.2000
OrderID=10393 ProductID=26 UnitPrice=24.9000
OrderID=10393 ProductID=31 UnitPrice=10.0000
OrderID=10394 ProductID=13 UnitPrice=4.8000
OrderID=10394 ProductID=62 UnitPrice=39.4000
OrderID=10395 ProductID=46 UnitPrice=9.6000
OrderID=10395 ProductID=53 UnitPrice=26.2000
OrderID=10395 ProductID=69 UnitPrice=28.8000
OrderID=10396 ProductID=23 UnitPrice=7.2000
OrderID=10396 ProductID=71 UnitPrice=17.2000
OrderID=10396 ProductID=72 UnitPrice=27.8000
OrderID=10397 ProductID=21 UnitPrice=8.0000
OrderID=10397 ProductID=51 UnitPrice=42.4000
OrderID=10398 ProductID=35 UnitPrice=14.4000
OrderID=10398 ProductID=55 UnitPrice=19.2000
OrderID=10399 ProductID=68 UnitPrice=10.0000
OrderID=10399 ProductID=71 UnitPrice=17.2000
OrderID=10399 ProductID=76 UnitPrice=14.4000
OrderID=10399 ProductID=77 UnitPrice=10.4000
OrderID=10400 ProductID=29 UnitPrice=99.0000
OrderID=10400 ProductID=35 UnitPrice=14.4000
OrderID=10400 ProductID=49 UnitPrice=16.0000
OrderID=10401 ProductID=30 UnitPrice=20.7000
OrderID=10401 ProductID=56 UnitPrice=30.4000
OrderID=10401 ProductID=65 UnitPrice=16.8000
OrderID=10401 ProductID=71 UnitPrice=17.2000
OrderID=10402 ProductID=23 UnitPrice=7.2000
OrderID=10402 ProductID=63 UnitPrice=35.1000
OrderID=10403 ProductID=16 UnitPrice=13.9000
OrderID=10403 ProductID=48 UnitPrice=10.2000
OrderID=10404 ProductID=26 UnitPrice=24.9000
OrderID=10404 ProductID=42 UnitPrice=11.2000
OrderID=10404 ProductID=49 UnitPrice=16.0000
OrderID=10405 ProductID=3 UnitPrice=8.0000
OrderID=10406 ProductID=1 UnitPrice=14.4000
OrderID=10406 ProductID=21 UnitPrice=8.0000
OrderID=10406 ProductID=28 UnitPrice=36.4000
OrderID=10406 ProductID=36 UnitPrice=15.2000
OrderID=10406 ProductID=40 UnitPrice=14.7000
OrderID=10407 ProductID=11 UnitPrice=16.8000
OrderID=10407 ProductID=69 UnitPrice=28.8000
OrderID=10407 ProductID=71 UnitPrice=17.2000
OrderID=10408 ProductID=37 UnitPrice=20.8000
OrderID=10408 ProductID=54 UnitPrice=5.9000
OrderID=10408 ProductID=62 UnitPrice=39.4000
OrderID=10409 ProductID=14 UnitPrice=18.6000
OrderID=10409 ProductID=21 UnitPrice=8.0000
OrderID=10410 ProductID=33 UnitPrice=2.0000
OrderID=10410 ProductID=59 UnitPrice=44.0000
OrderID=10411 ProductID=41 UnitPrice=7.7000
OrderID=10411 ProductID=44 UnitPrice=15.5000
OrderID=10411 ProductID=59 UnitPrice=44.0000
OrderID=10412 ProductID=14 UnitPrice=18.6000
OrderID=10413 ProductID=1 UnitPrice=14.4000
OrderID=10413 ProductID=62 UnitPrice=39.4000
OrderID=10413 ProductID=76 UnitPrice=14.4000
OrderID=10414 ProductID=19 UnitPrice=7.3000
OrderID=10414 ProductID=33 UnitPrice=2.0000
OrderID=10415 ProductID=17 UnitPrice=31.2000
OrderID=10415 ProductID=33 UnitPrice=2.0000
OrderID=10416 ProductID=19 UnitPrice=7.3000
OrderID=10416 ProductID=53 UnitPrice=26.2000
OrderID=10416 ProductID=57 UnitPrice=15.6000
OrderID=10417 ProductID=38 UnitPrice=210.8000
OrderID=10417 ProductID=46 UnitPrice=9.6000
OrderID=10417 ProductID=68 UnitPrice=10.0000
OrderID=10417 ProductID=77 UnitPrice=10.4000
OrderID=10418 ProductID=2 UnitPrice=15.2000
OrderID=10418 ProductID=47 UnitPrice=7.6000
OrderID=10418 ProductID=61 UnitPrice=22.8000
OrderID=10418 ProductID=74 UnitPrice=8.0000
OrderID=10419 ProductID=60 UnitPrice=27.2000
OrderID=10419 ProductID=69 UnitPrice=28.8000
OrderID=10420 ProductID=9 UnitPrice=77.6000
OrderID=10420 ProductID=13 UnitPrice=4.8000
OrderID=10420 ProductID=70 UnitPrice=12.0000
OrderID=10420 ProductID=73 UnitPrice=12.0000
OrderID=10421 ProductID=19 UnitPrice=7.3000
OrderID=10421 ProductID=26 UnitPrice=24.9000
OrderID=10421 ProductID=53 UnitPrice=26.2000
OrderID=10421 ProductID=77 UnitPrice=10.4000
OrderID=10422 ProductID=26 UnitPrice=24.9000
OrderID=10423 ProductID=31 UnitPrice=10.0000
OrderID=10423 ProductID=59 UnitPrice=44.0000
OrderID=10424 ProductID=35 UnitPrice=14.4000
OrderID=10424 ProductID=38 UnitPrice=210.8000
OrderID=10424 ProductID=68 UnitPrice=10.0000
OrderID=10425 ProductID=55 UnitPrice=19.2000
OrderID=10425 ProductID=76 UnitPrice=14.4000
OrderID=10426 ProductID=56 UnitPrice=30.4000
OrderID=10426 ProductID=64 UnitPrice=26.6000
OrderID=10427 ProductID=14 UnitPrice=18.6000
OrderID=10428 ProductID=46 UnitPrice=9.6000
OrderID=10429 ProductID=50 UnitPrice=13.0000
OrderID=10429 ProductID=63 UnitPrice=35.1000
OrderID=10430 ProductID=17 UnitPrice=31.2000
OrderID=10430 ProductID=21 UnitPrice=8.0000
OrderID=10430 ProductID=56 UnitPrice=30.4000
OrderID=10430 ProductID=59 UnitPrice=44.0000
OrderID=10431 ProductID=17 UnitPrice=31.2000
OrderID=10431 ProductID=40 UnitPrice=14.7000
OrderID=10431 ProductID=47 UnitPrice=7.6000
OrderID=10432 ProductID=26 UnitPrice=24.9000
OrderID=10432 ProductID=54 UnitPrice=5.9000
OrderID=10433 ProductID=56 UnitPrice=30.4000
OrderID=10434 ProductID=11 UnitPrice=16.8000
OrderID=10434 ProductID=76 UnitPrice=14.4000
OrderID=10435 ProductID=2 UnitPrice=15.2000
OrderID=10435 ProductID=22 UnitPrice=16.8000
OrderID=10435 ProductID=72 UnitPrice=27.8000
OrderID=10436 ProductID=46 UnitPrice=9.6000
OrderID=10436 ProductID=56 UnitPrice=30.4000
OrderID=10436 ProductID=64 UnitPrice=26.6000
OrderID=10436 ProductID=75 UnitPrice=6.2000
OrderID=10437 ProductID=53 UnitPrice=26.2000
OrderID=10438 ProductID=19 UnitPrice=7.3000
OrderID=10438 ProductID=34 UnitPrice=11.2000
OrderID=10438 ProductID=57 UnitPrice=15.6000
OrderID=10439 ProductID=12 UnitPrice=30.4000
OrderID=10439 ProductID=16 UnitPrice=13.9000
OrderID=10439 ProductID=64 UnitPrice=26.6000
OrderID=10439 ProductID=74 UnitPrice=8.0000
OrderID=10440 ProductID=2 UnitPrice=15.2000
OrderID=10440 ProductID=16 UnitPrice=13.9000
OrderID=10440 ProductID=29 UnitPrice=99.0000
OrderID=10440 ProductID=61 UnitPrice=22.8000
OrderID=10441 ProductID=27 UnitPrice=35.1000
OrderID=10442 ProductID=11 UnitPrice=16.8000
OrderID=10442 ProductID=54 UnitPrice=5.9000
OrderID=10442 ProductID=66 UnitPrice=13.6000
OrderID=10443 ProductID=11 UnitPrice=16.8000
OrderID=10443 ProductID=28 UnitPrice=36.4000
OrderID=10444 ProductID=17 UnitPrice=31.2000
OrderID=10444 ProductID=26 UnitPrice=24.9000
OrderID=10444 ProductID=35 UnitPrice=14.4000
OrderID=10444 ProductID=41 UnitPrice=7.7000
OrderID=10445 ProductID=39 UnitPrice=14.4000
OrderID=10445 ProductID=54 UnitPrice=5.9000
OrderID=10446 ProductID=19 UnitPrice=7.3000
OrderID=10446 ProductID=24 UnitPrice=3.6000
OrderID=10446 ProductID=31 UnitPrice=10.0000
OrderID=10446 ProductID=52 UnitPrice=5.6000
OrderID=10447 ProductID=19 UnitPrice=7.3000
OrderID=10447 ProductID=65 UnitPrice=16.8000
OrderID=10447 ProductID=71 UnitPrice=17.2000
OrderID=10448 ProductID=26 UnitPrice=24.9000
OrderID=10448 ProductID=40 UnitPrice=14.7000
OrderID=10449 ProductID=10 UnitPrice=24.8000
OrderID=10449 ProductID=52 UnitPrice=5.6000
OrderID=10449 ProductID=62 UnitPrice=39.4000
OrderID=10450 ProductID=10 UnitPrice=24.8000
OrderID=10450 ProductID=54 UnitPrice=5.9000
OrderID=10451 ProductID=55 UnitPrice=19.2000
OrderID=10451 ProductID=64 UnitPrice=26.6000
OrderID=10451 ProductID=65 UnitPrice=16.8000
OrderID=10451 ProductID=77 UnitPrice=10.4000
OrderID=10452 ProductID=28 UnitPrice=36.4000
OrderID=10452 ProductID=44 UnitPrice=15.5000
OrderID=10453 ProductID=48 UnitPrice=10.2000
OrderID=10453 ProductID=70 UnitPrice=12.0000
OrderID=10454 ProductID=16 UnitPrice=13.9000
OrderID=10454 ProductID=33 UnitPrice=2.0000
OrderID=10454 ProductID=46 UnitPrice=9.6000
OrderID=10455 ProductID=39 UnitPrice=14.4000
OrderID=10455 ProductID=53 UnitPrice=26.2000
OrderID=10455 ProductID=61 UnitPrice=22.8000
OrderID=10455 ProductID=71 UnitPrice=17.2000
OrderID=10456 ProductID=21 UnitPrice=8.0000
OrderID=10456 ProductID=49 UnitPrice=16.0000
OrderID=10457 ProductID=59 UnitPrice=44.0000
OrderID=10458 ProductID=26 UnitPrice=24.9000
OrderID=10458 ProductID=28 UnitPrice=36.4000
OrderID=10458 ProductID=43 UnitPrice=36.8000
OrderID=10458 ProductID=56 UnitPrice=30.4000
OrderID=10458 ProductID=71 UnitPrice=17.2000
OrderID=10459 ProductID=7 UnitPrice=24.0000
OrderID=10459 ProductID=46 UnitPrice=9.6000
OrderID=10459 ProductID=72 UnitPrice=27.8000
OrderID=10460 ProductID=68 UnitPrice=10.0000
OrderID=10460 ProductID=75 UnitPrice=6.2000
OrderID=10461 ProductID=21 UnitPrice=8.0000
OrderID=10461 ProductID=30 UnitPrice=20.7000
OrderID=10461 ProductID=55 UnitPrice=19.2000
OrderID=10462 ProductID=13 UnitPrice=4.8000
OrderID=10462 ProductID=23 UnitPrice=7.2000
OrderID=10463 ProductID=19 UnitPrice=7.3000
OrderID=10463 ProductID=42 UnitPrice=11.2000
OrderID=10464 ProductID=4 UnitPrice=17.6000
OrderID=10464 ProductID=43 UnitPrice=36.8000
OrderID=10464 ProductID=56 UnitPrice=30.4000
OrderID=10464 ProductID=60 UnitPrice=27.2000
OrderID=10465 ProductID=24 UnitPrice=3.6000
OrderID=10465 ProductID=29 UnitPrice=99.0000
OrderID=10465 ProductID=40 UnitPrice=14.7000
OrderID=10465 ProductID=45 UnitPrice=7.6000
OrderID=10465 ProductID=50 UnitPrice=13.0000
OrderID=10466 ProductID=11 UnitPrice=16.8000
OrderID=10466 ProductID=46 UnitPrice=9.6000
OrderID=10467 ProductID=24 UnitPrice=3.6000
OrderID=10467 ProductID=25 UnitPrice=11.2000
OrderID=10468 ProductID=30 UnitPrice=20.7000
OrderID=10468 ProductID=43 UnitPrice=36.8000
OrderID=10469 ProductID=2 UnitPrice=15.2000
OrderID=10469 ProductID=16 UnitPrice=13.9000
OrderID=10469 ProductID=44 UnitPrice=15.5000
OrderID=10470 ProductID=18 UnitPrice=50.0000
OrderID=10470 ProductID=23 UnitPrice=7.2000
OrderID=10470 ProductID=64 UnitPrice=26.6000
OrderID=10471 ProductID=7 UnitPrice=24.0000
OrderID=10471 ProductID=56 UnitPrice=30.4000
OrderID=10472 ProductID=24 UnitPrice=3.6000
OrderID=10472 ProductID=51 UnitPrice=42.4000
OrderID=10473 ProductID=33 UnitPrice=2.0000
OrderID=10473 ProductID=71 UnitPrice=17.2000
OrderID=10474 ProductID=14 UnitPrice=18.6000
OrderID=10474 ProductID=28 UnitPrice=36.4000
OrderID=10474 ProductID=40 UnitPrice=14.7000
OrderID=10474 ProductID=75 UnitPrice=6.2000
OrderID=10475 ProductID=31 UnitPrice=10.0000
OrderID=10475 ProductID=66 UnitPrice=13.6000
OrderID=10475 ProductID=76 UnitPrice=14.4000
OrderID=10476 ProductID=55 UnitPrice=19.2000
OrderID=10476 ProductID=70 UnitPrice=12.0000
OrderID=10477 ProductID=1 UnitPrice=14.4000
OrderID=10477 ProductID=21 UnitPrice=8.0000
OrderID=10477 ProductID=39 UnitPrice=14.4000
OrderID=10478 ProductID=10 UnitPrice=24.8000
OrderID=10479 ProductID=38 UnitPrice=210.8000
OrderID=10479 ProductID=53 UnitPrice=26.2000
OrderID=10479 ProductID=59 UnitPrice=44.0000
OrderID=10479 ProductID=64 UnitPrice=26.6000
OrderID=10480 ProductID=47 UnitPrice=7.6000
OrderID=10480 ProductID=59 UnitPrice=44.0000
OrderID=10481 ProductID=49 UnitPrice=16.0000
OrderID=10481 ProductID=60 UnitPrice=27.2000
OrderID=10482 ProductID=40 UnitPrice=14.7000
OrderID=10483 ProductID=34 UnitPrice=11.2000
OrderID=10483 ProductID=77 UnitPrice=10.4000
OrderID=10484 ProductID=21 UnitPrice=8.0000
OrderID=10484 ProductID=40 UnitPrice=14.7000
OrderID=10484 ProductID=51 UnitPrice=42.4000
OrderID=10485 ProductID=2 UnitPrice=15.2000
OrderID=10485 ProductID=3 UnitPrice=8.0000
OrderID=10485 ProductID=55 UnitPrice=19.2000
OrderID=10485 ProductID=70 UnitPrice=12.0000
OrderID=10486 ProductID=11 UnitPrice=16.8000
OrderID=10486 ProductID=51 UnitPrice=42.4000
OrderID=10486 ProductID=74 UnitPrice=8.0000
OrderID=10487 ProductID=19 UnitPrice=7.3000
OrderID=10487 ProductID=26 UnitPrice=24.9000
OrderID=10487 ProductID=54 UnitPrice=5.9000
OrderID=10488 ProductID=59 UnitPrice=44.0000
OrderID=10488 ProductID=73 UnitPrice=12.0000
OrderID=10489 ProductID=11 UnitPrice=16.8000
OrderID=10489 ProductID=16 UnitPrice=13.9000
OrderID=10490 ProductID=59 UnitPrice=44.0000
OrderID=10490 ProductID=68 UnitPrice=10.0000
OrderID=10490 ProductID=75 UnitPrice=6.2000
OrderID=10491 ProductID=44 UnitPrice=15.5000
OrderID=10491 ProductID=77 UnitPrice=10.4000
OrderID=10492 ProductID=25 UnitPrice=11.2000
OrderID=10492 ProductID=42 UnitPrice=11.2000
OrderID=10493 ProductID=65 UnitPrice=16.8000
OrderID=10493 ProductID=66 UnitPrice=13.6000
OrderID=10493 ProductID=69 UnitPrice=28.8000
OrderID=10494 ProductID=56 UnitPrice=30.4000
OrderID=10495 ProductID=23 UnitPrice=7.2000
OrderID=10495 ProductID=41 UnitPrice=7.7000
OrderID=10495 ProductID=77 UnitPrice=10.4000
OrderID=10496 ProductID=31 UnitPrice=10.0000
OrderID=10497 ProductID=56 UnitPrice=30.4000
OrderID=10497 ProductID=72 UnitPrice=27.8000
OrderID=10497 ProductID=77 UnitPrice=10.4000
OrderID=10498 ProductID=24 UnitPrice=4.5000
OrderID=10498 ProductID=40 UnitPrice=18.4000
OrderID=10498 ProductID=42 UnitPrice=14.0000
OrderID=10499 ProductID=28 UnitPrice=45.6000
OrderID=10499 ProductID=49 UnitPrice=20.0000
OrderID=10500 ProductID=15 UnitPrice=15.5000
OrderID=10500 ProductID=28 UnitPrice=45.6000
OrderID=10501 ProductID=54 UnitPrice=7.4500
OrderID=10502 ProductID=45 UnitPrice=9.5000
OrderID=10502 ProductID=53 UnitPrice=32.8000
OrderID=10502 ProductID=67 UnitPrice=14.0000
OrderID=10503 ProductID=14 UnitPrice=23.2500
OrderID=10503 ProductID=65 UnitPrice=21.0500
OrderID=10504 ProductID=2 UnitPrice=19.0000
OrderID=10504 ProductID=21 UnitPrice=10.0000
OrderID=10504 ProductID=53 UnitPrice=32.8000
OrderID=10504 ProductID=61 UnitPrice=28.5000
OrderID=10505 ProductID=62 UnitPrice=49.3000
OrderID=10506 ProductID=25 UnitPrice=14.0000
OrderID=10506 ProductID=70 UnitPrice=15.0000
OrderID=10507 ProductID=43 UnitPrice=46.0000
OrderID=10507 ProductID=48 UnitPrice=12.7500
OrderID=10508 ProductID=13 UnitPrice=6.0000
OrderID=10508 ProductID=39 UnitPrice=18.0000
OrderID=10509 ProductID=28 UnitPrice=45.6000
OrderID=10510 ProductID=29 UnitPrice=123.7900
OrderID=10510 ProductID=75 UnitPrice=7.7500
OrderID=10511 ProductID=4 UnitPrice=22.0000
OrderID=10511 ProductID=7 UnitPrice=30.0000
OrderID=10511 ProductID=8 UnitPrice=40.0000
OrderID=10512 ProductID=24 UnitPrice=4.5000
OrderID=10512 ProductID=46 UnitPrice=12.0000
OrderID=10512 ProductID=47 UnitPrice=9.5000
OrderID=10512 ProductID=60 UnitPrice=34.0000
OrderID=10513 ProductID=21 UnitPrice=10.0000
OrderID=10513 ProductID=32 UnitPrice=32.0000
OrderID=10513 ProductID=61 UnitPrice=28.5000
OrderID=10514 ProductID=20 UnitPrice=81.0000
OrderID=10514 ProductID=28 UnitPrice=45.6000
OrderID=10514 ProductID=56 UnitPrice=38.0000
OrderID=10514 ProductID=65 UnitPrice=21.0500
OrderID=10514 ProductID=75 UnitPrice=7.7500
OrderID=10515 ProductID=9 UnitPrice=97.0000
OrderID=10515 ProductID=16 UnitPrice=17.4500
OrderID=10515 ProductID=27 UnitPrice=43.9000
OrderID=10515 ProductID=33 UnitPrice=2.5000
OrderID=10515 ProductID=60 UnitPrice=34.0000
OrderID=10516 ProductID=18 UnitPrice=62.5000
OrderID=10516 ProductID=41 UnitPrice=9.6500
OrderID=10516 ProductID=42 UnitPrice=14.0000
OrderID=10517 ProductID=52 UnitPrice=7.0000
OrderID=10517 ProductID=59 UnitPrice=55.0000
OrderID=10517 ProductID=70 UnitPrice=15.0000
OrderID=10518 ProductID=24 UnitPrice=4.5000
OrderID=10518 ProductID=38 UnitPrice=263.5000
OrderID=10518 ProductID=44 UnitPrice=19.4500
OrderID=10519 ProductID=10 UnitPrice=31.0000
OrderID=10519 ProductID=56 UnitPrice=38.0000
OrderID=10519 ProductID=60 UnitPrice=34.0000
OrderID=10520 ProductID=24 UnitPrice=4.5000
OrderID=10520 ProductID=53 UnitPrice=32.8000
OrderID=10521 ProductID=35 UnitPrice=18.0000
OrderID=10521 ProductID=41 UnitPrice=9.6500
OrderID=10521 ProductID=68 UnitPrice=12.5000
OrderID=10522 ProductID=1 UnitPrice=18.0000
OrderID=10522 ProductID=8 UnitPrice=40.0000
OrderID=10522 ProductID=30 UnitPrice=25.8900
OrderID=10522 ProductID=40 UnitPrice=18.4000
OrderID=10523 ProductID=17 UnitPrice=39.0000
OrderID=10523 ProductID=20 UnitPrice=81.0000
OrderID=10523 ProductID=37 UnitPrice=26.0000
OrderID=10523 ProductID=41 UnitPrice=9.6500
OrderID=10524 ProductID=10 UnitPrice=31.0000
OrderID=10524 ProductID=30 UnitPrice=25.8900
OrderID=10524 ProductID=43 UnitPrice=46.0000
OrderID=10524 ProductID=54 UnitPrice=7.4500
OrderID=10525 ProductID=36 UnitPrice=19.0000
OrderID=10525 ProductID=40 UnitPrice=18.4000
OrderID=10526 ProductID=1 UnitPrice=18.0000
OrderID=10526 ProductID=13 UnitPrice=6.0000
OrderID=10526 ProductID=56 UnitPrice=38.0000
OrderID=10527 ProductID=4 UnitPrice=22.0000
OrderID=10527 ProductID=36 UnitPrice=19.0000
OrderID=10528 ProductID=11 UnitPrice=21.0000
OrderID=10528 ProductID=33 UnitPrice=2.5000
OrderID=10528 ProductID=72 UnitPrice=34.8000
OrderID=10529 ProductID=55 UnitPrice=24.0000
OrderID=10529 ProductID=68 UnitPrice=12.5000
OrderID=10529 ProductID=69 UnitPrice=36.0000
OrderID=10530 ProductID=17 UnitPrice=39.0000
OrderID=10530 ProductID=43 UnitPrice=46.0000
OrderID=10530 ProductID=61 UnitPrice=28.5000
OrderID=10530 ProductID=76 UnitPrice=18.0000
OrderID=10531 ProductID=59 UnitPrice=55.0000
OrderID=10532 ProductID=30 UnitPrice=25.8900
OrderID=10532 ProductID=66 UnitPrice=17.0000
OrderID=10533 ProductID=4 UnitPrice=22.0000
OrderID=10533 ProductID=72 UnitPrice=34.8000
OrderID=10533 ProductID=73 UnitPrice=15.0000
OrderID=10534 ProductID=30 UnitPrice=25.8900
OrderID=10534 ProductID=40 UnitPrice=18.4000
OrderID=10534 ProductID=54 UnitPrice=7.4500
OrderID=10535 ProductID=11 UnitPrice=21.0000
OrderID=10535 ProductID=40 UnitPrice=18.4000
OrderID=10535 ProductID=57 UnitPrice=19.5000
OrderID=10535 ProductID=59 UnitPrice=55.0000
OrderID=10536 ProductID=12 UnitPrice=38.0000
OrderID=10536 ProductID=31 UnitPrice=12.5000
OrderID=10536 ProductID=33 UnitPrice=2.5000
OrderID=10536 ProductID=60 UnitPrice=34.0000
OrderID=10537 ProductID=31 UnitPrice=12.5000
OrderID=10537 ProductID=51 UnitPrice=53.0000
OrderID=10537 ProductID=58 UnitPrice=13.2500
OrderID=10537 ProductID=72 UnitPrice=34.8000
OrderID=10537 ProductID=73 UnitPrice=15.0000
OrderID=10538 ProductID=70 UnitPrice=15.0000
OrderID=10538 ProductID=72 UnitPrice=34.8000
OrderID=10539 ProductID=13 UnitPrice=6.0000
OrderID=10539 ProductID=21 UnitPrice=10.0000
OrderID=10539 ProductID=33 UnitPrice=2.5000
OrderID=10539 ProductID=49 UnitPrice=20.0000
OrderID=10540 ProductID=3 UnitPrice=10.0000
OrderID=10540 ProductID=26 UnitPrice=31.2300
OrderID=10540 ProductID=38 UnitPrice=263.5000
OrderID=10540 ProductID=68 UnitPrice=12.5000
OrderID=10541 ProductID=24 UnitPrice=4.5000
OrderID=10541 ProductID=38 UnitPrice=263.5000
OrderID=10541 ProductID=65 UnitPrice=21.0500
OrderID=10541 ProductID=71 UnitPrice=21.5000
OrderID=10542 ProductID=11 UnitPrice=21.0000
OrderID=10542 ProductID=54 UnitPrice=7.4500
OrderID=10543 ProductID=12 UnitPrice=38.0000
OrderID=10543 ProductID=23 UnitPrice=9.0000
OrderID=10544 ProductID=28 UnitPrice=45.6000
OrderID=10544 ProductID=67 UnitPrice=14.0000
OrderID=10545 ProductID=11 UnitPrice=21.0000
OrderID=10546 ProductID=7 UnitPrice=30.0000
OrderID=10546 ProductID=35 UnitPrice=18.0000
OrderID=10546 ProductID=62 UnitPrice=49.3000
OrderID=10547 ProductID=32 UnitPrice=32.0000
OrderID=10547 ProductID=36 UnitPrice=19.0000
OrderID=10548 ProductID=34 UnitPrice=14.0000
OrderID=10548 ProductID=41 UnitPrice=9.6500
OrderID=10549 ProductID=31 UnitPrice=12.5000
OrderID=10549 ProductID=45 UnitPrice=9.5000
OrderID=10549 ProductID=51 UnitPrice=53.0000
OrderID=10550 ProductID=17 UnitPrice=39.0000
OrderID=10550 ProductID=19 UnitPrice=9.2000
OrderID=10550 ProductID=21 UnitPrice=10.0000
OrderID=10550 ProductID=61 UnitPrice=28.5000
OrderID=10551 ProductID=16 UnitPrice=17.4500
OrderID=10551 ProductID=35 UnitPrice=18.0000
OrderID=10551 ProductID=44 UnitPrice=19.4500
OrderID=10552 ProductID=69 UnitPrice=36.0000
OrderID=10552 ProductID=75 UnitPrice=7.7500
OrderID=10553 ProductID=11 UnitPrice=21.0000
OrderID=10553 ProductID=16 UnitPrice=17.4500
OrderID=10553 ProductID=22 UnitPrice=21.0000
OrderID=10553 ProductID=31 UnitPrice=12.5000
OrderID=10553 ProductID=35 UnitPrice=18.0000
OrderID=10554 ProductID=16 UnitPrice=17.4500
OrderID=10554 ProductID=23 UnitPrice=9.0000
OrderID=10554 ProductID=62 UnitPrice=49.3000
OrderID=10554 ProductID=77 UnitPrice=13.0000
OrderID=10555 ProductID=14 UnitPrice=23.2500
OrderID=10555 ProductID=19 UnitPrice=9.2000
OrderID=10555 ProductID=24 UnitPrice=4.5000
OrderID=10555 ProductID=51 UnitPrice=53.0000
OrderID=10555 ProductID=56 UnitPrice=38.0000
OrderID=10556 ProductID=72 UnitPrice=34.8000
OrderID=10557 ProductID=64 UnitPrice=33.2500
OrderID=10557 ProductID=75 UnitPrice=7.7500
OrderID=10558 ProductID=47 UnitPrice=9.5000
OrderID=10558 ProductID=51 UnitPrice=53.0000
OrderID=10558 ProductID=52 UnitPrice=7.0000
OrderID=10558 ProductID=53 UnitPrice=32.8000
OrderID=10558 ProductID=73 UnitPrice=15.0000
OrderID=10559 ProductID=41 UnitPrice=9.6500
OrderID=10559 ProductID=55 UnitPrice=24.0000
OrderID=10560 ProductID=30 UnitPrice=25.8900
OrderID=10560 ProductID=62 UnitPrice=49.3000
OrderID=10561 ProductID=44 UnitPrice=19.4500
OrderID=10561 ProductID=51 UnitPrice=53.0000
OrderID=10562 ProductID=33 UnitPrice=2.5000
OrderID=10562 ProductID=62 UnitPrice=49.3000
OrderID=10563 ProductID=36 UnitPrice=19.0000
OrderID=10563 ProductID=52 UnitPrice=7.0000
OrderID=10564 ProductID=17 UnitPrice=39.0000
OrderID=10564 ProductID=31 UnitPrice=12.5000
OrderID=10564 ProductID=55 UnitPrice=24.0000
OrderID=10565 ProductID=24 UnitPrice=4.5000
OrderID=10565 ProductID=64 UnitPrice=33.2500
OrderID=10566 ProductID=11 UnitPrice=21.0000
OrderID=10566 ProductID=18 UnitPrice=62.5000
OrderID=10566 ProductID=76 UnitPrice=18.0000
OrderID=10567 ProductID=31 UnitPrice=12.5000
OrderID=10567 ProductID=51 UnitPrice=53.0000
OrderID=10567 ProductID=59 UnitPrice=55.0000
OrderID=10568 ProductID=10 UnitPrice=31.0000
OrderID=10569 ProductID=31 UnitPrice=12.5000
OrderID=10569 ProductID=76 UnitPrice=18.0000
OrderID=10570 ProductID=11 UnitPrice=21.0000
OrderID=10570 ProductID=56 UnitPrice=38.0000
OrderID=10571 ProductID=14 UnitPrice=23.2500
OrderID=10571 ProductID=42 UnitPrice=14.0000
OrderID=10572 ProductID=16 UnitPrice=17.4500
OrderID=10572 ProductID=32 UnitPrice=32.0000
OrderID=10572 ProductID=40 UnitPrice=18.4000
OrderID=10572 ProductID=75 UnitPrice=7.7500
OrderID=10573 ProductID=17 UnitPrice=39.0000
OrderID=10573 ProductID=34 UnitPrice=14.0000
OrderID=10573 ProductID=53 UnitPrice=32.8000
OrderID=10574 ProductID=33 UnitPrice=2.5000
OrderID=10574 ProductID=40 UnitPrice=18.4000
OrderID=10574 ProductID=62 UnitPrice=49.3000
OrderID=10574 ProductID=64 UnitPrice=33.2500
OrderID=10575 ProductID=59 UnitPrice=55.0000
OrderID=10575 ProductID=63 UnitPrice=43.9000
OrderID=10575 ProductID=72 UnitPrice=34.8000
OrderID=10575 ProductID=76 UnitPrice=18.0000
OrderID=10576 ProductID=1 UnitPrice=18.0000
OrderID=10576 ProductID=31 UnitPrice=12.5000
OrderID=10576 ProductID=44 UnitPrice=19.4500
OrderID=10577 ProductID=39 UnitPrice=18.0000
OrderID=10577 ProductID=75 UnitPrice=7.7500
OrderID=10577 ProductID=77 UnitPrice=13.0000
OrderID=10578 ProductID=35 UnitPrice=18.0000
OrderID=10578 ProductID=57 UnitPrice=19.5000
OrderID=10579 ProductID=15 UnitPrice=15.5000
OrderID=10579 ProductID=75 UnitPrice=7.7500
OrderID=10580 ProductID=14 UnitPrice=23.2500
OrderID=10580 ProductID=41 UnitPrice=9.6500
OrderID=10580 ProductID=65 UnitPrice=21.0500
OrderID=10581 ProductID=75 UnitPrice=7.7500
OrderID=10582 ProductID=57 UnitPrice=19.5000
OrderID=10582 ProductID=76 UnitPrice=18.0000
OrderID=10583 ProductID=29 UnitPrice=123.7900
OrderID=10583 ProductID=60 UnitPrice=34.0000
OrderID=10583 ProductID=69 UnitPrice=36.0000
OrderID=10584 ProductID=31 UnitPrice=12.5000
OrderID=10585 ProductID=47 UnitPrice=9.5000
OrderID=10586 ProductID=52 UnitPrice=7.0000
OrderID=10587 ProductID=26 UnitPrice=31.2300
OrderID=10587 ProductID=35 UnitPrice=18.0000
OrderID=10587 ProductID=77 UnitPrice=13.0000
OrderID=10588 ProductID=18 UnitPrice=62.5000
OrderID=10588 ProductID=42 UnitPrice=14.0000
OrderID=10589 ProductID=35 UnitPrice=18.0000
OrderID=10590 ProductID=1 UnitPrice=18.0000
OrderID=10590 ProductID=77 UnitPrice=13.0000
OrderID=10591 ProductID=3 UnitPrice=10.0000
OrderID=10591 ProductID=7 UnitPrice=30.0000
OrderID=10591 ProductID=54 UnitPrice=7.4500
OrderID=10592 ProductID=15 UnitPrice=15.5000
OrderID=10592 ProductID=26 UnitPrice=31.2300
OrderID=10593 ProductID=20 UnitPrice=81.0000
OrderID=10593 ProductID=69 UnitPrice=36.0000
OrderID=10593 ProductID=76 UnitPrice=18.0000
OrderID=10594 ProductID=52 UnitPrice=7.0000
OrderID=10594 ProductID=58 UnitPrice=13.2500
OrderID=10595 ProductID=35 UnitPrice=18.0000
OrderID=10595 ProductID=61 UnitPrice=28.5000
OrderID=10595 ProductID=69 UnitPrice=36.0000
OrderID=10596 ProductID=56 UnitPrice=38.0000
OrderID=10596 ProductID=63 UnitPrice=43.9000
OrderID=10596 ProductID=75 UnitPrice=7.7500
OrderID=10597 ProductID=24 UnitPrice=4.5000
OrderID=10597 ProductID=57 UnitPrice=19.5000
OrderID=10597 ProductID=65 UnitPrice=21.0500
OrderID=10598 ProductID=27 UnitPrice=43.9000
OrderID=10598 ProductID=71 UnitPrice=21.5000
OrderID=10599 ProductID=62 UnitPrice=49.3000
OrderID=10600 ProductID=54 UnitPrice=7.4500
OrderID=10600 ProductID=73 UnitPrice=15.0000
OrderID=10601 ProductID=13 UnitPrice=6.0000
OrderID=10601 ProductID=59 UnitPrice=55.0000
OrderID=10602 ProductID=77 UnitPrice=13.0000
OrderID=10603 ProductID=22 UnitPrice=21.0000
OrderID=10603 ProductID=49 UnitPrice=20.0000
OrderID=10604 ProductID=48 UnitPrice=12.7500
OrderID=10604 ProductID=76 UnitPrice=18.0000
OrderID=10605 ProductID=16 UnitPrice=17.4500
OrderID=10605 ProductID=59 UnitPrice=55.0000
OrderID=10605 ProductID=60 UnitPrice=34.0000
OrderID=10605 ProductID=71 UnitPrice=21.5000
OrderID=10606 ProductID=4 UnitPrice=22.0000
OrderID=10606 ProductID=55 UnitPrice=24.0000
OrderID=10606 ProductID=62 UnitPrice=49.3000
OrderID=10607 ProductID=7 UnitPrice=30.0000
OrderID=10607 ProductID=17 UnitPrice=39.0000
OrderID=10607 ProductID=33 UnitPrice=2.5000
OrderID=10607 ProductID=40 UnitPrice=18.4000
OrderID=10607 ProductID=72 UnitPrice=34.8000
OrderID=10608 ProductID=56 UnitPrice=38.0000
OrderID=10609 ProductID=1 UnitPrice=18.0000
OrderID=10609 ProductID=10 UnitPrice=31.0000
OrderID=10609 ProductID=21 UnitPrice=10.0000
OrderID=10610 ProductID=36 UnitPrice=19.0000
OrderID=10611 ProductID=1 UnitPrice=18.0000
OrderID=10611 ProductID=2 UnitPrice=19.0000
OrderID=10611 ProductID=60 UnitPrice=34.0000
OrderID=10612 ProductID=10 UnitPrice=31.0000
OrderID=10612 ProductID=36 UnitPrice=19.0000
OrderID=10612 ProductID=49 UnitPrice=20.0000
OrderID=10612 ProductID=60 UnitPrice=34.0000
OrderID=10612 ProductID=76 UnitPrice=18.0000
OrderID=10613 ProductID=13 UnitPrice=6.0000
OrderID=10613 ProductID=75 UnitPrice=7.7500
OrderID=10614 ProductID=11 UnitPrice=21.0000
OrderID=10614 ProductID=21 UnitPrice=10.0000
OrderID=10614 ProductID=39 UnitPrice=18.0000
OrderID=10615 ProductID=55 UnitPrice=24.0000
OrderID=10616 ProductID=38 UnitPrice=263.5000
OrderID=10616 ProductID=56 UnitPrice=38.0000
OrderID=10616 ProductID=70 UnitPrice=15.0000
OrderID=10616 ProductID=71 UnitPrice=21.5000
OrderID=10617 ProductID=59 UnitPrice=55.0000
OrderID=10618 ProductID=6 UnitPrice=25.0000
OrderID=10618 ProductID=56 UnitPrice=38.0000
OrderID=10618 ProductID=68 UnitPrice=12.5000
OrderID=10619 ProductID=21 UnitPrice=10.0000
OrderID=10619 ProductID=22 UnitPrice=21.0000
OrderID=10620 ProductID=24 UnitPrice=4.5000
OrderID=10620 ProductID=52 UnitPrice=7.0000
OrderID=10621 ProductID=19 UnitPrice=9.2000
OrderID=10621 ProductID=23 UnitPrice=9.0000
OrderID=10621 ProductID=70 UnitPrice=15.0000
OrderID=10621 ProductID=71 UnitPrice=21.5000
OrderID=10622 ProductID=2 UnitPrice=19.0000
OrderID=10622 ProductID=68 UnitPrice=12.5000
OrderID=10623 ProductID=14 UnitPrice=23.2500
OrderID=10623 ProductID=19 UnitPrice=9.2000
OrderID=10623 ProductID=21 UnitPrice=10.0000
OrderID=10623 ProductID=24 UnitPrice=4.5000
OrderID=10623 ProductID=35 UnitPrice=18.0000
OrderID=10624 ProductID=28 UnitPrice=45.6000
OrderID=10624 ProductID=29 UnitPrice=123.7900
OrderID=10624 ProductID=44 UnitPrice=19.4500
OrderID=10625 ProductID=14 UnitPrice=23.2500
OrderID=10625 ProductID=42 UnitPrice=14.0000
OrderID=10625 ProductID=60 UnitPrice=34.0000
OrderID=10626 ProductID=53 UnitPrice=32.8000
OrderID=10626 ProductID=60 UnitPrice=34.0000
OrderID=10626 ProductID=71 UnitPrice=21.5000
OrderID=10627 ProductID=62 UnitPrice=49.3000
OrderID=10627 ProductID=73 UnitPrice=15.0000
OrderID=10628 ProductID=1 UnitPrice=18.0000
OrderID=10629 ProductID=29 UnitPrice=123.7900
OrderID=10629 ProductID=64 UnitPrice=33.2500
OrderID=10630 ProductID=55 UnitPrice=24.0000
OrderID=10630 ProductID=76 UnitPrice=18.0000
OrderID=10631 ProductID=75 UnitPrice=7.7500
OrderID=10632 ProductID=2 UnitPrice=19.0000
OrderID=10632 ProductID=33 UnitPrice=2.5000
OrderID=10633 ProductID=12 UnitPrice=38.0000
OrderID=10633 ProductID=13 UnitPrice=6.0000
OrderID=10633 ProductID=26 UnitPrice=31.2300
OrderID=10633 ProductID=62 UnitPrice=49.3000
OrderID=10634 ProductID=7 UnitPrice=30.0000
OrderID=10634 ProductID=18 UnitPrice=62.5000
OrderID=10634 ProductID=51 UnitPrice=53.0000
OrderID=10634 ProductID=75 UnitPrice=7.7500
OrderID=10635 ProductID=4 UnitPrice=22.0000
OrderID=10635 ProductID=5 UnitPrice=21.3500
OrderID=10635 ProductID=22 UnitPrice=21.0000
OrderID=10636 ProductID=4 UnitPrice=22.0000
OrderID=10636 ProductID=58 UnitPrice=13.2500
OrderID=10637 ProductID=11 UnitPrice=21.0000
OrderID=10637 ProductID=50 UnitPrice=16.2500
OrderID=10637 ProductID=56 UnitPrice=38.0000
OrderID=10638 ProductID=45 UnitPrice=9.5000
OrderID=10638 ProductID=65 UnitPrice=21.0500
OrderID=10638 ProductID=72 UnitPrice=34.8000
OrderID=10639 ProductID=18 UnitPrice=62.5000
OrderID=10640 ProductID=69 UnitPrice=36.0000
OrderID=10640 ProductID=70 UnitPrice=15.0000
OrderID=10641 ProductID=2 UnitPrice=19.0000
OrderID=10641 ProductID=40 UnitPrice=18.4000
OrderID=10642 ProductID=21 UnitPrice=10.0000
OrderID=10642 ProductID=61 UnitPrice=28.5000
OrderID=10643 ProductID=28 UnitPrice=45.6000
OrderID=10643 ProductID=39 UnitPrice=18.0000
OrderID=10643 ProductID=46 UnitPrice=12.0000
OrderID=10644 ProductID=18 UnitPrice=62.5000
OrderID=10644 ProductID=43 UnitPrice=46.0000
OrderID=10644 ProductID=46 UnitPrice=12.0000
OrderID=10645 ProductID=18 UnitPrice=62.5000
OrderID=10645 ProductID=36 UnitPrice=19.0000
OrderID=10646 ProductID=1 UnitPrice=18.0000
OrderID=10646 ProductID=10 UnitPrice=31.0000
OrderID=10646 ProductID=71 UnitPrice=21.5000
OrderID=10646 ProductID=77 UnitPrice=13.0000
OrderID=10647 ProductID=19 UnitPrice=9.2000
OrderID=10647 ProductID=39 UnitPrice=18.0000
OrderID=10648 ProductID=22 UnitPrice=21.0000
OrderID=10648 ProductID=24 UnitPrice=4.5000
OrderID=10649 ProductID=28 UnitPrice=45.6000
OrderID=10649 ProductID=72 UnitPrice=34.8000
OrderID=10650 ProductID=30 UnitPrice=25.8900
OrderID=10650 ProductID=53 UnitPrice=32.8000
OrderID=10650 ProductID=54 UnitPrice=7.4500
OrderID=10651 ProductID=19 UnitPrice=9.2000
OrderID=10651 ProductID=22 UnitPrice=21.0000
OrderID=10652 ProductID=30 UnitPrice=25.8900
OrderID=10652 ProductID=42 UnitPrice=14.0000
OrderID=10653 ProductID=16 UnitPrice=17.4500
OrderID=10653 ProductID=60 UnitPrice=34.0000
OrderID=10654 ProductID=4 UnitPrice=22.0000
OrderID=10654 ProductID=39 UnitPrice=18.0000
OrderID=10654 ProductID=54 UnitPrice=7.4500
OrderID=10655 ProductID=41 UnitPrice=9.6500
OrderID=10656 ProductID=14 UnitPrice=23.2500
OrderID=10656 ProductID=44 UnitPrice=19.4500
OrderID=10656 ProductID=47 UnitPrice=9.5000
OrderID=10657 ProductID=15 UnitPrice=15.5000
OrderID=10657 ProductID=41 UnitPrice=9.6500
OrderID=10657 ProductID=46 UnitPrice=12.0000
OrderID=10657 ProductID=47 UnitPrice=9.5000
OrderID=10657 ProductID=56 UnitPrice=38.0000
OrderID=10657 ProductID=60 UnitPrice=34.0000
OrderID=10658 ProductID=21 UnitPrice=10.0000
OrderID=10658 ProductID=40 UnitPrice=18.4000
OrderID=10658 ProductID=60 UnitPrice=34.0000
OrderID=10658 ProductID=77 UnitPrice=13.0000
OrderID=10659 ProductID=31 UnitPrice=12.5000
OrderID=10659 ProductID=40 UnitPrice=18.4000
OrderID=10659 ProductID=70 UnitPrice=15.0000
OrderID=10660 ProductID=20 UnitPrice=81.0000
OrderID=10661 ProductID=39 UnitPrice=18.0000
OrderID=10661 ProductID=58 UnitPrice=13.2500
OrderID=10662 ProductID=68 UnitPrice=12.5000
OrderID=10663 ProductID=40 UnitPrice=18.4000
OrderID=10663 ProductID=42 UnitPrice=14.0000
OrderID=10663 ProductID=51 UnitPrice=53.0000
OrderID=10664 ProductID=10 UnitPrice=31.0000
OrderID=10664 ProductID=56 UnitPrice=38.0000
OrderID=10664 ProductID=65 UnitPrice=21.0500
OrderID=10665 ProductID=51 UnitPrice=53.0000
OrderID=10665 ProductID=59 UnitPrice=55.0000
OrderID=10665 ProductID=76 UnitPrice=18.0000
OrderID=10666 ProductID=29 UnitPrice=123.7900
OrderID=10666 ProductID=65 UnitPrice=21.0500
OrderID=10667 ProductID=69 UnitPrice=36.0000
OrderID=10667 ProductID=71 UnitPrice=21.5000
OrderID=10668 ProductID=31 UnitPrice=12.5000
OrderID=10668 ProductID=55 UnitPrice=24.0000
OrderID=10668 ProductID=64 UnitPrice=33.2500
OrderID=10669 ProductID=36 UnitPrice=19.0000
OrderID=10670 ProductID=23 UnitPrice=9.0000
OrderID=10670 ProductID=46 UnitPrice=12.0000
OrderID=10670 ProductID=67 UnitPrice=14.0000
OrderID=10670 ProductID=73 UnitPrice=15.0000
OrderID=10670 ProductID=75 UnitPrice=7.7500
OrderID=10671 ProductID=16 UnitPrice=17.4500
OrderID=10671 ProductID=62 UnitPrice=49.3000
OrderID=10671 ProductID=65 UnitPrice=21.0500
OrderID=10672 ProductID=38 UnitPrice=263.5000
OrderID=10672 ProductID=71 UnitPrice=21.5000
OrderID=10673 ProductID=16 UnitPrice=17.4500
OrderID=10673 ProductID=42 UnitPrice=14.0000
OrderID=10673 ProductID=43 UnitPrice=46.0000
OrderID=10674 ProductID=23 UnitPrice=9.0000
OrderID=10675 ProductID=14 UnitPrice=23.2500
OrderID=10675 ProductID=53 UnitPrice=32.8000
OrderID=10675 ProductID=58 UnitPrice=13.2500
OrderID=10676 ProductID=10 UnitPrice=31.0000
OrderID=10676 ProductID=19 UnitPrice=9.2000
OrderID=10676 ProductID=44 UnitPrice=19.4500
OrderID=10677 ProductID=26 UnitPrice=31.2300
OrderID=10677 ProductID=33 UnitPrice=2.5000
OrderID=10678 ProductID=12 UnitPrice=38.0000
OrderID=10678 ProductID=33 UnitPrice=2.5000
OrderID=10678 ProductID=41 UnitPrice=9.6500
OrderID=10678 ProductID=54 UnitPrice=7.4500
OrderID=10679 ProductID=59 UnitPrice=55.0000
OrderID=10680 ProductID=16 UnitPrice=17.4500
OrderID=10680 ProductID=31 UnitPrice=12.5000
OrderID=10680 ProductID=42 UnitPrice=14.0000
OrderID=10681 ProductID=19 UnitPrice=9.2000
OrderID=10681 ProductID=21 UnitPrice=10.0000
OrderID=10681 ProductID=64 UnitPrice=33.2500
OrderID=10682 ProductID=33 UnitPrice=2.5000
OrderID=10682 ProductID=66 UnitPrice=17.0000
OrderID=10682 ProductID=75 UnitPrice=7.7500
OrderID=10683 ProductID=52 UnitPrice=7.0000
OrderID=10684 ProductID=40 UnitPrice=18.4000
OrderID=10684 ProductID=47 UnitPrice=9.5000
OrderID=10684 ProductID=60 UnitPrice=34.0000
OrderID=10685 ProductID=10 UnitPrice=31.0000
OrderID=10685 ProductID=41 UnitPrice=9.6500
OrderID=10685 ProductID=47 UnitPrice=9.5000
OrderID=10686 ProductID=17 UnitPrice=39.0000
OrderID=10686 ProductID=26 UnitPrice=31.2300
OrderID=10687 ProductID=9 UnitPrice=97.0000
OrderID=10687 ProductID=29 UnitPrice=123.7900
OrderID=10687 ProductID=36 UnitPrice=19.0000
OrderID=10688 ProductID=10 UnitPrice=31.0000
OrderID=10688 ProductID=28 UnitPrice=45.6000
OrderID=10688 ProductID=34 UnitPrice=14.0000
OrderID=10689 ProductID=1 UnitPrice=18.0000
OrderID=10690 ProductID=56 UnitPrice=38.0000
OrderID=10690 ProductID=77 UnitPrice=13.0000
OrderID=10691 ProductID=1 UnitPrice=18.0000
OrderID=10691 ProductID=29 UnitPrice=123.7900
OrderID=10691 ProductID=43 UnitPrice=46.0000
OrderID=10691 ProductID=44 UnitPrice=19.4500
OrderID=10691 ProductID=62 UnitPrice=49.3000
OrderID=10692 ProductID=63 UnitPrice=43.9000
OrderID=10693 ProductID=9 UnitPrice=97.0000
OrderID=10693 ProductID=54 UnitPrice=7.4500
OrderID=10693 ProductID=69 UnitPrice=36.0000
OrderID=10693 ProductID=73 UnitPrice=15.0000
OrderID=10694 ProductID=7 UnitPrice=30.0000
OrderID=10694 ProductID=59 UnitPrice=55.0000
OrderID=10694 ProductID=70 UnitPrice=15.0000
OrderID=10695 ProductID=8 UnitPrice=40.0000
OrderID=10695 ProductID=12 UnitPrice=38.0000
OrderID=10695 ProductID=24 UnitPrice=4.5000
OrderID=10696 ProductID=17 UnitPrice=39.0000
OrderID=10696 ProductID=46 UnitPrice=12.0000
OrderID=10697 ProductID=19 UnitPrice=9.2000
OrderID=10697 ProductID=35 UnitPrice=18.0000
OrderID=10697 ProductID=58 UnitPrice=13.2500
OrderID=10697 ProductID=70 UnitPrice=15.0000
OrderID=10698 ProductID=11 UnitPrice=21.0000
OrderID=10698 ProductID=17 UnitPrice=39.0000
OrderID=10698 ProductID=29 UnitPrice=123.7900
OrderID=10698 ProductID=65 UnitPrice=21.0500
OrderID=10698 ProductID=70 UnitPrice=15.0000
OrderID=10699 ProductID=47 UnitPrice=9.5000
OrderID=10700 ProductID=1 UnitPrice=18.0000
OrderID=10700 ProductID=34 UnitPrice=14.0000
OrderID=10700 ProductID=68 UnitPrice=12.5000
OrderID=10700 ProductID=71 UnitPrice=21.5000
OrderID=10701 ProductID=59 UnitPrice=55.0000
OrderID=10701 ProductID=71 UnitPrice=21.5000
OrderID=10701 ProductID=76 UnitPrice=18.0000
OrderID=10702 ProductID=3 UnitPrice=10.0000
OrderID=10702 ProductID=76 UnitPrice=18.0000
OrderID=10703 ProductID=2 UnitPrice=19.0000
OrderID=10703 ProductID=59 UnitPrice=55.0000
OrderID=10703 ProductID=73 UnitPrice=15.0000
OrderID=10704 ProductID=4 UnitPrice=22.0000
OrderID=10704 ProductID=24 UnitPrice=4.5000
OrderID=10704 ProductID=48 UnitPrice=12.7500
OrderID=10705 ProductID=31 UnitPrice=12.5000
OrderID=10705 ProductID=32 UnitPrice=32.0000
OrderID=10706 ProductID=16 UnitPrice=17.4500
OrderID=10706 ProductID=43 UnitPrice=46.0000
OrderID=10706 ProductID=59 UnitPrice=55.0000
OrderID=10707 ProductID=55 UnitPrice=24.0000
OrderID=10707 ProductID=57 UnitPrice=19.5000
OrderID=10707 ProductID=70 UnitPrice=15.0000
OrderID=10708 ProductID=5 UnitPrice=21.3500
OrderID=10708 ProductID=36 UnitPrice=19.0000
OrderID=10709 ProductID=8 UnitPrice=40.0000
OrderID=10709 ProductID=51 UnitPrice=53.0000
OrderID=10709 ProductID=60 UnitPrice=34.0000
OrderID=10710 ProductID=19 UnitPrice=9.2000
OrderID=10710 ProductID=47 UnitPrice=9.5000
OrderID=10711 ProductID=19 UnitPrice=9.2000
OrderID=10711 ProductID=41 UnitPrice=9.6500
OrderID=10711 ProductID=53 UnitPrice=32.8000
OrderID=10712 ProductID=53 UnitPrice=32.8000
OrderID=10712 ProductID=56 UnitPrice=38.0000
OrderID=10713 ProductID=10 UnitPrice=31.0000
OrderID=10713 ProductID=26 UnitPrice=31.2300
OrderID=10713 ProductID=45 UnitPrice=9.5000
OrderID=10713 ProductID=46 UnitPrice=12.0000
OrderID=10714 ProductID=2 UnitPrice=19.0000
OrderID=10714 ProductID=17 UnitPrice=39.0000
OrderID=10714 ProductID=47 UnitPrice=9.5000
OrderID=10714 ProductID=56 UnitPrice=38.0000
OrderID=10714 ProductID=58 UnitPrice=13.2500
OrderID=10715 ProductID=10 UnitPrice=31.0000
OrderID=10715 ProductID=71 UnitPrice=21.5000
OrderID=10716 ProductID=21 UnitPrice=10.0000
OrderID=10716 ProductID=51 UnitPrice=53.0000
OrderID=10716 ProductID=61 UnitPrice=28.5000
OrderID=10717 ProductID=21 UnitPrice=10.0000
OrderID=10717 ProductID=54 UnitPrice=7.4500
OrderID=10717 ProductID=69 UnitPrice=36.0000
OrderID=10718 ProductID=12 UnitPrice=38.0000
OrderID=10718 ProductID=16 UnitPrice=17.4500
OrderID=10718 ProductID=36 UnitPrice=19.0000
OrderID=10718 ProductID=62 UnitPrice=49.3000
OrderID=10719 ProductID=18 UnitPrice=62.5000
OrderID=10719 ProductID=30 UnitPrice=25.8900
OrderID=10719 ProductID=54 UnitPrice=7.4500
OrderID=10720 ProductID=35 UnitPrice=18.0000
OrderID=10720 ProductID=71 UnitPrice=21.5000
OrderID=10721 ProductID=44 UnitPrice=19.4500
OrderID=10722 ProductID=2 UnitPrice=19.0000
OrderID=10722 ProductID=31 UnitPrice=12.5000
OrderID=10722 ProductID=68 UnitPrice=12.5000
OrderID=10722 ProductID=75 UnitPrice=7.7500
OrderID=10723 ProductID=26 UnitPrice=31.2300
OrderID=10724 ProductID=10 UnitPrice=31.0000
OrderID=10724 ProductID=61 UnitPrice=28.5000
OrderID=10725 ProductID=41 UnitPrice=9.6500
OrderID=10725 ProductID=52 UnitPrice=7.0000
OrderID=10725 ProductID=55 UnitPrice=24.0000
OrderID=10726 ProductID=4 UnitPrice=22.0000
OrderID=10726 ProductID=11 UnitPrice=21.0000
OrderID=10727 ProductID=17 UnitPrice=39.0000
OrderID=10727 ProductID=56 UnitPrice=38.0000
OrderID=10727 ProductID=59 UnitPrice=55.0000
OrderID=10728 ProductID=30 UnitPrice=25.8900
OrderID=10728 ProductID=40 UnitPrice=18.4000
OrderID=10728 ProductID=55 UnitPrice=24.0000
OrderID=10728 ProductID=60 UnitPrice=34.0000
OrderID=10729 ProductID=1 UnitPrice=18.0000
OrderID=10729 ProductID=21 UnitPrice=10.0000
OrderID=10729 ProductID=50 UnitPrice=16.2500
OrderID=10730 ProductID=16 UnitPrice=17.4500
OrderID=10730 ProductID=31 UnitPrice=12.5000
OrderID=10730 ProductID=65 UnitPrice=21.0500
OrderID=10731 ProductID=21 UnitPrice=10.0000
OrderID=10731 ProductID=51 UnitPrice=53.0000
OrderID=10732 ProductID=76 UnitPrice=18.0000
OrderID=10733 ProductID=14 UnitPrice=23.2500
OrderID=10733 ProductID=28 UnitPrice=45.6000
OrderID=10733 ProductID=52 UnitPrice=7.0000
OrderID=10734 ProductID=6 UnitPrice=25.0000
OrderID=10734 ProductID=30 UnitPrice=25.8900
OrderID=10734 ProductID=76 UnitPrice=18.0000
OrderID=10735 ProductID=61 UnitPrice=28.5000
OrderID=10735 ProductID=77 UnitPrice=13.0000
OrderID=10736 ProductID=65 UnitPrice=21.0500
OrderID=10736 ProductID=75 UnitPrice=7.7500
OrderID=10737 ProductID=13 UnitPrice=6.0000
OrderID=10737 ProductID=41 UnitPrice=9.6500
OrderID=10738 ProductID=16 UnitPrice=17.4500
OrderID=10739 ProductID=36 UnitPrice=19.0000
OrderID=10739 ProductID=52 UnitPrice=7.0000
OrderID=10740 ProductID=28 UnitPrice=45.6000
OrderID=10740 ProductID=35 UnitPrice=18.0000
OrderID=10740 ProductID=45 UnitPrice=9.5000
OrderID=10740 ProductID=56 UnitPrice=38.0000
OrderID=10741 ProductID=2 UnitPrice=19.0000
OrderID=10742 ProductID=3 UnitPrice=10.0000
OrderID=10742 ProductID=60 UnitPrice=34.0000
OrderID=10742 ProductID=72 UnitPrice=34.8000
OrderID=10743 ProductID=46 UnitPrice=12.0000
OrderID=10744 ProductID=40 UnitPrice=18.4000
OrderID=10745 ProductID=18 UnitPrice=62.5000
OrderID=10745 ProductID=44 UnitPrice=19.4500
OrderID=10745 ProductID=59 UnitPrice=55.0000
OrderID=10745 ProductID=72 UnitPrice=34.8000
OrderID=10746 ProductID=13 UnitPrice=6.0000
OrderID=10746 ProductID=42 UnitPrice=14.0000
OrderID=10746 ProductID=62 UnitPrice=49.3000
OrderID=10746 ProductID=69 UnitPrice=36.0000
OrderID=10747 ProductID=31 UnitPrice=12.5000
OrderID=10747 ProductID=41 UnitPrice=9.6500
OrderID=10747 ProductID=63 UnitPrice=43.9000
OrderID=10747 ProductID=69 UnitPrice=36.0000
OrderID=10748 ProductID=23 UnitPrice=9.0000
OrderID=10748 ProductID=40 UnitPrice=18.4000
OrderID=10748 ProductID=56 UnitPrice=38.0000
OrderID=10749 ProductID=56 UnitPrice=38.0000
OrderID=10749 ProductID=59 UnitPrice=55.0000
OrderID=10749 ProductID=76 UnitPrice=18.0000
OrderID=10750 ProductID=14 UnitPrice=23.2500
OrderID=10750 ProductID=45 UnitPrice=9.5000
OrderID=10750 ProductID=59 UnitPrice=55.0000
OrderID=10751 ProductID=26 UnitPrice=31.2300
OrderID=10751 ProductID=30 UnitPrice=25.8900
OrderID=10751 ProductID=50 UnitPrice=16.2500
OrderID=10751 ProductID=73 UnitPrice=15.0000
OrderID=10752 ProductID=1 UnitPrice=18.0000
OrderID=10752 ProductID=69 UnitPrice=36.0000
OrderID=10753 ProductID=45 UnitPrice=9.5000
OrderID=10753 ProductID=74 UnitPrice=10.0000
OrderID=10754 ProductID=40 UnitPrice=18.4000
OrderID=10755 ProductID=47 UnitPrice=9.5000
OrderID=10755 ProductID=56 UnitPrice=38.0000
OrderID=10755 ProductID=57 UnitPrice=19.5000
OrderID=10755 ProductID=69 UnitPrice=36.0000
OrderID=10756 ProductID=18 UnitPrice=62.5000
OrderID=10756 ProductID=36 UnitPrice=19.0000
OrderID=10756 ProductID=68 UnitPrice=12.5000
OrderID=10756 ProductID=69 UnitPrice=36.0000
OrderID=10757 ProductID=34 UnitPrice=14.0000
OrderID=10757 ProductID=59 UnitPrice=55.0000
OrderID=10757 ProductID=62 UnitPrice=49.3000
OrderID=10757 ProductID=64 UnitPrice=33.2500
OrderID=10758 ProductID=26 UnitPrice=31.2300
OrderID=10758 ProductID=52 UnitPrice=7.0000
OrderID=10758 ProductID=70 UnitPrice=15.0000
OrderID=10759 ProductID=32 UnitPrice=32.0000
OrderID=10760 ProductID=25 UnitPrice=14.0000
OrderID=10760 ProductID=27 UnitPrice=43.9000
OrderID=10760 ProductID=43 UnitPrice=46.0000
OrderID=10761 ProductID=25 UnitPrice=14.0000
OrderID=10761 ProductID=75 UnitPrice=7.7500
OrderID=10762 ProductID=39 UnitPrice=18.0000
OrderID=10762 ProductID=47 UnitPrice=9.5000
OrderID=10762 ProductID=51 UnitPrice=53.0000
OrderID=10762 ProductID=56 UnitPrice=38.0000
OrderID=10763 ProductID=21 UnitPrice=10.0000
OrderID=10763 ProductID=22 UnitPrice=21.0000
OrderID=10763 ProductID=24 UnitPrice=4.5000
OrderID=10764 ProductID=3 UnitPrice=10.0000
OrderID=10764 ProductID=39 UnitPrice=18.0000
OrderID=10765 ProductID=65 UnitPrice=21.0500
OrderID=10766 ProductID=2 UnitPrice=19.0000
OrderID=10766 ProductID=7 UnitPrice=30.0000
OrderID=10766 ProductID=68 UnitPrice=12.5000
OrderID=10767 ProductID=42 UnitPrice=14.0000
OrderID=10768 ProductID=22 UnitPrice=21.0000
OrderID=10768 ProductID=31 UnitPrice=12.5000
OrderID=10768 ProductID=60 UnitPrice=34.0000
OrderID=10768 ProductID=71 UnitPrice=21.5000
OrderID=10769 ProductID=41 UnitPrice=9.6500
OrderID=10769 ProductID=52 UnitPrice=7.0000
OrderID=10769 ProductID=61 UnitPrice=28.5000
OrderID=10769 ProductID=62 UnitPrice=49.3000
OrderID=10770 ProductID=11 UnitPrice=21.0000
OrderID=10771 ProductID=71 UnitPrice=21.5000
OrderID=10772 ProductID=29 UnitPrice=123.7900
OrderID=10772 ProductID=59 UnitPrice=55.0000
OrderID=10773 ProductID=17 UnitPrice=39.0000
OrderID=10773 ProductID=31 UnitPrice=12.5000
OrderID=10773 ProductID=75 UnitPrice=7.7500
OrderID=10774 ProductID=31 UnitPrice=12.5000
OrderID=10774 ProductID=66 UnitPrice=17.0000
OrderID=10775 ProductID=10 UnitPrice=31.0000
OrderID=10775 ProductID=67 UnitPrice=14.0000
OrderID=10776 ProductID=31 UnitPrice=12.5000
OrderID=10776 ProductID=42 UnitPrice=14.0000
OrderID=10776 ProductID=45 UnitPrice=9.5000
OrderID=10776 ProductID=51 UnitPrice=53.0000
OrderID=10777 ProductID=42 UnitPrice=14.0000
OrderID=10778 ProductID=41 UnitPrice=9.6500
OrderID=10779 ProductID=16 UnitPrice=17.4500
OrderID=10779 ProductID=62 UnitPrice=49.3000
OrderID=10780 ProductID=70 UnitPrice=15.0000
OrderID=10780 ProductID=77 UnitPrice=13.0000
OrderID=10781 ProductID=54 UnitPrice=7.4500
OrderID=10781 ProductID=56 UnitPrice=38.0000
OrderID=10781 ProductID=74 UnitPrice=10.0000
OrderID=10782 ProductID=31 UnitPrice=12.5000
OrderID=10783 ProductID=31 UnitPrice=12.5000
OrderID=10783 ProductID=38 UnitPrice=263.5000
OrderID=10784 ProductID=36 UnitPrice=19.0000
OrderID=10784 ProductID=39 UnitPrice=18.0000
OrderID=10784 ProductID=72 UnitPrice=34.8000
OrderID=10785 ProductID=10 UnitPrice=31.0000
OrderID=10785 ProductID=75 UnitPrice=7.7500
OrderID=10786 ProductID=8 UnitPrice=40.0000
OrderID=10786 ProductID=30 UnitPrice=25.8900
OrderID=10786 ProductID=75 UnitPrice=7.7500
OrderID=10787 ProductID=2 UnitPrice=19.0000
OrderID=10787 ProductID=29 UnitPrice=123.7900
OrderID=10788 ProductID=19 UnitPrice=9.2000
OrderID=10788 ProductID=75 UnitPrice=7.7500
OrderID=10789 ProductID=18 UnitPrice=62.5000
OrderID=10789 ProductID=35 UnitPrice=18.0000
OrderID=10789 ProductID=63 UnitPrice=43.9000
OrderID=10789 ProductID=68 UnitPrice=12.5000
OrderID=10790 ProductID=7 UnitPrice=30.0000
OrderID=10790 ProductID=56 UnitPrice=38.0000
OrderID=10791 ProductID=29 UnitPrice=123.7900
OrderID=10791 ProductID=41 UnitPrice=9.6500
OrderID=10792 ProductID=2 UnitPrice=19.0000
OrderID=10792 ProductID=54 UnitPrice=7.4500
OrderID=10792 ProductID=68 UnitPrice=12.5000
OrderID=10793 ProductID=41 UnitPrice=9.6500
OrderID=10793 ProductID=52 UnitPrice=7.0000
OrderID=10794 ProductID=14 UnitPrice=23.2500
OrderID=10794 ProductID=54 UnitPrice=7.4500
OrderID=10795 ProductID=16 UnitPrice=17.4500
OrderID=10795 ProductID=17 UnitPrice=39.0000
OrderID=10796 ProductID=26 UnitPrice=31.2300
OrderID=10796 ProductID=44 UnitPrice=19.4500
OrderID=10796 ProductID=64 UnitPrice=33.2500
OrderID=10796 ProductID=69 UnitPrice=36.0000
OrderID=10797 ProductID=11 UnitPrice=21.0000
OrderID=10798 ProductID=62 UnitPrice=49.3000
OrderID=10798 ProductID=72 UnitPrice=34.8000
OrderID=10799 ProductID=13 UnitPrice=6.0000
OrderID=10799 ProductID=24 UnitPrice=4.5000
OrderID=10799 ProductID=59 UnitPrice=55.0000
OrderID=10800 ProductID=11 UnitPrice=21.0000
OrderID=10800 ProductID=51 UnitPrice=53.0000
OrderID=10800 ProductID=54 UnitPrice=7.4500
OrderID=10801 ProductID=17 UnitPrice=39.0000
OrderID=10801 ProductID=29 UnitPrice=123.7900
OrderID=10802 ProductID=30 UnitPrice=25.8900
OrderID=10802 ProductID=51 UnitPrice=53.0000
OrderID=10802 ProductID=55 UnitPrice=24.0000
OrderID=10802 ProductID=62 UnitPrice=49.3000
OrderID=10803 ProductID=19 UnitPrice=9.2000
OrderID=10803 ProductID=25 UnitPrice=14.0000
OrderID=10803 ProductID=59 UnitPrice=55.0000
OrderID=10804 ProductID=10 UnitPrice=31.0000
OrderID=10804 ProductID=28 UnitPrice=45.6000
OrderID=10804 ProductID=49 UnitPrice=20.0000
OrderID=10805 ProductID=34 UnitPrice=14.0000
OrderID=10805 ProductID=38 UnitPrice=263.5000
OrderID=10806 ProductID=2 UnitPrice=19.0000
OrderID=10806 ProductID=65 UnitPrice=21.0500
OrderID=10806 ProductID=74 UnitPrice=10.0000
OrderID=10807 ProductID=40 UnitPrice=18.4000
OrderID=10808 ProductID=56 UnitPrice=38.0000
OrderID=10808 ProductID=76 UnitPrice=18.0000
OrderID=10809 ProductID=52 UnitPrice=7.0000
OrderID=10810 ProductID=13 UnitPrice=6.0000
OrderID=10810 ProductID=25 UnitPrice=14.0000
OrderID=10810 ProductID=70 UnitPrice=15.0000
OrderID=10811 ProductID=19 UnitPrice=9.2000
OrderID=10811 ProductID=23 UnitPrice=9.0000
OrderID=10811 ProductID=40 UnitPrice=18.4000
OrderID=10812 ProductID=31 UnitPrice=12.5000
OrderID=10812 ProductID=72 UnitPrice=34.8000
OrderID=10812 ProductID=77 UnitPrice=13.0000
OrderID=10813 ProductID=2 UnitPrice=19.0000
OrderID=10813 ProductID=46 UnitPrice=12.0000
OrderID=10814 ProductID=41 UnitPrice=9.6500
OrderID=10814 ProductID=43 UnitPrice=46.0000
OrderID=10814 ProductID=48 UnitPrice=12.7500
OrderID=10814 ProductID=61 UnitPrice=28.5000
OrderID=10815 ProductID=33 UnitPrice=2.5000
OrderID=10816 ProductID=38 UnitPrice=263.5000
OrderID=10816 ProductID=62 UnitPrice=49.3000
OrderID=10817 ProductID=26 UnitPrice=31.2300
OrderID=10817 ProductID=38 UnitPrice=263.5000
OrderID=10817 ProductID=40 UnitPrice=18.4000
OrderID=10817 ProductID=62 UnitPrice=49.3000
OrderID=10818 ProductID=32 UnitPrice=32.0000
OrderID=10818 ProductID=41 UnitPrice=9.6500
OrderID=10819 ProductID=43 UnitPrice=46.0000
OrderID=10819 ProductID=75 UnitPrice=7.7500
OrderID=10820 ProductID=56 UnitPrice=38.0000
OrderID=10821 ProductID=35 UnitPrice=18.0000
OrderID=10821 ProductID=51 UnitPrice=53.0000
OrderID=10822 ProductID=62 UnitPrice=49.3000
OrderID=10822 ProductID=70 UnitPrice=15.0000
OrderID=10823 ProductID=11 UnitPrice=21.0000
OrderID=10823 ProductID=57 UnitPrice=19.5000
OrderID=10823 ProductID=59 UnitPrice=55.0000
OrderID=10823 ProductID=77 UnitPrice=13.0000
OrderID=10824 ProductID=41 UnitPrice=9.6500
OrderID=10824 ProductID=70 UnitPrice=15.0000
OrderID=10825 ProductID=26 UnitPrice=31.2300
OrderID=10825 ProductID=53 UnitPrice=32.8000
OrderID=10826 ProductID=31 UnitPrice=12.5000
OrderID=10826 ProductID=57 UnitPrice=19.5000
OrderID=10827 ProductID=10 UnitPrice=31.0000
OrderID=10827 ProductID=39 UnitPrice=18.0000
OrderID=10828 ProductID=20 UnitPrice=81.0000
OrderID=10828 ProductID=38 UnitPrice=263.5000
OrderID=10829 ProductID=2 UnitPrice=19.0000
OrderID=10829 ProductID=8 UnitPrice=40.0000
OrderID=10829 ProductID=13 UnitPrice=6.0000
OrderID=10829 ProductID=60 UnitPrice=34.0000
OrderID=10830 ProductID=6 UnitPrice=25.0000
OrderID=10830 ProductID=39 UnitPrice=18.0000
OrderID=10830 ProductID=60 UnitPrice=34.0000
OrderID=10830 ProductID=68 UnitPrice=12.5000
OrderID=10831 ProductID=19 UnitPrice=9.2000
OrderID=10831 ProductID=35 UnitPrice=18.0000
OrderID=10831 ProductID=38 UnitPrice=263.5000
OrderID=10831 ProductID=43 UnitPrice=46.0000
OrderID=10832 ProductID=13 UnitPrice=6.0000
OrderID=10832 ProductID=25 UnitPrice=14.0000
OrderID=10832 ProductID=44 UnitPrice=19.4500
OrderID=10832 ProductID=64 UnitPrice=33.2500
OrderID=10833 ProductID=7 UnitPrice=30.0000
OrderID=10833 ProductID=31 UnitPrice=12.5000
OrderID=10833 ProductID=53 UnitPrice=32.8000
OrderID=10834 ProductID=29 UnitPrice=123.7900
OrderID=10834 ProductID=30 UnitPrice=25.8900
OrderID=10835 ProductID=59 UnitPrice=55.0000
OrderID=10835 ProductID=77 UnitPrice=13.0000
OrderID=10836 ProductID=22 UnitPrice=21.0000
OrderID=10836 ProductID=35 UnitPrice=18.0000
OrderID=10836 ProductID=57 UnitPrice=19.5000
OrderID=10836 ProductID=60 UnitPrice=34.0000
OrderID=10836 ProductID=64 UnitPrice=33.2500
OrderID=10837 ProductID=13 UnitPrice=6.0000
OrderID=10837 ProductID=40 UnitPrice=18.4000
OrderID=10837 ProductID=47 UnitPrice=9.5000
OrderID=10837 ProductID=76 UnitPrice=18.0000
OrderID=10838 ProductID=1 UnitPrice=18.0000
OrderID=10838 ProductID=18 UnitPrice=62.5000
OrderID=10838 ProductID=36 UnitPrice=19.0000
OrderID=10839 ProductID=58 UnitPrice=13.2500
OrderID=10839 ProductID=72 UnitPrice=34.8000
OrderID=10840 ProductID=25 UnitPrice=14.0000
OrderID=10840 ProductID=39 UnitPrice=18.0000
OrderID=10841 ProductID=10 UnitPrice=31.0000
OrderID=10841 ProductID=56 UnitPrice=38.0000
OrderID=10841 ProductID=59 UnitPrice=55.0000
OrderID=10841 ProductID=77 UnitPrice=13.0000
OrderID=10842 ProductID=11 UnitPrice=21.0000
OrderID=10842 ProductID=43 UnitPrice=46.0000
OrderID=10842 ProductID=68 UnitPrice=12.5000
OrderID=10842 ProductID=70 UnitPrice=15.0000
OrderID=10843 ProductID=51 UnitPrice=53.0000
OrderID=10844 ProductID=22 UnitPrice=21.0000
OrderID=10845 ProductID=23 UnitPrice=9.0000
OrderID=10845 ProductID=35 UnitPrice=18.0000
OrderID=10845 ProductID=42 UnitPrice=14.0000
OrderID=10845 ProductID=58 UnitPrice=13.2500
OrderID=10845 ProductID=64 UnitPrice=33.2500
OrderID=10846 ProductID=4 UnitPrice=22.0000
OrderID=10846 ProductID=70 UnitPrice=15.0000
OrderID=10846 ProductID=74 UnitPrice=10.0000
OrderID=10847 ProductID=1 UnitPrice=18.0000
OrderID=10847 ProductID=19 UnitPrice=9.2000
OrderID=10847 ProductID=37 UnitPrice=26.0000
OrderID=10847 ProductID=45 UnitPrice=9.5000
OrderID=10847 ProductID=60 UnitPrice=34.0000
OrderID=10847 ProductID=71 UnitPrice=21.5000
OrderID=10848 ProductID=5 UnitPrice=21.3500
OrderID=10848 ProductID=9 UnitPrice=97.0000
OrderID=10849 ProductID=3 UnitPrice=10.0000
OrderID=10849 ProductID=26 UnitPrice=31.2300
OrderID=10850 ProductID=25 UnitPrice=14.0000
OrderID=10850 ProductID=33 UnitPrice=2.5000
OrderID=10850 ProductID=70 UnitPrice=15.0000
OrderID=10851 ProductID=2 UnitPrice=19.0000
OrderID=10851 ProductID=25 UnitPrice=14.0000
OrderID=10851 ProductID=57 UnitPrice=19.5000
OrderID=10851 ProductID=59 UnitPrice=55.0000
OrderID=10852 ProductID=2 UnitPrice=19.0000
OrderID=10852 ProductID=17 UnitPrice=39.0000
OrderID=10852 ProductID=62 UnitPrice=49.3000
OrderID=10853 ProductID=18 UnitPrice=62.5000
OrderID=10854 ProductID=10 UnitPrice=31.0000
OrderID=10854 ProductID=13 UnitPrice=6.0000
OrderID=10855 ProductID=16 UnitPrice=17.4500
OrderID=10855 ProductID=31 UnitPrice=12.5000
OrderID=10855 ProductID=56 UnitPrice=38.0000
OrderID=10855 ProductID=65 UnitPrice=21.0500
OrderID=10856 ProductID=2 UnitPrice=19.0000
OrderID=10856 ProductID=42 UnitPrice=14.0000
OrderID=10857 ProductID=3 UnitPrice=10.0000
OrderID=10857 ProductID=26 UnitPrice=31.2300
OrderID=10857 ProductID=29 UnitPrice=123.7900
OrderID=10858 ProductID=7 UnitPrice=30.0000
OrderID=10858 ProductID=27 UnitPrice=43.9000
OrderID=10858 ProductID=70 UnitPrice=15.0000
OrderID=10859 ProductID=24 UnitPrice=4.5000
OrderID=10859 ProductID=54 UnitPrice=7.4500
OrderID=10859 ProductID=64 UnitPrice=33.2500
OrderID=10860 ProductID=51 UnitPrice=53.0000
OrderID=10860 ProductID=76 UnitPrice=18.0000
OrderID=10861 ProductID=17 UnitPrice=39.0000
OrderID=10861 ProductID=18 UnitPrice=62.5000
OrderID=10861 ProductID=21 UnitPrice=10.0000
OrderID=10861 ProductID=33 UnitPrice=2.5000
OrderID=10861 ProductID=62 UnitPrice=49.3000
OrderID=10862 ProductID=11 UnitPrice=21.0000
OrderID=10862 ProductID=52 UnitPrice=7.0000
OrderID=10863 ProductID=1 UnitPrice=18.0000
OrderID=10863 ProductID=58 UnitPrice=13.2500
OrderID=10864 ProductID=35 UnitPrice=18.0000
OrderID=10864 ProductID=67 UnitPrice=14.0000
OrderID=10865 ProductID=38 UnitPrice=263.5000
OrderID=10865 ProductID=39 UnitPrice=18.0000
OrderID=10866 ProductID=2 UnitPrice=19.0000
OrderID=10866 ProductID=24 UnitPrice=4.5000
OrderID=10866 ProductID=30 UnitPrice=25.8900
OrderID=10867 ProductID=53 UnitPrice=32.8000
OrderID=10868 ProductID=26 UnitPrice=31.2300
OrderID=10868 ProductID=35 UnitPrice=18.0000
OrderID=10868 ProductID=49 UnitPrice=20.0000
OrderID=10869 ProductID=1 UnitPrice=18.0000
OrderID=10869 ProductID=11 UnitPrice=21.0000
OrderID=10869 ProductID=23 UnitPrice=9.0000
OrderID=10869 ProductID=68 UnitPrice=12.5000
OrderID=10870 ProductID=35 UnitPrice=18.0000
OrderID=10870 ProductID=51 UnitPrice=53.0000
OrderID=10871 ProductID=6 UnitPrice=25.0000
OrderID=10871 ProductID=16 UnitPrice=17.4500
OrderID=10871 ProductID=17 UnitPrice=39.0000
OrderID=10872 ProductID=55 UnitPrice=24.0000
OrderID=10872 ProductID=62 UnitPrice=49.3000
OrderID=10872 ProductID=64 UnitPrice=33.2500
OrderID=10872 ProductID=65 UnitPrice=21.0500
OrderID=10873 ProductID=21 UnitPrice=10.0000
OrderID=10873 ProductID=28 UnitPrice=45.6000
OrderID=10874 ProductID=10 UnitPrice=31.0000
OrderID=10875 ProductID=19 UnitPrice=9.2000
OrderID=10875 ProductID=47 UnitPrice=9.5000
OrderID=10875 ProductID=49 UnitPrice=20.0000
OrderID=10876 ProductID=46 UnitPrice=12.0000
OrderID=10876 ProductID=64 UnitPrice=33.2500
OrderID=10877 ProductID=16 UnitPrice=17.4500
OrderID=10877 ProductID=18 UnitPrice=62.5000
OrderID=10878 ProductID=20 UnitPrice=81.0000
OrderID=10879 ProductID=40 UnitPrice=18.4000
OrderID=10879 ProductID=65 UnitPrice=21.0500
OrderID=10879 ProductID=76 UnitPrice=18.0000
OrderID=10880 ProductID=23 UnitPrice=9.0000
OrderID=10880 ProductID=61 UnitPrice=28.5000
OrderID=10880 ProductID=70 UnitPrice=15.0000
OrderID=10881 ProductID=73 UnitPrice=15.0000
OrderID=10882 ProductID=42 UnitPrice=14.0000
OrderID=10882 ProductID=49 UnitPrice=20.0000
OrderID=10882 ProductID=54 UnitPrice=7.4500
OrderID=10883 ProductID=24 UnitPrice=4.5000
OrderID=10884 ProductID=21 UnitPrice=10.0000
OrderID=10884 ProductID=56 UnitPrice=38.0000
OrderID=10884 ProductID=65 UnitPrice=21.0500
OrderID=10885 ProductID=2 UnitPrice=19.0000
OrderID=10885 ProductID=24 UnitPrice=4.5000
OrderID=10885 ProductID=70 UnitPrice=15.0000
OrderID=10885 ProductID=77 UnitPrice=13.0000
OrderID=10886 ProductID=10 UnitPrice=31.0000
OrderID=10886 ProductID=31 UnitPrice=12.5000
OrderID=10886 ProductID=77 UnitPrice=13.0000
OrderID=10887 ProductID=25 UnitPrice=14.0000
OrderID=10888 ProductID=2 UnitPrice=19.0000
OrderID=10888 ProductID=68 UnitPrice=12.5000
OrderID=10889 ProductID=11 UnitPrice=21.0000
OrderID=10889 ProductID=38 UnitPrice=263.5000
OrderID=10890 ProductID=17 UnitPrice=39.0000
OrderID=10890 ProductID=34 UnitPrice=14.0000
OrderID=10890 ProductID=41 UnitPrice=9.6500
OrderID=10891 ProductID=30 UnitPrice=25.8900
OrderID=10892 ProductID=59 UnitPrice=55.0000
OrderID=10893 ProductID=8 UnitPrice=40.0000
OrderID=10893 ProductID=24 UnitPrice=4.5000
OrderID=10893 ProductID=29 UnitPrice=123.7900
OrderID=10893 ProductID=30 UnitPrice=25.8900
OrderID=10893 ProductID=36 UnitPrice=19.0000
OrderID=10894 ProductID=13 UnitPrice=6.0000
OrderID=10894 ProductID=69 UnitPrice=36.0000
OrderID=10894 ProductID=75 UnitPrice=7.7500
OrderID=10895 ProductID=24 UnitPrice=4.5000
OrderID=10895 ProductID=39 UnitPrice=18.0000
OrderID=10895 ProductID=40 UnitPrice=18.4000
OrderID=10895 ProductID=60 UnitPrice=34.0000
OrderID=10896 ProductID=45 UnitPrice=9.5000
OrderID=10896 ProductID=56 UnitPrice=38.0000
OrderID=10897 ProductID=29 UnitPrice=123.7900
OrderID=10897 ProductID=30 UnitPrice=25.8900
OrderID=10898 ProductID=13 UnitPrice=6.0000
OrderID=10899 ProductID=39 UnitPrice=18.0000
OrderID=10900 ProductID=70 UnitPrice=15.0000
OrderID=10901 ProductID=41 UnitPrice=9.6500
OrderID=10901 ProductID=71 UnitPrice=21.5000
OrderID=10902 ProductID=55 UnitPrice=24.0000
OrderID=10902 ProductID=62 UnitPrice=49.3000
OrderID=10903 ProductID=13 UnitPrice=6.0000
OrderID=10903 ProductID=65 UnitPrice=21.0500
OrderID=10903 ProductID=68 UnitPrice=12.5000
OrderID=10904 ProductID=58 UnitPrice=13.2500
OrderID=10904 ProductID=62 UnitPrice=49.3000
OrderID=10905 ProductID=1 UnitPrice=18.0000
OrderID=10906 ProductID=61 UnitPrice=28.5000
OrderID=10907 ProductID=75 UnitPrice=7.7500
OrderID=10908 ProductID=7 UnitPrice=30.0000
OrderID=10908 ProductID=52 UnitPrice=7.0000
OrderID=10909 ProductID=7 UnitPrice=30.0000
OrderID=10909 ProductID=16 UnitPrice=17.4500
OrderID=10909 ProductID=41 UnitPrice=9.6500
OrderID=10910 ProductID=19 UnitPrice=9.2000
OrderID=10910 ProductID=49 UnitPrice=20.0000
OrderID=10910 ProductID=61 UnitPrice=28.5000
OrderID=10911 ProductID=1 UnitPrice=18.0000
OrderID=10911 ProductID=17 UnitPrice=39.0000
OrderID=10911 ProductID=67 UnitPrice=14.0000
OrderID=10912 ProductID=11 UnitPrice=21.0000
OrderID=10912 ProductID=29 UnitPrice=123.7900
OrderID=10913 ProductID=4 UnitPrice=22.0000
OrderID=10913 ProductID=33 UnitPrice=2.5000
OrderID=10913 ProductID=58 UnitPrice=13.2500
OrderID=10914 ProductID=71 UnitPrice=21.5000
OrderID=10915 ProductID=17 UnitPrice=39.0000
OrderID=10915 ProductID=33 UnitPrice=2.5000
OrderID=10915 ProductID=54 UnitPrice=7.4500
OrderID=10916 ProductID=16 UnitPrice=17.4500
OrderID=10916 ProductID=32 UnitPrice=32.0000
OrderID=10916 ProductID=57 UnitPrice=19.5000
OrderID=10917 ProductID=30 UnitPrice=25.8900
OrderID=10917 ProductID=60 UnitPrice=34.0000
OrderID=10918 ProductID=1 UnitPrice=18.0000
OrderID=10918 ProductID=60 UnitPrice=34.0000
OrderID=10919 ProductID=16 UnitPrice=17.4500
OrderID=10919 ProductID=25 UnitPrice=14.0000
OrderID=10919 ProductID=40 UnitPrice=18.4000
OrderID=10920 ProductID=50 UnitPrice=16.2500
OrderID=10921 ProductID=35 UnitPrice=18.0000
OrderID=10921 ProductID=63 UnitPrice=43.9000
OrderID=10922 ProductID=17 UnitPrice=39.0000
OrderID=10922 ProductID=24 UnitPrice=4.5000
OrderID=10923 ProductID=42 UnitPrice=14.0000
OrderID=10923 ProductID=43 UnitPrice=46.0000
OrderID=10923 ProductID=67 UnitPrice=14.0000
OrderID=10924 ProductID=10 UnitPrice=31.0000
OrderID=10924 ProductID=28 UnitPrice=45.6000
OrderID=10924 ProductID=75 UnitPrice=7.7500
OrderID=10925 ProductID=36 UnitPrice=19.0000
OrderID=10925 ProductID=52 UnitPrice=7.0000
OrderID=10926 ProductID=11 UnitPrice=21.0000
OrderID=10926 ProductID=13 UnitPrice=6.0000
OrderID=10926 ProductID=19 UnitPrice=9.2000
OrderID=10926 ProductID=72 UnitPrice=34.8000
OrderID=10927 ProductID=20 UnitPrice=81.0000
OrderID=10927 ProductID=52 UnitPrice=7.0000
OrderID=10927 ProductID=76 UnitPrice=18.0000
OrderID=10928 ProductID=47 UnitPrice=9.5000
OrderID=10928 ProductID=76 UnitPrice=18.0000
OrderID=10929 ProductID=21 UnitPrice=10.0000
OrderID=10929 ProductID=75 UnitPrice=7.7500
OrderID=10929 ProductID=77 UnitPrice=13.0000
OrderID=10930 ProductID=21 UnitPrice=10.0000
OrderID=10930 ProductID=27 UnitPrice=43.9000
OrderID=10930 ProductID=55 UnitPrice=24.0000
OrderID=10930 ProductID=58 UnitPrice=13.2500
OrderID=10931 ProductID=13 UnitPrice=6.0000
OrderID=10931 ProductID=57 UnitPrice=19.5000
OrderID=10932 ProductID=16 UnitPrice=17.4500
OrderID=10932 ProductID=62 UnitPrice=49.3000
OrderID=10932 ProductID=72 UnitPrice=34.8000
OrderID=10932 ProductID=75 UnitPrice=7.7500
OrderID=10933 ProductID=53 UnitPrice=32.8000
OrderID=10933 ProductID=61 UnitPrice=28.5000
OrderID=10934 ProductID=6 UnitPrice=25.0000
OrderID=10935 ProductID=1 UnitPrice=18.0000
OrderID=10935 ProductID=18 UnitPrice=62.5000
OrderID=10935 ProductID=23 UnitPrice=9.0000
OrderID=10936 ProductID=36 UnitPrice=19.0000
OrderID=10937 ProductID=28 UnitPrice=45.6000
OrderID=10937 ProductID=34 UnitPrice=14.0000
OrderID=10938 ProductID=13 UnitPrice=6.0000
OrderID=10938 ProductID=43 UnitPrice=46.0000
OrderID=10938 ProductID=60 UnitPrice=34.0000
OrderID=10938 ProductID=71 UnitPrice=21.5000
OrderID=10939 ProductID=2 UnitPrice=19.0000
OrderID=10939 ProductID=67 UnitPrice=14.0000
OrderID=10940 ProductID=7 UnitPrice=30.0000
OrderID=10940 ProductID=13 UnitPrice=6.0000
OrderID=10941 ProductID=31 UnitPrice=12.5000
OrderID=10941 ProductID=62 UnitPrice=49.3000
OrderID=10941 ProductID=68 UnitPrice=12.5000
OrderID=10941 ProductID=72 UnitPrice=34.8000
OrderID=10942 ProductID=49 UnitPrice=20.0000
OrderID=10943 ProductID=13 UnitPrice=6.0000
OrderID=10943 ProductID=22 UnitPrice=21.0000
OrderID=10943 ProductID=46 UnitPrice=12.0000
OrderID=10944 ProductID=11 UnitPrice=21.0000
OrderID=10944 ProductID=44 UnitPrice=19.4500
OrderID=10944 ProductID=56 UnitPrice=38.0000
OrderID=10945 ProductID=13 UnitPrice=6.0000
OrderID=10945 ProductID=31 UnitPrice=12.5000
OrderID=10946 ProductID=10 UnitPrice=31.0000
OrderID=10946 ProductID=24 UnitPrice=4.5000
OrderID=10946 ProductID=77 UnitPrice=13.0000
OrderID=10947 ProductID=59 UnitPrice=55.0000
OrderID=10948 ProductID=50 UnitPrice=16.2500
OrderID=10948 ProductID=51 UnitPrice=53.0000
OrderID=10948 ProductID=55 UnitPrice=24.0000
OrderID=10949 ProductID=6 UnitPrice=25.0000
OrderID=10949 ProductID=10 UnitPrice=31.0000
OrderID=10949 ProductID=17 UnitPrice=39.0000
OrderID=10949 ProductID=62 UnitPrice=49.3000
OrderID=10950 ProductID=4 UnitPrice=22.0000
OrderID=10951 ProductID=33 UnitPrice=2.5000
OrderID=10951 ProductID=41 UnitPrice=9.6500
OrderID=10951 ProductID=75 UnitPrice=7.7500
OrderID=10952 ProductID=6 UnitPrice=25.0000
OrderID=10952 ProductID=28 UnitPrice=45.6000
OrderID=10953 ProductID=20 UnitPrice=81.0000
OrderID=10953 ProductID=31 UnitPrice=12.5000
OrderID=10954 ProductID=16 UnitPrice=17.4500
OrderID=10954 ProductID=31 UnitPrice=12.5000
OrderID=10954 ProductID=45 UnitPrice=9.5000
OrderID=10954 ProductID=60 UnitPrice=34.0000
OrderID=10955 ProductID=75 UnitPrice=7.7500
OrderID=10956 ProductID=21 UnitPrice=10.0000
OrderID=10956 ProductID=47 UnitPrice=9.5000
OrderID=10956 ProductID=51 UnitPrice=53.0000
OrderID=10957 ProductID=30 UnitPrice=25.8900
OrderID=10957 ProductID=35 UnitPrice=18.0000
OrderID=10957 ProductID=64 UnitPrice=33.2500
OrderID=10958 ProductID=5 UnitPrice=21.3500
OrderID=10958 ProductID=7 UnitPrice=30.0000
OrderID=10958 ProductID=72 UnitPrice=34.8000
OrderID=10959 ProductID=75 UnitPrice=7.7500
OrderID=10960 ProductID=24 UnitPrice=4.5000
OrderID=10960 ProductID=41 UnitPrice=9.6500
OrderID=10961 ProductID=52 UnitPrice=7.0000
OrderID=10961 ProductID=76 UnitPrice=18.0000
OrderID=10962 ProductID=7 UnitPrice=30.0000
OrderID=10962 ProductID=13 UnitPrice=6.0000
OrderID=10962 ProductID=53 UnitPrice=32.8000
OrderID=10962 ProductID=69 UnitPrice=36.0000
OrderID=10962 ProductID=76 UnitPrice=18.0000
OrderID=10963 ProductID=60 UnitPrice=34.0000
OrderID=10964 ProductID=18 UnitPrice=62.5000
OrderID=10964 ProductID=38 UnitPrice=263.5000
OrderID=10964 ProductID=69 UnitPrice=36.0000
OrderID=10965 ProductID=51 UnitPrice=53.0000
OrderID=10966 ProductID=37 UnitPrice=26.0000
OrderID=10966 ProductID=56 UnitPrice=38.0000
OrderID=10966 ProductID=62 UnitPrice=49.3000
OrderID=10967 ProductID=19 UnitPrice=9.2000
OrderID=10967 ProductID=49 UnitPrice=20.0000
OrderID=10968 ProductID=12 UnitPrice=38.0000
OrderID=10968 ProductID=24 UnitPrice=4.5000
OrderID=10968 ProductID=64 UnitPrice=33.2500
OrderID=10969 ProductID=46 UnitPrice=12.0000
OrderID=10970 ProductID=52 UnitPrice=7.0000
OrderID=10971 ProductID=29 UnitPrice=123.7900
OrderID=10972 ProductID=17 UnitPrice=39.0000
OrderID=10972 ProductID=33 UnitPrice=2.5000
OrderID=10973 ProductID=26 UnitPrice=31.2300
OrderID=10973 ProductID=41 UnitPrice=9.6500
OrderID=10973 ProductID=75 UnitPrice=7.7500
OrderID=10974 ProductID=63 UnitPrice=43.9000
OrderID=10975 ProductID=8 UnitPrice=40.0000
OrderID=10975 ProductID=75 UnitPrice=7.7500
OrderID=10976 ProductID=28 UnitPrice=45.6000
OrderID=10977 ProductID=39 UnitPrice=18.0000
OrderID=10977 ProductID=47 UnitPrice=9.5000
OrderID=10977 ProductID=51 UnitPrice=53.0000
OrderID=10977 ProductID=63 UnitPrice=43.9000
OrderID=10978 ProductID=8 UnitPrice=40.0000
OrderID=10978 ProductID=21 UnitPrice=10.0000
OrderID=10978 ProductID=40 UnitPrice=18.4000
OrderID=10978 ProductID=44 UnitPrice=19.4500
OrderID=10979 ProductID=7 UnitPrice=30.0000
OrderID=10979 ProductID=12 UnitPrice=38.0000
OrderID=10979 ProductID=24 UnitPrice=4.5000
OrderID=10979 ProductID=27 UnitPrice=43.9000
OrderID=10979 ProductID=31 UnitPrice=12.5000
OrderID=10979 ProductID=63 UnitPrice=43.9000
OrderID=10980 ProductID=75 UnitPrice=7.7500
OrderID=10981 ProductID=38 UnitPrice=263.5000
OrderID=10982 ProductID=7 UnitPrice=30.0000
OrderID=10982 ProductID=43 UnitPrice=46.0000
OrderID=10983 ProductID=13 UnitPrice=6.0000
OrderID=10983 ProductID=57 UnitPrice=19.5000
OrderID=10984 ProductID=16 UnitPrice=17.4500
OrderID=10984 ProductID=24 UnitPrice=4.5000
OrderID=10984 ProductID=36 UnitPrice=19.0000
OrderID=10985 ProductID=16 UnitPrice=17.4500
OrderID=10985 ProductID=18 UnitPrice=62.5000
OrderID=10985 ProductID=32 UnitPrice=32.0000
OrderID=10986 ProductID=11 UnitPrice=21.0000
OrderID=10986 ProductID=20 UnitPrice=81.0000
OrderID=10986 ProductID=76 UnitPrice=18.0000
OrderID=10986 ProductID=77 UnitPrice=13.0000
OrderID=10987 ProductID=7 UnitPrice=30.0000
OrderID=10987 ProductID=43 UnitPrice=46.0000
OrderID=10987 ProductID=72 UnitPrice=34.8000
OrderID=10988 ProductID=7 UnitPrice=30.0000
OrderID=10988 ProductID=62 UnitPrice=49.3000
OrderID=10989 ProductID=6 UnitPrice=25.0000
OrderID=10989 ProductID=11 UnitPrice=21.0000
OrderID=10989 ProductID=41 UnitPrice=9.6500
OrderID=10990 ProductID=21 UnitPrice=10.0000
OrderID=10990 ProductID=34 UnitPrice=14.0000
OrderID=10990 ProductID=55 UnitPrice=24.0000
OrderID=10990 ProductID=61 UnitPrice=28.5000
OrderID=10991 ProductID=2 UnitPrice=19.0000
OrderID=10991 ProductID=70 UnitPrice=15.0000
OrderID=10991 ProductID=76 UnitPrice=18.0000
OrderID=10992 ProductID=72 UnitPrice=34.8000
OrderID=10993 ProductID=29 UnitPrice=123.7900
OrderID=10993 ProductID=41 UnitPrice=9.6500
OrderID=10994 ProductID=59 UnitPrice=55.0000
OrderID=10995 ProductID=51 UnitPrice=53.0000
OrderID=10995 ProductID=60 UnitPrice=34.0000
OrderID=10996 ProductID=42 UnitPrice=14.0000
OrderID=10997 ProductID=32 UnitPrice=32.0000
OrderID=10997 ProductID=46 UnitPrice=12.0000
OrderID=10997 ProductID=52 UnitPrice=7.0000
OrderID=10998 ProductID=24 UnitPrice=4.5000
OrderID=10998 ProductID=61 UnitPrice=28.5000
OrderID=10998 ProductID=74 UnitPrice=10.0000
OrderID=10998 ProductID=75 UnitPrice=7.7500
OrderID=10999 ProductID=41 UnitPrice=9.6500
OrderID=10999 ProductID=51 UnitPrice=53.0000
OrderID=10999 ProductID=77 UnitPrice=13.0000
OrderID=11000 ProductID=4 UnitPrice=22.0000
OrderID=11000 ProductID=24 UnitPrice=4.5000
OrderID=11000 ProductID=77 UnitPrice=13.0000
OrderID=11001 ProductID=7 UnitPrice=30.0000
OrderID=11001 ProductID=22 UnitPrice=21.0000
OrderID=11001 ProductID=46 UnitPrice=12.0000
OrderID=11001 ProductID=55 UnitPrice=24.0000
OrderID=11002 ProductID=13 UnitPrice=6.0000
OrderID=11002 ProductID=35 UnitPrice=18.0000
OrderID=11002 ProductID=42 UnitPrice=14.0000
OrderID=11002 ProductID=55 UnitPrice=24.0000
OrderID=11003 ProductID=1 UnitPrice=18.0000
OrderID=11003 ProductID=40 UnitPrice=18.4000
OrderID=11003 ProductID=52 UnitPrice=7.0000
OrderID=11004 ProductID=26 UnitPrice=31.2300
OrderID=11004 ProductID=76 UnitPrice=18.0000
OrderID=11005 ProductID=1 UnitPrice=18.0000
OrderID=11005 ProductID=59 UnitPrice=55.0000
OrderID=11006 ProductID=1 UnitPrice=18.0000
OrderID=11006 ProductID=29 UnitPrice=123.7900
OrderID=11007 ProductID=8 UnitPrice=40.0000
OrderID=11007 ProductID=29 UnitPrice=123.7900
OrderID=11007 ProductID=42 UnitPrice=14.0000
OrderID=11008 ProductID=28 UnitPrice=45.6000
OrderID=11008 ProductID=34 UnitPrice=14.0000
OrderID=11008 ProductID=71 UnitPrice=21.5000
OrderID=11009 ProductID=24 UnitPrice=4.5000
OrderID=11009 ProductID=36 UnitPrice=19.0000
OrderID=11009 ProductID=60 UnitPrice=34.0000
OrderID=11010 ProductID=7 UnitPrice=30.0000
OrderID=11010 ProductID=24 UnitPrice=4.5000
OrderID=11011 ProductID=58 UnitPrice=13.2500
OrderID=11011 ProductID=71 UnitPrice=21.5000
OrderID=11012 ProductID=19 UnitPrice=9.2000
OrderID=11012 ProductID=60 UnitPrice=34.0000
OrderID=11012 ProductID=71 UnitPrice=21.5000
OrderID=11013 ProductID=23 UnitPrice=9.0000
OrderID=11013 ProductID=42 UnitPrice=14.0000
OrderID=11013 ProductID=45 UnitPrice=9.5000
OrderID=11013 ProductID=68 UnitPrice=12.5000
OrderID=11014 ProductID=41 UnitPrice=9.6500
OrderID=11015 ProductID=30 UnitPrice=25.8900
OrderID=11015 ProductID=77 UnitPrice=13.0000
OrderID=11016 ProductID=31 UnitPrice=12.5000
OrderID=11016 ProductID=36 UnitPrice=19.0000
OrderID=11017 ProductID=3 UnitPrice=10.0000
OrderID=11017 ProductID=59 UnitPrice=55.0000
OrderID=11017 ProductID=70 UnitPrice=15.0000
OrderID=11018 ProductID=12 UnitPrice=38.0000
OrderID=11018 ProductID=18 UnitPrice=62.5000
OrderID=11018 ProductID=56 UnitPrice=38.0000
OrderID=11019 ProductID=46 UnitPrice=12.0000
OrderID=11019 ProductID=49 UnitPrice=20.0000
OrderID=11020 ProductID=10 UnitPrice=31.0000
OrderID=11021 ProductID=2 UnitPrice=19.0000
OrderID=11021 ProductID=20 UnitPrice=81.0000
OrderID=11021 ProductID=26 UnitPrice=31.2300
OrderID=11021 ProductID=51 UnitPrice=53.0000
OrderID=11021 ProductID=72 UnitPrice=34.8000
OrderID=11022 ProductID=19 UnitPrice=9.2000
OrderID=11022 ProductID=69 UnitPrice=36.0000
OrderID=11023 ProductID=7 UnitPrice=30.0000
OrderID=11023 ProductID=43 UnitPrice=46.0000
OrderID=11024 ProductID=26 UnitPrice=31.2300
OrderID=11024 ProductID=33 UnitPrice=2.5000
OrderID=11024 ProductID=65 UnitPrice=21.0500
OrderID=11024 ProductID=71 UnitPrice=21.5000
OrderID=11025 ProductID=1 UnitPrice=18.0000
OrderID=11025 ProductID=13 UnitPrice=6.0000
OrderID=11026 ProductID=18 UnitPrice=62.5000
OrderID=11026 ProductID=51 UnitPrice=53.0000
OrderID=11027 ProductID=24 UnitPrice=4.5000
OrderID=11027 ProductID=62 UnitPrice=49.3000
OrderID=11028 ProductID=55 UnitPrice=24.0000
OrderID=11028 ProductID=59 UnitPrice=55.0000
OrderID=11029 ProductID=56 UnitPrice=38.0000
OrderID=11029 ProductID=63 UnitPrice=43.9000
OrderID=11030 ProductID=2 UnitPrice=19.0000
OrderID=11030 ProductID=5 UnitPrice=21.3500
OrderID=11030 ProductID=29 UnitPrice=123.7900
OrderID=11030 ProductID=59 UnitPrice=55.0000
OrderID=11031 ProductID=1 UnitPrice=18.0000
OrderID=11031 ProductID=13 UnitPrice=6.0000
OrderID=11031 ProductID=24 UnitPrice=4.5000
OrderID=11031 ProductID=64 UnitPrice=33.2500
OrderID=11031 ProductID=71 UnitPrice=21.5000
OrderID=11032 ProductID=36 UnitPrice=19.0000
OrderID=11032 ProductID=38 UnitPrice=263.5000
OrderID=11032 ProductID=59 UnitPrice=55.0000
OrderID=11033 ProductID=53 UnitPrice=32.8000
OrderID=11033 ProductID=69 UnitPrice=36.0000
OrderID=11034 ProductID=21 UnitPrice=10.0000
OrderID=11034 ProductID=44 UnitPrice=19.4500
OrderID=11034 ProductID=61 UnitPrice=28.5000
OrderID=11035 ProductID=1 UnitPrice=18.0000
OrderID=11035 ProductID=35 UnitPrice=18.0000
OrderID=11035 ProductID=42 UnitPrice=14.0000
OrderID=11035 ProductID=54 UnitPrice=7.4500
OrderID=11036 ProductID=13 UnitPrice=6.0000
OrderID=11036 ProductID=59 UnitPrice=55.0000
OrderID=11037 ProductID=70 UnitPrice=15.0000
OrderID=11038 ProductID=40 UnitPrice=18.4000
OrderID=11038 ProductID=52 UnitPrice=7.0000
OrderID=11038 ProductID=71 UnitPrice=21.5000
OrderID=11039 ProductID=28 UnitPrice=45.6000
OrderID=11039 ProductID=35 UnitPrice=18.0000
OrderID=11039 ProductID=49 UnitPrice=20.0000
OrderID=11039 ProductID=57 UnitPrice=19.5000
OrderID=11040 ProductID=21 UnitPrice=10.0000
OrderID=11041 ProductID=2 UnitPrice=19.0000
OrderID=11041 ProductID=63 UnitPrice=43.9000
OrderID=11042 ProductID=44 UnitPrice=19.4500
OrderID=11042 ProductID=61 UnitPrice=28.5000
OrderID=11043 ProductID=11 UnitPrice=21.0000
OrderID=11044 ProductID=62 UnitPrice=49.3000
OrderID=11045 ProductID=33 UnitPrice=2.5000
OrderID=11045 ProductID=51 UnitPrice=53.0000
OrderID=11046 ProductID=12 UnitPrice=38.0000
OrderID=11046 ProductID=32 UnitPrice=32.0000
OrderID=11046 ProductID=35 UnitPrice=18.0000
OrderID=11047 ProductID=1 UnitPrice=18.0000
OrderID=11047 ProductID=5 UnitPrice=21.3500
OrderID=11048 ProductID=68 UnitPrice=12.5000
OrderID=11049 ProductID=2 UnitPrice=19.0000
OrderID=11049 ProductID=12 UnitPrice=38.0000
OrderID=11050 ProductID=76 UnitPrice=18.0000
OrderID=11051 ProductID=24 UnitPrice=4.5000
OrderID=11052 ProductID=43 UnitPrice=46.0000
OrderID=11052 ProductID=61 UnitPrice=28.5000
OrderID=11053 ProductID=18 UnitPrice=62.5000
OrderID=11053 ProductID=32 UnitPrice=32.0000
OrderID=11053 ProductID=64 UnitPrice=33.2500
OrderID=11054 ProductID=33 UnitPrice=2.5000
OrderID=11054 ProductID=67 UnitPrice=14.0000
OrderID=11055 ProductID=24 UnitPrice=4.5000
OrderID=11055 ProductID=25 UnitPrice=14.0000
OrderID=11055 ProductID=51 UnitPrice=53.0000
OrderID=11055 ProductID=57 UnitPrice=19.5000
OrderID=11056 ProductID=7 UnitPrice=30.0000
OrderID=11056 ProductID=55 UnitPrice=24.0000
OrderID=11056 ProductID=60 UnitPrice=34.0000
OrderID=11057 ProductID=70 UnitPrice=15.0000
OrderID=11058 ProductID=21 UnitPrice=10.0000
OrderID=11058 ProductID=60 UnitPrice=34.0000
OrderID=11058 ProductID=61 UnitPrice=28.5000
OrderID=11059 ProductID=13 UnitPrice=6.0000
OrderID=11059 ProductID=17 UnitPrice=39.0000
OrderID=11059 ProductID=60 UnitPrice=34.0000
OrderID=11060 ProductID=60 UnitPrice=34.0000
OrderID=11060 ProductID=77 UnitPrice=13.0000
OrderID=11061 ProductID=60 UnitPrice=34.0000
OrderID=11062 ProductID=53 UnitPrice=32.8000
OrderID=11062 ProductID=70 UnitPrice=15.0000
OrderID=11063 ProductID=34 UnitPrice=14.0000
OrderID=11063 ProductID=40 UnitPrice=18.4000
OrderID=11063 ProductID=41 UnitPrice=9.6500
OrderID=11064 ProductID=17 UnitPrice=39.0000
OrderID=11064 ProductID=41 UnitPrice=9.6500
OrderID=11064 ProductID=53 UnitPrice=32.8000
OrderID=11064 ProductID=55 UnitPrice=24.0000
OrderID=11064 ProductID=68 UnitPrice=12.5000
OrderID=11065 ProductID=30 UnitPrice=25.8900
OrderID=11065 ProductID=54 UnitPrice=7.4500
OrderID=11066 ProductID=16 UnitPrice=17.4500
OrderID=11066 ProductID=19 UnitPrice=9.2000
OrderID=11066 ProductID=34 UnitPrice=14.0000
OrderID=11067 ProductID=41 UnitPrice=9.6500
OrderID=11068 ProductID=28 UnitPrice=45.6000
OrderID=11068 ProductID=43 UnitPrice=46.0000
OrderID=11068 ProductID=77 UnitPrice=13.0000
OrderID=11069 ProductID=39 UnitPrice=18.0000
OrderID=11070 ProductID=1 UnitPrice=18.0000
OrderID=11070 ProductID=2 UnitPrice=19.0000
OrderID=11070 ProductID=16 UnitPrice=17.4500
OrderID=11070 ProductID=31 UnitPrice=12.5000
OrderID=11071 ProductID=7 UnitPrice=30.0000
OrderID=11071 ProductID=13 UnitPrice=6.0000
OrderID=11072 ProductID=2 UnitPrice=19.0000
OrderID=11072 ProductID=41 UnitPrice=9.6500
OrderID=11072 ProductID=50 UnitPrice=16.2500
OrderID=11072 ProductID=64 UnitPrice=33.2500
OrderID=11073 ProductID=11 UnitPrice=21.0000
OrderID=11073 ProductID=24 UnitPrice=4.5000
OrderID=11074 ProductID=16 UnitPrice=17.4500
OrderID=11075 ProductID=2 UnitPrice=19.0000
OrderID=11075 ProductID=46 UnitPrice=12.0000
OrderID=11075 ProductID=76 UnitPrice=18.0000
OrderID=11076 ProductID=6 UnitPrice=25.0000
OrderID=11076 ProductID=14 UnitPrice=23.2500
OrderID=11076 ProductID=19 UnitPrice=9.2000
OrderID=11077 ProductID=2 UnitPrice=19.0000
OrderID=11077 ProductID=3 UnitPrice=10.0000
OrderID=11077 ProductID=4 UnitPrice=22.0000
OrderID=11077 ProductID=6 UnitPrice=25.0000
OrderID=11077 ProductID=7 UnitPrice=30.0000
OrderID=11077 ProductID=8 UnitPrice=40.0000
OrderID=11077 ProductID=10 UnitPrice=31.0000
OrderID=11077 ProductID=12 UnitPrice=38.0000
OrderID=11077 ProductID=13 UnitPrice=6.0000
OrderID=11077 ProductID=14 UnitPrice=23.2500
OrderID=11077 ProductID=16 UnitPrice=17.4500
OrderID=11077 ProductID=20 UnitPrice=81.0000
OrderID=11077 ProductID=23 UnitPrice=9.0000
OrderID=11077 ProductID=32 UnitPrice=32.0000
OrderID=11077 ProductID=39 UnitPrice=18.0000
OrderID=11077 ProductID=41 UnitPrice=9.6500
OrderID=11077 ProductID=46 UnitPrice=12.0000
OrderID=11077 ProductID=52 UnitPrice=7.0000
OrderID=11077 ProductID=55 UnitPrice=24.0000
OrderID=11077 ProductID=60 UnitPrice=34.0000
OrderID=11077 ProductID=64 UnitPrice=33.2500
OrderID=11077 ProductID=66 UnitPrice=17.0000
OrderID=11077 ProductID=73 UnitPrice=15.0000
OrderID=11077 ProductID=75 UnitPrice=7.7500
OrderID=11077 ProductID=77 UnitPrice=13.0000
OrderID=11112 ProductID=12 UnitPrice=30.4000
This sample shows how to construct a join where one side is nullable and the other isn't.
Public Sub LinqToSqlJoin10()
Dim q = From o In db.Orders _
Group Join e In db.Employees _
On o.EmployeeID Equals CType(e.EmployeeID, Integer?) Into emps = Group _
From e In emps _
Select New With {o.OrderID, e.FirstName}
ObjectDumper.Write(q)
End Sub
Result:
FirstName=Nancy OrderID=10258
FirstName=Nancy OrderID=10270
FirstName=Nancy OrderID=10275
FirstName=Nancy OrderID=10285
FirstName=Nancy OrderID=10292
FirstName=Nancy OrderID=10293
FirstName=Nancy OrderID=10304
FirstName=Nancy OrderID=10306
FirstName=Nancy OrderID=10311
FirstName=Nancy OrderID=10314
FirstName=Nancy OrderID=10316
FirstName=Nancy OrderID=10325
FirstName=Nancy OrderID=10340
FirstName=Nancy OrderID=10351
FirstName=Nancy OrderID=10357
FirstName=Nancy OrderID=10361
FirstName=Nancy OrderID=10364
FirstName=Nancy OrderID=10371
FirstName=Nancy OrderID=10374
FirstName=Nancy OrderID=10376
FirstName=Nancy OrderID=10377
FirstName=Nancy OrderID=10385
FirstName=Nancy OrderID=10387
FirstName=Nancy OrderID=10393
FirstName=Nancy OrderID=10394
FirstName=Nancy OrderID=10396
FirstName=Nancy OrderID=10400
FirstName=Nancy OrderID=10401
FirstName=Nancy OrderID=10405
FirstName=Nancy OrderID=10453
FirstName=Nancy OrderID=10461
FirstName=Nancy OrderID=10465
FirstName=Nancy OrderID=10469
FirstName=Nancy OrderID=10473
FirstName=Nancy OrderID=10482
FirstName=Nancy OrderID=10486
FirstName=Nancy OrderID=10508
FirstName=Nancy OrderID=10524
FirstName=Nancy OrderID=10525
FirstName=Nancy OrderID=10537
FirstName=Nancy OrderID=10542
FirstName=Nancy OrderID=10546
FirstName=Nancy OrderID=10558
FirstName=Nancy OrderID=10562
FirstName=Nancy OrderID=10567
FirstName=Nancy OrderID=10579
FirstName=Nancy OrderID=10587
FirstName=Nancy OrderID=10591
FirstName=Nancy OrderID=10598
FirstName=Nancy OrderID=10604
FirstName=Nancy OrderID=10605
FirstName=Nancy OrderID=10612
FirstName=Nancy OrderID=10616
FirstName=Nancy OrderID=10618
FirstName=Nancy OrderID=10626
FirstName=Nancy OrderID=10630
FirstName=Nancy OrderID=10653
FirstName=Nancy OrderID=10655
FirstName=Nancy OrderID=10664
FirstName=Nancy OrderID=10665
FirstName=Nancy OrderID=10668
FirstName=Nancy OrderID=10671
FirstName=Nancy OrderID=10677
FirstName=Nancy OrderID=10680
FirstName=Nancy OrderID=10689
FirstName=Nancy OrderID=10690
FirstName=Nancy OrderID=10709
FirstName=Nancy OrderID=10710
FirstName=Nancy OrderID=10713
FirstName=Nancy OrderID=10717
FirstName=Nancy OrderID=10718
FirstName=Nancy OrderID=10733
FirstName=Nancy OrderID=10743
FirstName=Nancy OrderID=10746
FirstName=Nancy OrderID=10773
FirstName=Nancy OrderID=10776
FirstName=Nancy OrderID=10785
FirstName=Nancy OrderID=10788
FirstName=Nancy OrderID=10789
FirstName=Nancy OrderID=10792
FirstName=Nancy OrderID=10800
FirstName=Nancy OrderID=10813
FirstName=Nancy OrderID=10821
FirstName=Nancy OrderID=10825
FirstName=Nancy OrderID=10827
FirstName=Nancy OrderID=10834
FirstName=Nancy OrderID=10835
FirstName=Nancy OrderID=10842
FirstName=Nancy OrderID=10850
FirstName=Nancy OrderID=10859
FirstName=Nancy OrderID=10877
FirstName=Nancy OrderID=10886
FirstName=Nancy OrderID=10888
FirstName=Nancy OrderID=10894
FirstName=Nancy OrderID=10900
FirstName=Nancy OrderID=10902
FirstName=Nancy OrderID=10909
FirstName=Nancy OrderID=10910
FirstName=Nancy OrderID=10916
FirstName=Nancy OrderID=10921
FirstName=Nancy OrderID=10928
FirstName=Nancy OrderID=10946
FirstName=Nancy OrderID=10950
FirstName=Nancy OrderID=10952
FirstName=Nancy OrderID=10968
FirstName=Nancy OrderID=10969
FirstName=Nancy OrderID=10975
FirstName=Nancy OrderID=10976
FirstName=Nancy OrderID=10981
FirstName=Nancy OrderID=10984
FirstName=Nancy OrderID=10991
FirstName=Nancy OrderID=10992
FirstName=Nancy OrderID=10995
FirstName=Nancy OrderID=11012
FirstName=Nancy OrderID=11023
FirstName=Nancy OrderID=11027
FirstName=Nancy OrderID=11038
FirstName=Nancy OrderID=11039
FirstName=Nancy OrderID=11064
FirstName=Nancy OrderID=11067
FirstName=Nancy OrderID=11069
FirstName=Nancy OrderID=11071
FirstName=Nancy OrderID=11077
FirstName=Andrew OrderID=10265
FirstName=Andrew OrderID=10277
FirstName=Andrew OrderID=10280
FirstName=Andrew OrderID=10295
FirstName=Andrew OrderID=10300
FirstName=Andrew OrderID=10307
FirstName=Andrew OrderID=10312
FirstName=Andrew OrderID=10313
FirstName=Andrew OrderID=10327
FirstName=Andrew OrderID=10339
FirstName=Andrew OrderID=10345
FirstName=Andrew OrderID=10368
FirstName=Andrew OrderID=10379
FirstName=Andrew OrderID=10388
FirstName=Andrew OrderID=10392
FirstName=Andrew OrderID=10398
FirstName=Andrew OrderID=10404
FirstName=Andrew OrderID=10407
FirstName=Andrew OrderID=10414
FirstName=Andrew OrderID=10422
FirstName=Andrew OrderID=10457
FirstName=Andrew OrderID=10462
FirstName=Andrew OrderID=10471
FirstName=Andrew OrderID=10478
FirstName=Andrew OrderID=10487
FirstName=Andrew OrderID=10502
FirstName=Andrew OrderID=10515
FirstName=Andrew OrderID=10516
FirstName=Andrew OrderID=10541
FirstName=Andrew OrderID=10552
FirstName=Andrew OrderID=10553
FirstName=Andrew OrderID=10556
FirstName=Andrew OrderID=10561
FirstName=Andrew OrderID=10563
FirstName=Andrew OrderID=10583
FirstName=Andrew OrderID=10588
FirstName=Andrew OrderID=10595
FirstName=Andrew OrderID=10615
FirstName=Andrew OrderID=10620
FirstName=Andrew OrderID=10657
FirstName=Andrew OrderID=10663
FirstName=Andrew OrderID=10669
FirstName=Andrew OrderID=10673
FirstName=Andrew OrderID=10676
FirstName=Andrew OrderID=10683
FirstName=Andrew OrderID=10686
FirstName=Andrew OrderID=10691
FirstName=Andrew OrderID=10727
FirstName=Andrew OrderID=10734
FirstName=Andrew OrderID=10737
FirstName=Andrew OrderID=10738
FirstName=Andrew OrderID=10752
FirstName=Andrew OrderID=10780
FirstName=Andrew OrderID=10781
FirstName=Andrew OrderID=10787
FirstName=Andrew OrderID=10798
FirstName=Andrew OrderID=10805
FirstName=Andrew OrderID=10808
FirstName=Andrew OrderID=10810
FirstName=Andrew OrderID=10815
FirstName=Andrew OrderID=10819
FirstName=Andrew OrderID=10832
FirstName=Andrew OrderID=10846
FirstName=Andrew OrderID=10858
FirstName=Andrew OrderID=10865
FirstName=Andrew OrderID=10912
FirstName=Andrew OrderID=10915
FirstName=Andrew OrderID=10919
FirstName=Andrew OrderID=10939
FirstName=Andrew OrderID=10949
FirstName=Andrew OrderID=10967
FirstName=Andrew OrderID=10971
FirstName=Andrew OrderID=10982
FirstName=Andrew OrderID=10983
FirstName=Andrew OrderID=10985
FirstName=Andrew OrderID=10989
FirstName=Andrew OrderID=10990
FirstName=Andrew OrderID=10994
FirstName=Andrew OrderID=11000
FirstName=Andrew OrderID=11001
FirstName=Andrew OrderID=11005
FirstName=Andrew OrderID=11009
FirstName=Andrew OrderID=11010
FirstName=Andrew OrderID=11013
FirstName=Andrew OrderID=11014
FirstName=Andrew OrderID=11015
FirstName=Andrew OrderID=11020
FirstName=Andrew OrderID=11028
FirstName=Andrew OrderID=11032
FirstName=Andrew OrderID=11035
FirstName=Andrew OrderID=11042
FirstName=Andrew OrderID=11053
FirstName=Andrew OrderID=11059
FirstName=Andrew OrderID=11060
FirstName=Andrew OrderID=11070
FirstName=Andrew OrderID=11073
FirstName=Janet OrderID=10251
FirstName=Janet OrderID=10253
FirstName=Janet OrderID=10256
FirstName=Janet OrderID=10273
FirstName=Janet OrderID=10283
FirstName=Janet OrderID=10309
FirstName=Janet OrderID=10321
FirstName=Janet OrderID=10330
FirstName=Janet OrderID=10332
FirstName=Janet OrderID=10346
FirstName=Janet OrderID=10352
FirstName=Janet OrderID=10362
FirstName=Janet OrderID=10365
FirstName=Janet OrderID=10375
FirstName=Janet OrderID=10381
FirstName=Janet OrderID=10384
FirstName=Janet OrderID=10391
FirstName=Janet OrderID=10409
FirstName=Janet OrderID=10410
FirstName=Janet OrderID=10413
FirstName=Janet OrderID=10415
FirstName=Janet OrderID=10420
FirstName=Janet OrderID=10429
FirstName=Janet OrderID=10432
FirstName=Janet OrderID=10433
FirstName=Janet OrderID=10434
FirstName=Janet OrderID=10436
FirstName=Janet OrderID=10438
FirstName=Janet OrderID=10441
FirstName=Janet OrderID=10442
FirstName=Janet OrderID=10444
FirstName=Janet OrderID=10445
FirstName=Janet OrderID=10449
FirstName=Janet OrderID=10468
FirstName=Janet OrderID=10479
FirstName=Janet OrderID=10484
FirstName=Janet OrderID=10492
FirstName=Janet OrderID=10495
FirstName=Janet OrderID=10505
FirstName=Janet OrderID=10514
FirstName=Janet OrderID=10517
FirstName=Janet OrderID=10530
FirstName=Janet OrderID=10536
FirstName=Janet OrderID=10540
FirstName=Janet OrderID=10547
FirstName=Janet OrderID=10548
FirstName=Janet OrderID=10568
FirstName=Janet OrderID=10570
FirstName=Janet OrderID=10572
FirstName=Janet OrderID=10576
FirstName=Janet OrderID=10581
FirstName=Janet OrderID=10582
FirstName=Janet OrderID=10592
FirstName=Janet OrderID=10594
FirstName=Janet OrderID=10619
FirstName=Janet OrderID=10625
FirstName=Janet OrderID=10638
FirstName=Janet OrderID=10644
FirstName=Janet OrderID=10662
FirstName=Janet OrderID=10681
FirstName=Janet OrderID=10682
FirstName=Janet OrderID=10684
FirstName=Janet OrderID=10693
FirstName=Janet OrderID=10697
FirstName=Janet OrderID=10699
FirstName=Janet OrderID=10700
FirstName=Janet OrderID=10712
FirstName=Janet OrderID=10715
FirstName=Janet OrderID=10723
FirstName=Janet OrderID=10732
FirstName=Janet OrderID=10739
FirstName=Janet OrderID=10742
FirstName=Janet OrderID=10748
FirstName=Janet OrderID=10751
FirstName=Janet OrderID=10753
FirstName=Janet OrderID=10758
FirstName=Janet OrderID=10759
FirstName=Janet OrderID=10762
FirstName=Janet OrderID=10763
FirstName=Janet OrderID=10765
FirstName=Janet OrderID=10768
FirstName=Janet OrderID=10769
FirstName=Janet OrderID=10772
FirstName=Janet OrderID=10778
FirstName=Janet OrderID=10779
FirstName=Janet OrderID=10793
FirstName=Janet OrderID=10796
FirstName=Janet OrderID=10806
FirstName=Janet OrderID=10814
FirstName=Janet OrderID=10817
FirstName=Janet OrderID=10820
FirstName=Janet OrderID=10831
FirstName=Janet OrderID=10838
FirstName=Janet OrderID=10839
FirstName=Janet OrderID=10854
FirstName=Janet OrderID=10855
FirstName=Janet OrderID=10856
FirstName=Janet OrderID=10860
FirstName=Janet OrderID=10879
FirstName=Janet OrderID=10895
FirstName=Janet OrderID=10897
FirstName=Janet OrderID=10903
FirstName=Janet OrderID=10904
FirstName=Janet OrderID=10911
FirstName=Janet OrderID=10918
FirstName=Janet OrderID=10924
FirstName=Janet OrderID=10925
FirstName=Janet OrderID=10934
FirstName=Janet OrderID=10936
FirstName=Janet OrderID=10938
FirstName=Janet OrderID=10947
FirstName=Janet OrderID=10948
FirstName=Janet OrderID=10960
FirstName=Janet OrderID=10964
FirstName=Janet OrderID=10974
FirstName=Janet OrderID=10988
FirstName=Janet OrderID=11003
FirstName=Janet OrderID=11004
FirstName=Janet OrderID=11006
FirstName=Janet OrderID=11011
FirstName=Janet OrderID=11021
FirstName=Janet OrderID=11041
FirstName=Janet OrderID=11049
FirstName=Janet OrderID=11052
FirstName=Janet OrderID=11057
FirstName=Janet OrderID=11063
FirstName=Janet OrderID=11112
FirstName=Margaret OrderID=10250
FirstName=Margaret OrderID=10252
FirstName=Margaret OrderID=10257
FirstName=Margaret OrderID=10259
FirstName=Margaret OrderID=10260
FirstName=Margaret OrderID=10261
FirstName=Margaret OrderID=10267
FirstName=Margaret OrderID=10281
FirstName=Margaret OrderID=10282
FirstName=Margaret OrderID=10284
FirstName=Margaret OrderID=10288
FirstName=Margaret OrderID=10294
FirstName=Margaret OrderID=10299
FirstName=Margaret OrderID=10302
FirstName=Margaret OrderID=10315
FirstName=Margaret OrderID=10323
FirstName=Margaret OrderID=10326
FirstName=Margaret OrderID=10328
FirstName=Margaret OrderID=10329
FirstName=Margaret OrderID=10337
FirstName=Margaret OrderID=10338
FirstName=Margaret OrderID=10342
FirstName=Margaret OrderID=10343
FirstName=Margaret OrderID=10344
FirstName=Margaret OrderID=10347
FirstName=Margaret OrderID=10348
FirstName=Margaret OrderID=10360
FirstName=Margaret OrderID=10363
FirstName=Margaret OrderID=10373
FirstName=Margaret OrderID=10382
FirstName=Margaret OrderID=10389
FirstName=Margaret OrderID=10403
FirstName=Margaret OrderID=10417
FirstName=Margaret OrderID=10418
FirstName=Margaret OrderID=10419
FirstName=Margaret OrderID=10426
FirstName=Margaret OrderID=10427
FirstName=Margaret OrderID=10430
FirstName=Margaret OrderID=10431
FirstName=Margaret OrderID=10440
FirstName=Margaret OrderID=10447
FirstName=Margaret OrderID=10448
FirstName=Margaret OrderID=10451
FirstName=Margaret OrderID=10454
FirstName=Margaret OrderID=10459
FirstName=Margaret OrderID=10464
FirstName=Margaret OrderID=10466
FirstName=Margaret OrderID=10470
FirstName=Margaret OrderID=10485
FirstName=Margaret OrderID=10493
FirstName=Margaret OrderID=10494
FirstName=Margaret OrderID=10499
FirstName=Margaret OrderID=10504
FirstName=Margaret OrderID=10509
FirstName=Margaret OrderID=10511
FirstName=Margaret OrderID=10518
FirstName=Margaret OrderID=10522
FirstName=Margaret OrderID=10526
FirstName=Margaret OrderID=10535
FirstName=Margaret OrderID=10544
FirstName=Margaret OrderID=10551
FirstName=Margaret OrderID=10554
FirstName=Margaret OrderID=10564
FirstName=Margaret OrderID=10574
FirstName=Margaret OrderID=10578
FirstName=Margaret OrderID=10580
FirstName=Margaret OrderID=10584
FirstName=Margaret OrderID=10590
FirstName=Margaret OrderID=10600
FirstName=Margaret OrderID=10606
FirstName=Margaret OrderID=10608
FirstName=Margaret OrderID=10613
FirstName=Margaret OrderID=10617
FirstName=Margaret OrderID=10621
FirstName=Margaret OrderID=10622
FirstName=Margaret OrderID=10624
FirstName=Margaret OrderID=10628
FirstName=Margaret OrderID=10629
FirstName=Margaret OrderID=10634
FirstName=Margaret OrderID=10636
FirstName=Margaret OrderID=10640
FirstName=Margaret OrderID=10641
FirstName=Margaret OrderID=10645
FirstName=Margaret OrderID=10647
FirstName=Margaret OrderID=10652
FirstName=Margaret OrderID=10658
FirstName=Margaret OrderID=10670
FirstName=Margaret OrderID=10674
FirstName=Margaret OrderID=10685
FirstName=Margaret OrderID=10688
FirstName=Margaret OrderID=10692
FirstName=Margaret OrderID=10698
FirstName=Margaret OrderID=10702
FirstName=Margaret OrderID=10707
FirstName=Margaret OrderID=10716
FirstName=Margaret OrderID=10725
FirstName=Margaret OrderID=10726
FirstName=Margaret OrderID=10728
FirstName=Margaret OrderID=10740
FirstName=Margaret OrderID=10741
FirstName=Margaret OrderID=10749
FirstName=Margaret OrderID=10755
FirstName=Margaret OrderID=10760
FirstName=Margaret OrderID=10766
FirstName=Margaret OrderID=10767
FirstName=Margaret OrderID=10774
FirstName=Margaret OrderID=10783
FirstName=Margaret OrderID=10784
FirstName=Margaret OrderID=10801
FirstName=Margaret OrderID=10802
FirstName=Margaret OrderID=10803
FirstName=Margaret OrderID=10807
FirstName=Margaret OrderID=10816
FirstName=Margaret OrderID=10830
FirstName=Margaret OrderID=10840
FirstName=Margaret OrderID=10843
FirstName=Margaret OrderID=10847
FirstName=Margaret OrderID=10861
FirstName=Margaret OrderID=10863
FirstName=Margaret OrderID=10864
FirstName=Margaret OrderID=10873
FirstName=Margaret OrderID=10875
FirstName=Margaret OrderID=10878
FirstName=Margaret OrderID=10881
FirstName=Margaret OrderID=10882
FirstName=Margaret OrderID=10884
FirstName=Margaret OrderID=10892
FirstName=Margaret OrderID=10898
FirstName=Margaret OrderID=10901
FirstName=Margaret OrderID=10906
FirstName=Margaret OrderID=10908
FirstName=Margaret OrderID=10913
FirstName=Margaret OrderID=10917
FirstName=Margaret OrderID=10920
FirstName=Margaret OrderID=10926
FirstName=Margaret OrderID=10927
FirstName=Margaret OrderID=10930
FirstName=Margaret OrderID=10931
FirstName=Margaret OrderID=10935
FirstName=Margaret OrderID=10943
FirstName=Margaret OrderID=10945
FirstName=Margaret OrderID=10966
FirstName=Margaret OrderID=10972
FirstName=Margaret OrderID=10980
FirstName=Margaret OrderID=10996
FirstName=Margaret OrderID=11002
FirstName=Margaret OrderID=11018
FirstName=Margaret OrderID=11024
FirstName=Margaret OrderID=11026
FirstName=Margaret OrderID=11029
FirstName=Margaret OrderID=11040
FirstName=Margaret OrderID=11044
FirstName=Margaret OrderID=11061
FirstName=Margaret OrderID=11062
FirstName=Margaret OrderID=11072
FirstName=Margaret OrderID=11076
FirstName=Steven OrderID=10248
FirstName=Steven OrderID=10254
FirstName=Steven OrderID=10269
FirstName=Steven OrderID=10297
FirstName=Steven OrderID=10320
FirstName=Steven OrderID=10333
FirstName=Steven OrderID=10358
FirstName=Steven OrderID=10359
FirstName=Steven OrderID=10372
FirstName=Steven OrderID=10378
FirstName=Steven OrderID=10397
FirstName=Steven OrderID=10463
FirstName=Steven OrderID=10474
FirstName=Steven OrderID=10477
FirstName=Steven OrderID=10529
FirstName=Steven OrderID=10549
FirstName=Steven OrderID=10569
FirstName=Steven OrderID=10575
FirstName=Steven OrderID=10607
FirstName=Steven OrderID=10648
FirstName=Steven OrderID=10649
FirstName=Steven OrderID=10650
FirstName=Steven OrderID=10654
FirstName=Steven OrderID=10675
FirstName=Steven OrderID=10711
FirstName=Steven OrderID=10714
FirstName=Steven OrderID=10721
FirstName=Steven OrderID=10730
FirstName=Steven OrderID=10761
FirstName=Steven OrderID=10812
FirstName=Steven OrderID=10823
FirstName=Steven OrderID=10841
FirstName=Steven OrderID=10851
FirstName=Steven OrderID=10866
FirstName=Steven OrderID=10869
FirstName=Steven OrderID=10870
FirstName=Steven OrderID=10872
FirstName=Steven OrderID=10874
FirstName=Steven OrderID=10899
FirstName=Steven OrderID=10922
FirstName=Steven OrderID=10954
FirstName=Steven OrderID=11043
FirstName=Michael OrderID=10249
FirstName=Michael OrderID=10264
FirstName=Michael OrderID=10271
FirstName=Michael OrderID=10272
FirstName=Michael OrderID=10274
FirstName=Michael OrderID=10291
FirstName=Michael OrderID=10296
FirstName=Michael OrderID=10298
FirstName=Michael OrderID=10317
FirstName=Michael OrderID=10350
FirstName=Michael OrderID=10355
FirstName=Michael OrderID=10356
FirstName=Michael OrderID=10370
FirstName=Michael OrderID=10390
FirstName=Michael OrderID=10395
FirstName=Michael OrderID=10423
FirstName=Michael OrderID=10425
FirstName=Michael OrderID=10439
FirstName=Michael OrderID=10446
FirstName=Michael OrderID=10480
FirstName=Michael OrderID=10489
FirstName=Michael OrderID=10500
FirstName=Michael OrderID=10503
FirstName=Michael OrderID=10510
FirstName=Michael OrderID=10519
FirstName=Michael OrderID=10528
FirstName=Michael OrderID=10539
FirstName=Michael OrderID=10555
FirstName=Michael OrderID=10559
FirstName=Michael OrderID=10599
FirstName=Michael OrderID=10611
FirstName=Michael OrderID=10637
FirstName=Michael OrderID=10643
FirstName=Michael OrderID=10656
FirstName=Michael OrderID=10701
FirstName=Michael OrderID=10703
FirstName=Michael OrderID=10704
FirstName=Michael OrderID=10708
FirstName=Michael OrderID=10735
FirstName=Michael OrderID=10744
FirstName=Michael OrderID=10747
FirstName=Michael OrderID=10754
FirstName=Michael OrderID=10757
FirstName=Michael OrderID=10764
FirstName=Michael OrderID=10790
FirstName=Michael OrderID=10791
FirstName=Michael OrderID=10794
FirstName=Michael OrderID=10804
FirstName=Michael OrderID=10822
FirstName=Michael OrderID=10826
FirstName=Michael OrderID=10833
FirstName=Michael OrderID=10867
FirstName=Michael OrderID=10885
FirstName=Michael OrderID=10907
FirstName=Michael OrderID=10914
FirstName=Michael OrderID=10929
FirstName=Michael OrderID=10933
FirstName=Michael OrderID=10944
FirstName=Michael OrderID=10956
FirstName=Michael OrderID=10959
FirstName=Michael OrderID=10965
FirstName=Michael OrderID=10973
FirstName=Michael OrderID=10999
FirstName=Michael OrderID=11019
FirstName=Michael OrderID=11025
FirstName=Michael OrderID=11031
FirstName=Michael OrderID=11045
FirstName=Robert OrderID=10289
FirstName=Robert OrderID=10303
FirstName=Robert OrderID=10308
FirstName=Robert OrderID=10319
FirstName=Robert OrderID=10322
FirstName=Robert OrderID=10335
FirstName=Robert OrderID=10336
FirstName=Robert OrderID=10341
FirstName=Robert OrderID=10349
FirstName=Robert OrderID=10353
FirstName=Robert OrderID=10367
FirstName=Robert OrderID=10406
FirstName=Robert OrderID=10424
FirstName=Robert OrderID=10428
FirstName=Robert OrderID=10458
FirstName=Robert OrderID=10483
FirstName=Robert OrderID=10490
FirstName=Robert OrderID=10496
FirstName=Robert OrderID=10497
FirstName=Robert OrderID=10507
FirstName=Robert OrderID=10512
FirstName=Robert OrderID=10513
FirstName=Robert OrderID=10520
FirstName=Robert OrderID=10523
FirstName=Robert OrderID=10527
FirstName=Robert OrderID=10531
FirstName=Robert OrderID=10532
FirstName=Robert OrderID=10550
FirstName=Robert OrderID=10573
FirstName=Robert OrderID=10585
FirstName=Robert OrderID=10593
FirstName=Robert OrderID=10597
FirstName=Robert OrderID=10601
FirstName=Robert OrderID=10609
FirstName=Robert OrderID=10633
FirstName=Robert OrderID=10639
FirstName=Robert OrderID=10642
FirstName=Robert OrderID=10659
FirstName=Robert OrderID=10661
FirstName=Robert OrderID=10666
FirstName=Robert OrderID=10667
FirstName=Robert OrderID=10678
FirstName=Robert OrderID=10695
FirstName=Robert OrderID=10731
FirstName=Robert OrderID=10775
FirstName=Robert OrderID=10777
FirstName=Robert OrderID=10797
FirstName=Robert OrderID=10809
FirstName=Robert OrderID=10818
FirstName=Robert OrderID=10836
FirstName=Robert OrderID=10848
FirstName=Robert OrderID=10868
FirstName=Robert OrderID=10876
FirstName=Robert OrderID=10880
FirstName=Robert OrderID=10890
FirstName=Robert OrderID=10891
FirstName=Robert OrderID=10896
FirstName=Robert OrderID=10923
FirstName=Robert OrderID=10937
FirstName=Robert OrderID=10941
FirstName=Robert OrderID=10958
FirstName=Robert OrderID=10993
FirstName=Robert OrderID=11008
FirstName=Robert OrderID=11030
FirstName=Robert OrderID=11033
FirstName=Robert OrderID=11037
FirstName=Robert OrderID=11047
FirstName=Robert OrderID=11048
FirstName=Robert OrderID=11051
FirstName=Robert OrderID=11055
FirstName=Robert OrderID=11066
FirstName=Robert OrderID=11074
FirstName=Laura OrderID=10262
FirstName=Laura OrderID=10268
FirstName=Laura OrderID=10276
FirstName=Laura OrderID=10278
FirstName=Laura OrderID=10279
FirstName=Laura OrderID=10286
FirstName=Laura OrderID=10287
FirstName=Laura OrderID=10290
FirstName=Laura OrderID=10301
FirstName=Laura OrderID=10305
FirstName=Laura OrderID=10310
FirstName=Laura OrderID=10318
FirstName=Laura OrderID=10334
FirstName=Laura OrderID=10354
FirstName=Laura OrderID=10366
FirstName=Laura OrderID=10369
FirstName=Laura OrderID=10380
FirstName=Laura OrderID=10383
FirstName=Laura OrderID=10399
FirstName=Laura OrderID=10402
FirstName=Laura OrderID=10408
FirstName=Laura OrderID=10412
FirstName=Laura OrderID=10416
FirstName=Laura OrderID=10421
FirstName=Laura OrderID=10435
FirstName=Laura OrderID=10437
FirstName=Laura OrderID=10443
FirstName=Laura OrderID=10450
FirstName=Laura OrderID=10452
FirstName=Laura OrderID=10455
FirstName=Laura OrderID=10456
FirstName=Laura OrderID=10460
FirstName=Laura OrderID=10467
FirstName=Laura OrderID=10472
FirstName=Laura OrderID=10476
FirstName=Laura OrderID=10481
FirstName=Laura OrderID=10488
FirstName=Laura OrderID=10491
FirstName=Laura OrderID=10498
FirstName=Laura OrderID=10521
FirstName=Laura OrderID=10533
FirstName=Laura OrderID=10534
FirstName=Laura OrderID=10543
FirstName=Laura OrderID=10545
FirstName=Laura OrderID=10560
FirstName=Laura OrderID=10565
FirstName=Laura OrderID=10571
FirstName=Laura OrderID=10589
FirstName=Laura OrderID=10596
FirstName=Laura OrderID=10602
FirstName=Laura OrderID=10603
FirstName=Laura OrderID=10610
FirstName=Laura OrderID=10614
FirstName=Laura OrderID=10623
FirstName=Laura OrderID=10627
FirstName=Laura OrderID=10631
FirstName=Laura OrderID=10632
FirstName=Laura OrderID=10635
FirstName=Laura OrderID=10651
FirstName=Laura OrderID=10660
FirstName=Laura OrderID=10679
FirstName=Laura OrderID=10694
FirstName=Laura OrderID=10696
FirstName=Laura OrderID=10706
FirstName=Laura OrderID=10719
FirstName=Laura OrderID=10720
FirstName=Laura OrderID=10722
FirstName=Laura OrderID=10724
FirstName=Laura OrderID=10729
FirstName=Laura OrderID=10756
FirstName=Laura OrderID=10770
FirstName=Laura OrderID=10786
FirstName=Laura OrderID=10795
FirstName=Laura OrderID=10811
FirstName=Laura OrderID=10824
FirstName=Laura OrderID=10844
FirstName=Laura OrderID=10845
FirstName=Laura OrderID=10852
FirstName=Laura OrderID=10857
FirstName=Laura OrderID=10862
FirstName=Laura OrderID=10883
FirstName=Laura OrderID=10887
FirstName=Laura OrderID=10932
FirstName=Laura OrderID=10940
FirstName=Laura OrderID=10955
FirstName=Laura OrderID=10957
FirstName=Laura OrderID=10961
FirstName=Laura OrderID=10962
FirstName=Laura OrderID=10977
FirstName=Laura OrderID=10979
FirstName=Laura OrderID=10986
FirstName=Laura OrderID=10987
FirstName=Laura OrderID=10997
FirstName=Laura OrderID=10998
FirstName=Laura OrderID=11007
FirstName=Laura OrderID=11034
FirstName=Laura OrderID=11036
FirstName=Laura OrderID=11046
FirstName=Laura OrderID=11050
FirstName=Laura OrderID=11054
FirstName=Laura OrderID=11056
FirstName=Laura OrderID=11065
FirstName=Laura OrderID=11068
FirstName=Laura OrderID=11075
FirstName=Anne OrderID=10255
FirstName=Anne OrderID=10263
FirstName=Anne OrderID=10324
FirstName=Anne OrderID=10331
FirstName=Anne OrderID=10386
FirstName=Anne OrderID=10411
FirstName=Anne OrderID=10475
FirstName=Anne OrderID=10501
FirstName=Anne OrderID=10506
FirstName=Anne OrderID=10538
FirstName=Anne OrderID=10557
FirstName=Anne OrderID=10566
FirstName=Anne OrderID=10577
FirstName=Anne OrderID=10586
FirstName=Anne OrderID=10646
FirstName=Anne OrderID=10672
FirstName=Anne OrderID=10687
FirstName=Anne OrderID=10705
FirstName=Anne OrderID=10736
FirstName=Anne OrderID=10745
FirstName=Anne OrderID=10750
FirstName=Anne OrderID=10771
FirstName=Anne OrderID=10782
FirstName=Anne OrderID=10799
FirstName=Anne OrderID=10828
FirstName=Anne OrderID=10829
FirstName=Anne OrderID=10837
FirstName=Anne OrderID=10849
FirstName=Anne OrderID=10853
FirstName=Anne OrderID=10871
FirstName=Anne OrderID=10889
FirstName=Anne OrderID=10893
FirstName=Anne OrderID=10905
FirstName=Anne OrderID=10942
FirstName=Anne OrderID=10951
FirstName=Anne OrderID=10953
FirstName=Anne OrderID=10963
FirstName=Anne OrderID=10970
FirstName=Anne OrderID=10978
FirstName=Anne OrderID=11016
FirstName=Anne OrderID=11017
FirstName=Anne OrderID=11022
FirstName=Anne OrderID=11058
