Northwind DB for InnoDB

from the Artful MySQL Tips List


/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `CategoryID` int NOT NULL AUTO_INCREMENT,
  `CategoryName` varchar(15) NOT NULL,
  `Description` text,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`CategoryID`),
  UNIQUE KEY `CategoryName` (`CategoryName`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `categories` VALUES (1,'Beverages','Soft drinks, coffees, teas, beers, and ales',NULL),(2,'Condiments','Sweet and savory sauces, relishes, spreads, and seasonings',NULL),(3,'Confections','Desserts, candies, and sweet breads',NULL),(4,'Dairy Products','Cheeses',NULL),(5,'Grains/Cereals','Breads, crackers, pasta, and cereal',NULL),(6,'Meat/Poultry','Prepared meats',NULL),(7,'Produce','Dried fruit and bean curd',NULL),(8,'Seafood','Seaweed and fish',NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
  `CustomerID` varchar(5) NOT NULL,
  `CompanyName` varchar(40) NOT NULL,
  `ContactName` varchar(30) DEFAULT NULL,
  `ContactTitle` varchar(30) DEFAULT NULL,
  `Address` varchar(60) DEFAULT NULL,
  `City` varchar(15) DEFAULT NULL,
  `Region` varchar(15) DEFAULT NULL,
  `PostalCode` varchar(10) DEFAULT NULL,
  `Country` varchar(15) DEFAULT NULL,
  `Phone` varchar(24) DEFAULT NULL,
  `Fax` varchar(24) DEFAULT NULL,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`CustomerID`),
  KEY `City` (`City`),
  KEY `CompanyName` (`CompanyName`),
  KEY `PostalCode` (`PostalCode`),
  KEY `Region` (`Region`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `customers` VALUES ('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin',NULL,'12209','Germany','030-0074321','030-0076545',NULL),('AROUT','Around the Horn','Thomas Hardy','Sales Representative','120 Hanover Sq.','London',NULL,'WA1 1DP','UK','(171) 555-7788','(171) 555-6750',NULL),('BLAUS','Blauer See Delikatessen','Hanna Moos','Sales Representative','Forsterstr. 57','Mannheim',NULL,'68306','Germany','0621-08460','0621-08924',NULL),('BONAP','Bon app','Laurence Lebihan','Owner','12, rue des Bouchers','Marseille',NULL,'13008','France','91.24.45.40','91.24.45.41',NULL),('BOTTM','Bottom-Dollar Markets','Elizabeth Lincoln','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada','(604) 555-4729','(604) 555-3745',NULL),('BSBEV','B\'s Beverages','Victoria Ashworth','Sales Representative','Fauntleroy Circus','London',NULL,'EC2 5NT','UK','(171) 555-1212',NULL,NULL),('CACTU','Cactus Comidas para llevar','Patricio Simpson','Sales Agent','Cerrito 333','Buenos Aires',NULL,'1010','Argentina','(1) 135-5555','(1) 135-4892',NULL),('CHOPS','Chop-suey Chinese','Yang Wang','Owner','Hauptstr. 29','Bern',NULL,'3012','Switzerland','0452-076545',NULL,NULL),('CONSH','Consolidated Holdings','Elizabeth Brown','Sales Representative','Berkeley Gardens\n12  Brewery ','London',NULL,'WX1 6LT','UK','(171) 555-2282','(171) 555-9199',NULL),('DRACD','Drachenblut Delikatessen','Sven Ottlieb','Order Administrator','Walserweg 21','Aachen',NULL,'52066','Germany','0241-039123','0241-059428',NULL),('DUMON','Du monde entier','Janine Labrune','Owner','67, rue des Cinquante Otages','Nantes',NULL,'44000','France','40.67.88.88','40.67.89.89',NULL),('EASTC','Eastern Connection','Ann Devon','Sales Agent','35 King George','London',NULL,'WX3 6FW','UK','(171) 555-0297','(171) 555-3373',NULL),('ERNSH','Ernst Handel','Roland Mendel','Sales Manager','Kirchgasse 6','Graz',NULL,'8010','Austria','7675-3425','7675-3426',NULL),('FISSA','FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','Accounting Manager','C/ Moralzarzal, 86','Madrid',NULL,'28034','Spain','(91) 555 94 44','(91) 555 55 93',NULL),('FRANR','France restauration','Carine Schmitt','Marketing Manager','54, rue Royale','Nantes',NULL,'44000','France','40.32.21.21','40.32.21.20',NULL),('FRANS','Franchi S.p.A.','Paolo Accorti','Sales Representative','Via Monte Bianco 34','Torino',NULL,'10100','Italy','011-4988260','011-4988261',NULL),('FURIB','Furia Bacalhau e Frutos do Mar','Lino Rodriguez ','Sales Manager','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal','(1) 354-2534','(1) 354-2535',NULL),('GREAL','Great Lakes Food Market','Howard Snyder','Marketing Manager','2732 Baker Blvd.','Eugene','OR','97403','USA','(503) 555-7555',NULL,NULL),('HUNGC','Hungry Coyote Import Store','Yoshi Latimer','Sales Representative','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA','(503) 555-6874','(503) 555-2376',NULL),('HUNGO','Hungry Owl All-Night Grocers','Patricia McKenna','Sales Associate','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland','2967 542','2967 3333',NULL),('ISLAT','Island Trading','Helen Bennett','Marketing Manager','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK','(198) 555-8888',NULL,NULL),('LACOR','La corne d\'abondance','Daniel Tonini','Sales Representative','67, avenue de l\'Europe','Versailles',NULL,'78000','France','30.59.84.10','30.59.85.11',NULL),('LAMAI','La maison d\'Asie','Annette Roulet','Sales Manager','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France','61.77.61.10','61.77.61.11',NULL),('LAUGB','Laughing Bacchus Wine Cellars','Yoshi Tannamuri','Marketing Assistant','1900 Oak St.','Vancouver','BC','V3F 2K1','Canada','(604) 555-3392','(604) 555-7293',NULL),('LAZYK','Lazy K Kountry Store','John Steel','Marketing Manager','12 Orchestra Terrace','Walla Walla','WA','99362','USA','(509) 555-7969','(509) 555-6221',NULL),('LEHMS','Lehmanns Marktstand','Renate Messner','Sales Representative','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany','069-0245984','069-0245874',NULL),('LETSS','Let\'s Stop N Shop','Jaime Yorres','Owner','87 Polk St.\nSuite 5','San Francisco','CA','94117','USA','(415) 555-5938',NULL,NULL),('LINOD','LINO-Delicateses','Felipe Izquierdo','Owner','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela','(8) 34-56-12','(8) 34-93-93',NULL),('LONEP','Lonesome Pine Restaurant','Fran Wilson','Sales Manager','89 Chiaroscuro Rd.','Portland','OR','97219','USA','(503) 555-9573','(503) 555-9646',NULL),('MAGAA','Magazzini Alimentari Riuniti','Giovanni Rovelli','Marketing Manager','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy','035-640230','035-640231',NULL),('MAISD','Maison Dewey','Catherine Dewey','Sales Agent','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium','(02) 201 24 67','(02) 201 24 68',NULL),('MORGK','Morgenstern Gesundkost','Alexander Feuer','Marketing Assistant','Heerstr. 22','Leipzig',NULL,'04179','Germany','0342-023176',NULL,NULL),('NORTS','North/South','Simon Crowther','Sales Associate','South House\n300 Queensbridge','London',NULL,'SW7 1RZ','UK','(171) 555-7733','(171) 555-2530',NULL),('OLDWO','Old World Delicatessen','Rene Phillips','Sales Representative','2743 Bering St.','Anchorage','AK','99508','USA','(907) 555-7584','(907) 555-2880',NULL),('PICCO','Piccolo und mehr','Georg Pipps','Sales Manager','Geislweg 14','Salzburg',NULL,'5020','Austria','6562-9722','6562-9723',NULL),('RATTC','Rattlesnake Canyon Grocery','Paula Wilson','Assistant Sales Representative','2817 Milton Dr.','Albuquerque','NM','87110','USA','(505) 555-5939','(505) 555-3620',NULL),('REGGC','Reggiani Caseifici','Maurizio Moroni','Sales Associate','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy','0522-556721','0522-556722',NULL),('RICAR','Ricardo Adocicados','Janete Limeira','Assistant Sales Agent','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil','(21) 555-3412',NULL,NULL),('SAVEA','Save-a-lot Markets','Jose Pavarotti','Sales Representative','187 Suffolk Ln.','Boise','ID','83720','USA','(208) 555-8097',NULL,NULL),('SEVES','Seven Seas Imports','Hari Kumar','Sales Manager','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK','(171) 555-1717','(171) 555-5646',NULL),('SPLIR','Split Rail Beer & Ale','Art Braunschweiger','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','(307) 555-4680','(307) 555-6525',NULL),('THEBI','The Big Cheese','Liz Nixon','Marketing Manager','89 Jefferson Way\nSuite 2','Portland','OR','97201','USA','(503) 555-3612',NULL,NULL),('THECR','The Cracker Box','Liu Wong','Marketing Assistant','55 Grizzly Peak Rd.','Butte','MT','59801','USA','(406) 555-5834','(406) 555-8083',NULL),('TRAIH','Trail\'s Head Gourmet Provisioners','Helvetius Nagy','Sales Associate','722 DaVinci Blvd.','Kirkland','WA','98034','USA','(206) 555-8257','(206) 555-2174',NULL),('VICTE','Victuailles en stock','Mary Saveley','Sales Agent','2, rue du Commerce','Lyon',NULL,'69004','France','78.32.54.86','78.32.54.87',NULL),('VINET','Vins et alcools Chevalier','Paul Henriot','Accounting Manager','59 rue de l\'Abbaye','Reims',NULL,'51100','France','26.47.15.10','26.47.15.11',NULL),('WARTH','Wartian Herkku','Pirkko Koskitalo','Accounting Manager','Torikatu 38','Oulu',NULL,'90110','Finland','981-443655','981-443655',NULL),('WELLI','Wellington Importadora','Paula Parente','Sales Manager','Rua do Mercado, 12','Resende','SP','08737-363','Brazil','(14) 555-8122',NULL,NULL),('WHITC','White Clover Markets','Karl Jablonski','Owner','305 - 14th Ave. S.\nSuite 3B','Seattle','WA','98128','USA','(206) 555-4112','(206) 555-4115',NULL),('WILMK','Wilman Kala','Matti Karttunen','Owner/Marketing Assistant','Keskuskatu 45','Helsinki',NULL,'21240','Finland','90-224 8858','90-224 8858',NULL),('WOLZA','Wolski  Zajazd','Zbyszek Piestrzeniewicz','Owner','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland','(26) 642-7012','(26) 642-7012',NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employees` (
  `EmployeeID` int NOT NULL AUTO_INCREMENT,
  `LastName` varchar(20) NOT NULL,
  `FirstName` varchar(10) NOT NULL,
  `Title` varchar(30) DEFAULT NULL,
  `TitleOfCourtesy` varchar(25) DEFAULT NULL,
  `BirthDate` datetime DEFAULT NULL,
  `HireDate` datetime DEFAULT NULL,
  `Address` varchar(60) DEFAULT NULL,
  `City` varchar(15) DEFAULT NULL,
  `Region` varchar(15) DEFAULT NULL,
  `PostalCode` varchar(10) DEFAULT NULL,
  `Country` varchar(15) DEFAULT NULL,
  `HomePhone` varchar(24) DEFAULT NULL,
  `Extension` varchar(4) DEFAULT NULL,
  `Photo` varchar(255) DEFAULT NULL,
  `Notes` text,
  `ReportsTo` int DEFAULT NULL,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`EmployeeID`),
  KEY `LastName` (`LastName`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `employees` VALUES (1,'Davolio','Nancy','Sales Representative','Ms.','1968-12-08 00:00:00','1992-05-01 00:00:00','507 - 20th Ave. E. Apt. 2A','Seattle','WA','98122','USA','(206) 555-9857','5467','EmpID1.bmp','Education includes a BA in psychology from Colorado State University.  She also completed \"The Art of the Cold Call.\"  Nancy is a member of Toastmasters International.',2,NULL),(2,'Fuller','Andrew','Vice President, Sales','Dr.','1952-02-19 00:00:00','1992-08-14 00:00:00','908 W. Capital Way','Tacoma','WA','98401','USA','(206) 555-9482','3457','EmpID2.bmp','Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas.  He is fluent in French and \nItalian and reads German.  He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.  \nAndrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.',0,NULL),(3,'Leverling','Janet','Sales Representative','Ms.','1963-08-30 00:00:00','1992-04-01 00:00:00','722 Moss Bay Blvd.','Kirkland','WA','98033','USA','(206) 555-3412','3355','EmpID3.bmp','Janet has a BS degree in chemistry from Boston College).  She has also completed a certificate program in food retailing management.  \nJanet was hired as a sales associate and was promoted to sales representative.',2,NULL),(4,'Peacock','Margaret','Sales Representative','Mrs.','1958-09-19 00:00:00','1993-05-03 00:00:00','4110 Old Redmond Rd.','Redmond','WA','98052','USA','(206) 555-8122','5176','EmpID4.bmp','Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle.',2,NULL),(5,'Buchanan','Steven','Sales Manager','Mr.','1955-03-04 00:00:00','1993-10-17 00:00:00','14 Garrett Hill','London',NULL,'SW1 8JR','UK','(71) 555-4848','3453','EmpID5.bmp','Steven Buchanan graduated from St. Andrews University, \nScotland, with a BSC degree.  Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager.  \nMr. Buchanan has completed the courses \"Successful Telemarketing\" and \"International Sales Management.\"  He is fluent in French.',2,NULL),(6,'Suyama','Michael','Sales Representative','Mr.','1963-07-02 00:00:00','1993-10-17 00:00:00','Coventry House\nMiner Rd.','London',NULL,'EC2 7JR','UK','(71) 555-7773','428','EmpID6.bmp','Michael is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing).  He has also taken the courses \n\"Multi-Cultural Selling\" and \"Time Management for the Sales Professional.\"  He is fluent in Japanese and can read and write French, Portuguese, and Spanish.',5,NULL),(7,'King','Robert','Sales Representative','Mr.','1960-05-29 00:00:00','1994-01-02 00:00:00','Edgeham Hollow\nWinchester Way','London',NULL,'RG1 9SP','UK','(71) 555-5598','465','EmpID7.bmp','Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan and then joining the company.  \nAfter completing a course entitled \"Selling in Europe,\" he was transferred to the London office.',5,NULL),(8,'Callahan','Laura','Inside Sales Coordinator','Ms.','1958-01-09 00:00:00','1994-03-05 00:00:00','4726 - 11th Ave. N.E.','Seattle','WA','98105','USA','(206) 555-1189','2344','EmpID8.bmp','Laura received a BA in psychology from the University of Washington.  She has also completed a course in business French.  She reads and writes French.',2,NULL),(9,'Dodsworth','Anne','Sales Representative','Ms.','1969-07-02 00:00:00','1994-11-15 00:00:00','7 Houndstooth Rd.','London',NULL,'WG2 7LT','UK','(71) 555-4444','452','EmpID9.bmp','Anne has a BA degree in English from St. Lawrence College.  She is fluent in French and German.',5,NULL);
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `nwib_by_continent` (
  `orderdate` tinyint NOT NULL,
  `quantity` tinyint NOT NULL,
  `continent` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orderdetails` (
  `OrderID` int NOT NULL,
  `ProductID` int NOT NULL,
  `UnitPrice` float NOT NULL DEFAULT '0',
  `Quantity` smallint NOT NULL DEFAULT '1',
  `Discount` float NOT NULL DEFAULT '0',
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`OrderID`,`ProductID`),
  KEY `ProductID` (`ProductID`),
  CONSTRAINT `orderdetails_ibfk_1` FOREIGN KEY (`OrderID`) REFERENCES `orders` (`OrderID`),
  CONSTRAINT `orderdetails_ibfk_2` FOREIGN KEY (`ProductID`) REFERENCES `products` (`ProductID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `orderdetails` VALUES (10248,11,14,12,0,NULL),(10248,42,9.8,10,0,NULL),(10248,72,34.8,5,0,NULL),(10249,14,18.6,9,0,NULL),(10249,51,42.4,40,0,NULL),(10250,41,7.7,10,0,NULL),(10250,51,42.4,35,0.15,NULL),(10250,65,16.8,15,0.15,NULL),(10251,22,16.8,6,0.05,NULL),(10251,57,15.6,15,0.05,NULL),(10251,65,16.8,20,0,NULL),(10252,20,64.8,40,0.05,NULL),(10252,33,2,25,0.05,NULL),(10252,60,27.2,40,0,NULL),(10253,31,10,20,0,NULL),(10253,39,14.4,42,0,NULL),(10253,49,16,40,0,NULL),(10254,24,3.6,15,0.15,NULL),(10254,55,19.2,21,0.15,NULL),(10254,74,8,21,0,NULL),(10255,2,15.2,20,0,NULL),(10255,16,13.9,35,0,NULL),(10255,36,15.2,25,0,NULL),(10255,59,44,30,0,NULL),(10256,53,26.2,15,0,NULL),(10256,77,10.4,12,0,NULL),(10257,27,35.1,25,0,NULL),(10257,39,14.4,6,0,NULL),(10257,77,10.4,15,0,NULL),(10258,2,15.2,50,0.2,NULL),(10258,5,17,65,0.2,NULL),(10258,32,25.6,6,0.2,NULL),(10259,21,8,10,0,NULL),(10259,37,20.8,1,0,NULL),(10260,41,7.7,16,0.25,NULL),(10260,57,15.6,50,0,NULL),(10260,62,39.4,15,0.25,NULL),(10260,70,12,21,0.25,NULL),(10261,21,8,20,0,NULL),(10261,35,14.4,20,0,NULL),(10262,5,17,12,0.2,NULL),(10262,7,24,15,0,NULL),(10262,56,30.4,2,0,NULL),(10263,16,13.9,60,0.25,NULL),(10263,24,3.6,28,0,NULL),(10263,30,20.7,60,0.25,NULL),(10263,74,8,36,0.25,NULL),(10264,2,15.2,35,0,NULL),(10264,41,7.7,25,0.15,NULL),(10265,17,31.2,30,0,NULL),(10265,70,12,20,0,NULL),(10266,12,30.4,12,0.05,NULL),(10267,40,14.7,50,0,NULL),(10267,59,44,70,0.15,NULL),(10267,76,14.4,15,0.15,NULL),(10268,29,99,10,0,NULL),(10268,72,27.8,4,0,NULL),(10269,33,2,60,0.05,NULL),(10269,72,27.8,20,0.05,NULL),(10270,36,15.2,30,0,NULL),(10270,43,36.8,25,0,NULL),(10271,33,2,24,0,NULL),(10272,20,64.8,6,0,NULL),(10272,31,10,40,0,NULL),(10272,72,27.8,24,0,NULL),(10273,10,24.8,24,0.05,NULL),(10273,31,10,15,0.05,NULL),(10273,33,2,20,0,NULL),(10273,40,14.7,60,0.05,NULL),(10273,76,14.4,33,0.05,NULL),(10274,71,17.2,20,0,NULL),(10274,72,27.8,7,0,NULL),(10275,24,3.6,12,0.05,NULL),(10275,59,44,6,0.05,NULL),(10276,10,24.8,15,0,NULL),(10276,13,4.8,10,0,NULL),(10277,28,36.4,20,0,NULL),(10277,62,39.4,12,0,NULL),(10278,44,15.5,16,0,NULL),(10278,59,44,15,0,NULL),(10278,63,35.1,8,0,NULL),(10278,73,12,25,0,NULL),(10279,17,31.2,15,0.25,NULL),(10280,24,3.6,12,0,NULL),(10280,55,19.2,20,0,NULL),(10280,75,6.2,30,0,NULL),(10281,19,7.3,1,0,NULL),(10281,24,3.6,6,0,NULL),(10281,35,14.4,4,0,NULL),(10282,30,20.7,6,0,NULL),(10282,57,15.6,2,0,NULL),(10283,15,12.4,20,0,NULL),(10283,19,7.3,18,0,NULL),(10283,60,27.2,35,0,NULL),(10283,72,27.8,3,0,NULL),(10284,27,35.1,15,0.25,NULL),(10284,44,15.5,21,0,NULL),(10284,60,27.2,20,0.25,NULL),(10284,67,11.2,5,0.25,NULL),(10285,1,14.4,45,0.2,NULL),(10285,40,14.7,40,0.2,NULL),(10285,53,26.2,36,0.2,NULL),(10286,35,14.4,100,0,NULL),(10286,62,39.4,40,0,NULL),(10287,16,13.9,40,0.15,NULL),(10287,34,11.2,20,0,NULL),(10287,46,9.6,15,0.15,NULL),(10288,54,5.9,10,0.1,NULL),(10288,68,10,3,0.1,NULL),(10289,3,8,30,0,NULL),(10289,64,26.6,9,0,NULL),(10290,5,17,20,0,NULL),(10290,29,99,15,0,NULL),(10290,49,16,15,0,NULL),(10290,77,10.4,10,0,NULL),(10291,13,4.8,20,0.1,NULL),(10291,44,15.5,24,0.1,NULL),(10291,51,42.4,2,0.1,NULL),(10292,20,64.8,20,0,NULL),(10293,18,50,12,0,NULL),(10293,24,3.6,10,0,NULL),(10293,63,35.1,5,0,NULL),(10293,75,6.2,6,0,NULL),(10294,1,14.4,18,0,NULL),(10294,17,31.2,15,0,NULL),(10294,43,36.8,15,0,NULL),(10294,60,27.2,21,0,NULL),(10294,75,6.2,6,0,NULL),(10295,56,30.4,4,0,NULL),(10296,11,16.8,12,0,NULL),(10296,16,13.9,30,0,NULL),(10296,69,28.8,15,0,NULL),(10297,39,14.4,60,0,NULL),(10297,72,27.8,20,0,NULL),(10298,2,15.2,40,0,NULL),(10298,36,15.2,40,0.25,NULL),(10298,59,44,30,0.25,NULL),(10298,62,39.4,15,0,NULL),(10299,19,7.3,15,0,NULL),(10299,70,12,20,0,NULL),(10300,66,13.6,30,0,NULL),(10300,68,10,20,0,NULL),(10301,40,14.7,10,0,NULL),(10301,56,30.4,20,0,NULL),(10302,17,31.2,40,0,NULL),(10302,28,36.4,28,0,NULL),(10302,43,36.8,12,0,NULL),(10303,40,14.7,40,0.1,NULL),(10303,65,16.8,30,0.1,NULL),(10303,68,10,15,0.1,NULL),(10304,49,16,30,0,NULL),(10304,59,44,10,0,NULL),(10304,71,17.2,2,0,NULL),(10305,18,50,25,0.1,NULL),(10305,29,99,25,0.1,NULL),(10305,39,14.4,30,0.1,NULL),(10306,30,20.7,10,0,NULL),(10306,53,26.2,10,0,NULL),(10306,54,5.9,5,0,NULL),(10307,62,39.4,10,0,NULL),(10307,68,10,3,0,NULL),(10308,69,28.8,1,0,NULL),(10308,70,12,5,0,NULL),(10309,4,17.6,20,0,NULL),(10309,6,20,30,0,NULL),(10309,42,11.2,2,0,NULL),(10309,43,36.8,20,0,NULL),(10309,71,17.2,3,0,NULL),(10310,16,13.9,10,0,NULL),(10310,62,39.4,5,0,NULL),(10311,42,11.2,6,0,NULL),(10311,69,28.8,7,0,NULL),(10312,28,36.4,4,0,NULL),(10312,43,36.8,24,0,NULL),(10312,53,26.2,20,0,NULL),(10312,75,6.2,10,0,NULL),(10313,36,15.2,12,0,NULL),(10314,32,25.6,40,0.1,NULL),(10314,58,10.6,30,0.1,NULL),(10314,62,39.4,25,0.1,NULL),(10315,34,11.2,14,0,NULL),(10315,70,12,30,0,NULL),(10316,41,7.7,10,0,NULL),(10316,62,39.4,70,0,NULL),(10317,1,14.4,20,0,NULL),(10318,41,7.7,20,0,NULL),(10318,76,14.4,6,0,NULL),(10319,17,31.2,8,0,NULL),(10319,28,36.4,14,0,NULL),(10319,76,14.4,30,0,NULL),(10320,71,17.2,30,0,NULL),(10321,35,14.4,10,0,NULL),(10322,52,5.6,20,0,NULL),(10323,15,12.4,5,0,NULL),(10323,25,11.2,4,0,NULL),(10323,39,14.4,4,0,NULL),(10324,16,13.9,21,0.15,NULL),(10324,35,14.4,70,0.15,NULL),(10324,46,9.6,30,0,NULL),(10324,59,44,40,0.15,NULL),(10324,63,35.1,80,0.15,NULL),(10325,6,20,6,0,NULL),(10325,13,4.8,12,0,NULL),(10325,14,18.6,9,0,NULL),(10325,31,10,4,0,NULL),(10325,72,27.8,40,0,NULL),(10326,4,17.6,24,0,NULL),(10326,57,15.6,16,0,NULL),(10326,75,6.2,50,0,NULL),(10327,2,15.2,25,0.2,NULL),(10327,11,16.8,50,0.2,NULL),(10327,30,20.7,35,0.2,NULL),(10327,58,10.6,30,0.2,NULL),(10328,59,44,9,0,NULL),(10328,65,16.8,40,0,NULL),(10328,68,10,10,0,NULL),(10329,19,7.3,10,0.05,NULL),(10329,30,20.7,8,0.05,NULL),(10329,38,210.8,20,0.05,NULL),(10329,56,30.4,12,0.05,NULL),(10330,26,24.9,50,0.15,NULL),(10330,72,27.8,25,0.15,NULL),(10331,54,5.9,15,0,NULL),(10332,18,50,40,0.2,NULL),(10332,42,11.2,10,0.2,NULL),(10332,47,7.6,16,0.2,NULL),(10333,14,18.6,10,0,NULL),(10333,21,8,10,0.1,NULL),(10333,71,17.2,40,0.1,NULL),(10334,52,5.6,8,0,NULL),(10334,68,10,10,0,NULL),(10335,2,15.2,7,0.2,NULL),(10335,31,10,25,0.2,NULL),(10335,32,25.6,6,0.2,NULL),(10335,51,42.4,48,0.2,NULL),(10336,4,17.6,18,0.1,NULL),(10337,23,7.2,40,0,NULL),(10337,26,24.9,24,0,NULL),(10337,36,15.2,20,0,NULL),(10337,37,20.8,28,0,NULL),(10337,72,27.8,25,0,NULL),(10338,17,31.2,20,0,NULL),(10338,30,20.7,15,0,NULL),(10339,4,17.6,10,0,NULL),(10339,17,31.2,70,0.05,NULL),(10339,62,39.4,28,0,NULL),(10340,18,50,20,0.05,NULL),(10340,41,7.7,12,0.05,NULL),(10340,43,36.8,40,0.05,NULL),(10341,33,2,8,0,NULL),(10341,59,44,9,0.15,NULL),(10342,2,15.2,24,0.2,NULL),(10342,31,10,56,0.2,NULL),(10342,36,15.2,40,0.2,NULL),(10342,55,19.2,40,0.2,NULL),(10343,64,26.6,50,0,NULL),(10343,68,10,4,0.05,NULL),(10343,76,14.4,15,0,NULL),(10344,4,17.6,35,0,NULL),(10344,8,32,70,0.25,NULL),(10345,8,32,70,0,NULL),(10345,19,7.3,80,0,NULL),(10345,42,11.2,9,0,NULL),(10346,17,31.2,36,0.1,NULL),(10346,56,30.4,20,0,NULL),(10347,25,11.2,10,0,NULL),(10347,39,14.4,50,0.15,NULL),(10347,40,14.7,4,0,NULL),(10347,75,6.2,6,0.15,NULL),(10348,1,14.4,15,0.15,NULL),(10348,23,7.2,25,0,NULL),(10349,54,5.9,24,0,NULL),(10350,50,13,15,0.1,NULL),(10350,69,28.8,18,0.1,NULL),(10351,38,210.8,20,0.05,NULL),(10351,41,7.7,13,0,NULL),(10351,44,15.5,77,0.05,NULL),(10351,65,16.8,10,0.05,NULL),(10352,24,3.6,10,0,NULL),(10352,54,5.9,20,0.15,NULL),(10353,11,16.8,12,0.2,NULL),(10353,38,210.8,50,0.2,NULL),(10354,1,14.4,12,0,NULL),(10354,29,99,4,0,NULL),(10355,24,3.6,25,0,NULL),(10355,57,15.6,25,0,NULL),(10356,31,10,30,0,NULL),(10356,55,19.2,12,0,NULL),(10356,69,28.8,20,0,NULL),(10357,10,24.8,30,0.2,NULL),(10357,26,24.9,16,0,NULL),(10357,60,27.2,8,0.2,NULL),(10358,24,3.6,10,0.05,NULL),(10358,34,11.2,10,0.05,NULL),(10358,36,15.2,20,0.05,NULL),(10359,16,13.9,56,0.05,NULL),(10359,31,10,70,0.05,NULL),(10359,60,27.2,80,0.05,NULL),(10360,28,36.4,30,0,NULL),(10360,29,99,35,0,NULL),(10360,38,210.8,10,0,NULL),(10360,49,16,35,0,NULL),(10360,54,5.9,28,0,NULL),(10361,39,14.4,54,0.1,NULL),(10361,60,27.2,55,0.1,NULL),(10362,25,11.2,50,0,NULL),(10362,51,42.4,20,0,NULL),(10362,54,5.9,24,0,NULL),(10363,31,10,20,0,NULL),(10363,75,6.2,12,0,NULL),(10363,76,14.4,12,0,NULL),(10364,69,28.8,30,0,NULL),(10364,71,17.2,5,0,NULL),(10365,11,16.8,24,0,NULL),(10366,65,16.8,5,0,NULL),(10366,77,10.4,5,0,NULL),(10367,34,11.2,36,0,NULL),(10367,54,5.9,18,0,NULL),(10367,65,16.8,15,0,NULL),(10367,77,10.4,7,0,NULL),(10368,21,8,5,0.1,NULL),(10368,28,36.4,13,0.1,NULL),(10368,57,15.6,25,0,NULL),(10368,64,26.6,35,0.1,NULL),(10369,29,99,20,0,NULL),(10369,56,30.4,18,0.25,NULL),(10370,1,14.4,15,0.15,NULL),(10370,64,26.6,30,0,NULL),(10370,74,8,20,0.15,NULL),(10371,36,15.2,6,0.2,NULL),(10372,20,64.8,12,0.25,NULL),(10372,38,210.8,40,0.25,NULL),(10372,60,27.2,70,0.25,NULL),(10372,72,27.8,42,0.25,NULL),(10373,58,10.6,80,0.2,NULL),(10373,71,17.2,50,0.2,NULL),(10374,31,10,30,0,NULL),(10374,58,10.6,15,0,NULL),(10375,14,18.6,15,0,NULL),(10375,54,5.9,10,0,NULL),(10376,31,10,42,0.05,NULL),(10377,28,36.4,20,0.15,NULL),(10377,39,14.4,20,0.15,NULL),(10378,71,17.2,6,0,NULL),(10379,41,7.7,8,0.1,NULL),(10379,63,35.1,16,0.1,NULL),(10379,65,16.8,20,0.1,NULL),(10380,30,20.7,18,0.1,NULL),(10380,53,26.2,20,0.1,NULL),(10380,60,27.2,6,0.1,NULL),(10380,70,12,30,0,NULL),(10381,74,8,14,0,NULL),(10382,5,17,32,0,NULL),(10382,18,50,9,0,NULL),(10382,29,99,14,0,NULL),(10382,33,2,60,0,NULL),(10382,74,8,50,0,NULL),(10383,13,4.8,20,0,NULL),(10383,50,13,15,0,NULL),(10383,56,30.4,20,0,NULL),(10384,20,64.8,28,0,NULL),(10384,60,27.2,15,0,NULL),(10385,7,24,10,0.2,NULL),(10385,60,27.2,20,0.2,NULL),(10385,68,10,8,0.2,NULL),(10386,24,3.6,15,0,NULL),(10386,34,11.2,10,0,NULL),(10387,24,3.6,15,0,NULL),(10387,28,36.4,6,0,NULL),(10387,59,44,12,0,NULL),(10387,71,17.2,15,0,NULL),(10388,45,7.6,15,0.2,NULL),(10388,52,5.6,20,0.2,NULL),(10388,53,26.2,40,0,NULL),(10389,10,24.8,16,0,NULL),(10389,55,19.2,15,0,NULL),(10389,62,39.4,20,0,NULL),(10389,70,12,30,0,NULL),(10390,31,10,60,0.1,NULL),(10390,35,14.4,40,0.1,NULL),(10390,46,9.6,45,0,NULL),(10390,72,27.8,24,0.1,NULL),(10391,13,4.8,18,0,NULL),(10392,69,28.8,50,0,NULL),(10393,2,15.2,25,0.25,NULL),(10393,14,18.6,42,0.25,NULL),(10393,25,11.2,7,0.25,NULL),(10393,26,24.9,70,0.25,NULL),(10393,31,10,32,0,NULL),(10394,13,4.8,10,0,NULL),(10394,62,39.4,10,0,NULL),(10395,46,9.6,28,0.1,NULL),(10395,53,26.2,70,0.1,NULL),(10395,69,28.8,8,0,NULL),(10396,23,7.2,40,0,NULL),(10396,71,17.2,60,0,NULL),(10396,72,27.8,21,0,NULL),(10397,21,8,10,0.15,NULL),(10397,51,42.4,18,0.15,NULL),(10398,35,14.4,30,0,NULL),(10398,55,19.2,120,0.1,NULL),(10399,68,10,60,0,NULL),(10399,71,17.2,30,0,NULL),(10399,76,14.4,35,0,NULL),(10399,77,10.4,14,0,NULL),(10400,29,99,21,0,NULL),(10400,35,14.4,35,0,NULL),(10400,49,16,30,0,NULL),(10401,30,20.7,18,0,NULL),(10401,56,30.4,70,0,NULL),(10401,65,16.8,20,0,NULL),(10401,71,17.2,60,0,NULL),(10402,23,7.2,60,0,NULL),(10402,63,35.1,65,0,NULL),(10403,16,13.9,21,0.15,NULL),(10403,48,10.2,70,0.15,NULL),(10404,26,24.9,30,0.05,NULL),(10404,42,11.2,40,0.05,NULL),(10404,49,16,30,0.05,NULL),(10405,3,8,50,0,NULL),(10406,1,14.4,10,0,NULL),(10406,21,8,30,0.1,NULL),(10406,28,36.4,42,0.1,NULL),(10406,36,15.2,5,0.1,NULL),(10406,40,14.7,2,0.1,NULL),(10407,11,16.8,30,0,NULL),(10407,69,28.8,15,0,NULL),(10407,71,17.2,15,0,NULL),(10408,37,20.8,10,0,NULL),(10408,54,5.9,6,0,NULL),(10408,62,39.4,35,0,NULL),(10409,14,18.6,12,0,NULL),(10409,21,8,12,0,NULL),(10410,33,2,49,0,NULL),(10410,59,44,16,0,NULL),(10411,41,7.7,25,0.2,NULL),(10411,44,15.5,40,0.2,NULL),(10411,59,44,9,0.2,NULL),(10412,14,18.6,20,0.1,NULL),(10413,1,14.4,24,0,NULL),(10413,62,39.4,40,0,NULL),(10413,76,14.4,14,0,NULL),(10414,19,7.3,18,0.05,NULL),(10414,33,2,50,0,NULL),(10415,17,31.2,2,0,NULL),(10415,33,2,20,0,NULL),(10416,19,7.3,20,0,NULL),(10416,53,26.2,10,0,NULL),(10416,57,15.6,20,0,NULL),(10417,38,210.8,50,0,NULL),(10417,46,9.6,2,0.25,NULL),(10417,68,10,36,0.25,NULL),(10417,77,10.4,35,0,NULL),(10418,2,15.2,60,0,NULL),(10418,47,7.6,55,0,NULL),(10418,61,22.8,16,0,NULL),(10418,74,8,15,0,NULL),(10419,60,27.2,60,0.05,NULL),(10419,69,28.8,20,0.05,NULL),(10420,9,77.6,20,0.1,NULL),(10420,13,4.8,2,0.1,NULL),(10420,70,12,8,0.1,NULL),(10420,73,12,20,0.1,NULL),(10421,19,7.3,4,0.15,NULL),(10421,26,24.9,30,0,NULL),(10421,53,26.2,15,0.15,NULL),(10421,77,10.4,10,0.15,NULL),(10422,26,24.9,2,0,NULL),(10423,31,10,14,0,NULL),(10423,59,44,20,0,NULL),(10424,35,14.4,60,0.2,NULL),(10424,38,210.8,49,0.2,NULL),(10424,68,10,30,0.2,NULL),(10425,55,19.2,10,0.25,NULL),(10425,76,14.4,20,0.25,NULL),(10426,56,30.4,5,0,NULL),(10426,64,26.6,7,0,NULL),(10427,14,18.6,35,0,NULL),(10428,46,9.6,20,0,NULL),(10429,50,13,40,0,NULL),(10429,63,35.1,35,0.25,NULL),(10430,17,31.2,45,0.2,NULL),(10430,21,8,50,0,NULL),(10430,56,30.4,30,0,NULL),(10430,59,44,70,0.2,NULL),(10431,17,31.2,50,0.25,NULL),(10431,40,14.7,50,0.25,NULL),(10431,47,7.6,30,0.25,NULL),(10432,26,24.9,10,0,NULL),(10432,54,5.9,40,0,NULL),(10433,56,30.4,28,0,NULL),(10434,11,16.8,6,0,NULL),(10434,76,14.4,18,0.15,NULL),(10435,2,15.2,10,0,NULL),(10435,22,16.8,12,0,NULL),(10435,72,27.8,10,0,NULL),(10436,46,9.6,5,0,NULL),(10436,56,30.4,40,0.1,NULL),(10436,64,26.6,30,0.1,NULL),(10436,75,6.2,24,0.1,NULL),(10437,53,26.2,15,0,NULL),(10438,19,7.3,15,0.2,NULL),(10438,34,11.2,20,0.2,NULL),(10438,57,15.6,15,0.2,NULL),(10439,12,30.4,15,0,NULL),(10439,16,13.9,16,0,NULL),(10439,64,26.6,6,0,NULL),(10439,74,8,30,0,NULL),(10440,2,15.2,45,0.15,NULL),(10440,16,13.9,49,0.15,NULL),(10440,29,99,24,0.15,NULL),(10440,61,22.8,90,0.15,NULL),(10441,27,35.1,50,0,NULL),(10442,11,16.8,30,0,NULL),(10442,54,5.9,80,0,NULL),(10442,66,13.6,60,0,NULL),(10443,11,16.8,6,0.2,NULL),(10443,28,36.4,12,0,NULL),(10444,17,31.2,10,0,NULL),(10444,26,24.9,15,0,NULL),(10444,35,14.4,8,0,NULL),(10444,41,7.7,30,0,NULL),(10445,39,14.4,6,0,NULL),(10445,54,5.9,15,0,NULL),(10446,19,7.3,12,0.1,NULL),(10446,24,3.6,20,0.1,NULL),(10446,31,10,3,0.1,NULL),(10446,52,5.6,15,0.1,NULL),(10447,19,7.3,40,0,NULL),(10447,65,16.8,35,0,NULL),(10447,71,17.2,2,0,NULL),(10448,26,24.9,6,0,NULL),(10448,40,14.7,20,0,NULL),(10449,10,24.8,14,0,NULL),(10449,52,5.6,20,0,NULL),(10449,62,39.4,35,0,NULL),(10450,10,24.8,20,0.2,NULL),(10450,54,5.9,6,0.2,NULL),(10451,55,19.2,120,0.1,NULL),(10451,64,26.6,35,0.1,NULL),(10451,65,16.8,28,0.1,NULL),(10451,77,10.4,55,0.1,NULL),(10452,28,36.4,15,0,NULL),(10452,44,15.5,100,0.05,NULL),(10453,48,10.2,15,0.1,NULL),(10453,70,12,25,0.1,NULL),(10454,16,13.9,20,0.2,NULL),(10454,33,2,20,0.2,NULL),(10454,46,9.6,10,0.2,NULL),(10455,39,14.4,20,0,NULL),(10455,53,26.2,50,0,NULL),(10455,61,22.8,25,0,NULL),(10455,71,17.2,30,0,NULL),(10456,21,8,40,0.15,NULL),(10456,49,16,21,0.15,NULL),(10457,59,44,36,0,NULL),(10458,26,24.9,30,0,NULL),(10458,28,36.4,30,0,NULL),(10458,43,36.8,20,0,NULL),(10458,56,30.4,15,0,NULL),(10458,71,17.2,50,0,NULL),(10459,7,24,16,0.05,NULL),(10459,46,9.6,20,0.05,NULL),(10459,72,27.8,40,0,NULL),(10460,68,10,21,0.25,NULL),(10460,75,6.2,4,0.25,NULL),(10461,21,8,40,0.25,NULL),(10461,30,20.7,28,0.25,NULL),(10461,55,19.2,60,0.25,NULL),(10462,13,4.8,1,0,NULL),(10462,23,7.2,21,0,NULL),(10463,19,7.3,21,0,NULL),(10463,42,11.2,50,0,NULL),(10464,4,17.6,16,0.2,NULL),(10464,43,36.8,3,0,NULL),(10464,56,30.4,30,0.2,NULL),(10464,60,27.2,20,0,NULL),(10465,24,3.6,25,0,NULL),(10465,29,99,18,0.1,NULL),(10465,40,14.7,20,0,NULL),(10465,45,7.6,30,0.1,NULL),(10465,50,13,25,0,NULL),(10466,11,16.8,10,0,NULL),(10466,46,9.6,5,0,NULL),(10467,24,3.6,28,0,NULL),(10467,25,11.2,12,0,NULL),(10468,30,20.7,8,0,NULL),(10468,43,36.8,15,0,NULL),(10469,2,15.2,40,0.15,NULL),(10469,16,13.9,35,0.15,NULL),(10469,44,15.5,2,0.15,NULL),(10470,18,50,30,0,NULL),(10470,23,7.2,15,0,NULL),(10470,64,26.6,8,0,NULL),(10471,7,24,30,0,NULL),(10471,56,30.4,20,0,NULL),(10472,24,3.6,80,0.05,NULL),(10472,51,42.4,18,0,NULL),(10473,33,2,12,0,NULL),(10473,71,17.2,12,0,NULL),(10474,14,18.6,12,0,NULL),(10474,28,36.4,18,0,NULL),(10474,40,14.7,21,0,NULL),(10474,75,6.2,10,0,NULL),(10475,31,10,35,0.15,NULL),(10475,66,13.6,60,0.15,NULL),(10475,76,14.4,42,0.15,NULL),(10476,55,19.2,2,0.05,NULL),(10476,70,12,12,0,NULL),(10477,1,14.4,15,0,NULL),(10477,21,8,21,0.25,NULL),(10477,39,14.4,20,0.25,NULL),(10478,10,24.8,20,0.05,NULL),(10479,38,210.8,30,0,NULL),(10479,53,26.2,28,0,NULL),(10479,59,44,60,0,NULL),(10479,64,26.6,30,0,NULL),(10480,47,7.6,30,0,NULL),(10480,59,44,12,0,NULL),(10481,49,16,24,0,NULL),(10481,60,27.2,40,0,NULL),(10482,40,14.7,10,0,NULL),(10483,34,11.2,35,0.05,NULL),(10483,77,10.4,30,0.05,NULL),(10484,21,8,14,0,NULL),(10484,40,14.7,10,0,NULL),(10484,51,42.4,3,0,NULL),(10485,2,15.2,20,0.1,NULL),(10485,3,8,20,0.1,NULL),(10485,55,19.2,30,0.1,NULL),(10485,70,12,60,0.1,NULL),(10486,11,16.8,5,0,NULL),(10486,51,42.4,25,0,NULL),(10486,74,8,16,0,NULL),(10487,19,7.3,5,0,NULL),(10487,26,24.9,30,0,NULL),(10487,54,5.9,24,0.25,NULL),(10488,59,44,30,0,NULL),(10488,73,12,20,0.2,NULL),(10489,11,16.8,15,0.25,NULL),(10489,16,13.9,18,0,NULL),(10490,59,44,60,0,NULL),(10490,68,10,30,0,NULL),(10490,75,6.2,36,0,NULL),(10491,44,15.5,15,0.15,NULL),(10491,77,10.4,7,0.15,NULL),(10492,25,11.2,60,0.05,NULL),(10492,42,11.2,20,0.05,NULL),(10493,65,16.8,15,0.1,NULL),(10493,66,13.6,10,0.1,NULL),(10493,69,28.8,10,0.1,NULL),(10494,56,30.4,30,0,NULL),(10495,23,7.2,10,0,NULL),(10495,41,7.7,20,0,NULL),(10495,77,10.4,5,0,NULL),(10496,31,10,20,0.05,NULL),(10497,56,30.4,14,0,NULL),(10497,72,27.8,25,0,NULL),(10497,77,10.4,25,0,NULL),(10498,24,4.5,14,0,NULL),(10498,40,18.4,5,0,NULL),(10498,42,14,30,0,NULL),(10499,28,45.6,20,0,NULL),(10499,49,20,25,0,NULL),(10500,15,15.5,12,0.05,NULL),(10500,28,45.6,8,0.05,NULL),(10501,54,7.45,20,0,NULL),(10502,45,9.5,21,0,NULL),(10502,53,32.8,6,0,NULL),(10502,67,14,30,0,NULL),(10503,14,23.25,70,0,NULL),(10503,65,21.05,20,0,NULL),(10504,2,19,12,0,NULL),(10504,21,10,12,0,NULL),(10504,53,32.8,10,0,NULL),(10504,61,28.5,25,0,NULL),(10505,62,49.3,3,0,NULL),(10506,25,14,18,0.1,NULL),(10506,70,15,14,0.1,NULL),(10507,43,46,15,0.15,NULL),(10507,48,12.75,15,0.15,NULL),(10508,13,6,10,0,NULL),(10508,39,18,10,0,NULL),(10509,28,45.6,3,0,NULL),(10510,29,123.79,36,0,NULL),(10510,75,7.75,36,0.1,NULL),(10511,4,22,50,0.15,NULL),(10511,7,30,50,0.15,NULL),(10511,8,40,10,0.15,NULL),(10512,24,4.5,10,0.15,NULL),(10512,46,12,9,0.15,NULL),(10512,47,9.5,6,0.15,NULL),(10512,60,34,12,0.15,NULL),(10513,21,10,40,0.2,NULL),(10513,32,32,50,0.2,NULL),(10513,61,28.5,15,0.2,NULL),(10514,20,81,39,0,NULL),(10514,28,45.6,35,0,NULL),(10514,56,38,70,0,NULL),(10514,65,21.05,39,0,NULL),(10514,75,7.75,50,0,NULL),(10515,9,97,16,0.15,NULL),(10515,16,17.45,50,0,NULL),(10515,27,43.9,120,0,NULL),(10515,33,2.5,16,0.15,NULL),(10515,60,34,84,0.15,NULL),(10516,18,62.5,25,0.1,NULL),(10516,41,9.65,80,0.1,NULL),(10516,42,14,20,0,NULL),(10517,52,7,6,0,NULL),(10517,59,55,4,0,NULL),(10517,70,15,6,0,NULL),(10518,24,4.5,5,0,NULL),(10518,38,263.5,15,0,NULL),(10518,44,19.45,9,0,NULL),(10519,10,31,16,0.05,NULL),(10519,56,38,40,0,NULL),(10519,60,34,10,0.05,NULL),(10520,24,4.5,8,0,NULL),(10520,53,32.8,5,0,NULL),(10521,35,18,3,0,NULL),(10521,41,9.65,10,0,NULL),(10521,68,12.5,6,0,NULL),(10522,1,18,40,0.2,NULL),(10522,8,40,24,0,NULL),(10522,30,25.89,20,0.2,NULL),(10522,40,18.4,25,0.2,NULL),(10523,17,39,25,0.1,NULL),(10523,20,81,15,0.1,NULL),(10523,37,26,18,0.1,NULL),(10523,41,9.65,6,0.1,NULL),(10524,10,31,2,0,NULL),(10524,30,25.89,10,0,NULL),(10524,43,46,60,0,NULL),(10524,54,7.45,15,0,NULL),(10525,36,19,30,0,NULL),(10525,40,18.4,15,0.1,NULL),(10526,1,18,8,0.15,NULL),(10526,13,6,10,0,NULL),(10526,56,38,30,0.15,NULL),(10527,4,22,50,0.1,NULL),(10527,36,19,30,0.1,NULL),(10528,11,21,3,0,NULL),(10528,33,2.5,8,0.2,NULL),(10528,72,34.8,9,0,NULL),(10529,55,24,14,0,NULL),(10529,68,12.5,20,0,NULL),(10529,69,36,10,0,NULL),(10530,17,39,40,0,NULL),(10530,43,46,25,0,NULL),(10530,61,28.5,20,0,NULL),(10530,76,18,50,0,NULL),(10531,59,55,2,0,NULL),(10532,30,25.89,15,0,NULL),(10532,66,17,24,0,NULL),(10533,4,22,50,0.05,NULL),(10533,72,34.8,24,0,NULL),(10533,73,15,24,0.05,NULL),(10534,30,25.89,10,0,NULL),(10534,40,18.4,10,0.2,NULL),(10534,54,7.45,10,0.2,NULL),(10535,11,21,50,0.1,NULL),(10535,40,18.4,10,0.1,NULL),(10535,57,19.5,5,0.1,NULL),(10535,59,55,15,0.1,NULL),(10536,12,38,15,0.25,NULL),(10536,31,12.5,20,0,NULL),(10536,33,2.5,30,0,NULL),(10536,60,34,35,0.25,NULL),(10537,31,12.5,30,0,NULL),(10537,51,53,6,0,NULL),(10537,58,13.25,20,0,NULL),(10537,72,34.8,21,0,NULL),(10537,73,15,9,0,NULL),(10538,70,15,7,0,NULL),(10538,72,34.8,1,0,NULL),(10539,13,6,8,0,NULL),(10539,21,10,15,0,NULL),(10539,33,2.5,15,0,NULL),(10539,49,20,6,0,NULL),(10540,3,10,60,0,NULL),(10540,26,31.23,40,0,NULL),(10540,38,263.5,30,0,NULL),(10540,68,12.5,35,0,NULL),(10541,24,4.5,35,0.1,NULL),(10541,38,263.5,4,0.1,NULL),(10541,65,21.05,36,0.1,NULL),(10541,71,21.5,9,0.1,NULL),(10542,11,21,15,0.05,NULL),(10542,54,7.45,24,0.05,NULL),(10543,12,38,30,0.15,NULL),(10543,23,9,70,0.15,NULL),(10544,28,45.6,7,0,NULL),(10544,67,14,7,0,NULL),(10545,11,21,10,0,NULL),(10546,7,30,10,0,NULL),(10546,35,18,30,0,NULL),(10546,62,49.3,40,0,NULL),(10547,32,32,24,0.15,NULL),(10547,36,19,60,0,NULL),(10548,34,14,10,0.25,NULL),(10548,41,9.65,14,0,NULL),(10549,31,12.5,55,0.15,NULL),(10549,45,9.5,100,0.15,NULL),(10549,51,53,48,0.15,NULL),(10550,17,39,8,0.1,NULL),(10550,19,9.2,10,0,NULL),(10550,21,10,6,0.1,NULL),(10550,61,28.5,10,0.1,NULL),(10551,16,17.45,40,0.15,NULL),(10551,35,18,20,0.15,NULL),(10551,44,19.45,40,0,NULL),(10552,69,36,18,0,NULL),(10552,75,7.75,30,0,NULL),(10553,11,21,15,0,NULL),(10553,16,17.45,14,0,NULL),(10553,22,21,24,0,NULL),(10553,31,12.5,30,0,NULL),(10553,35,18,6,0,NULL),(10554,16,17.45,30,0.05,NULL),(10554,23,9,20,0.05,NULL),(10554,62,49.3,20,0.05,NULL),(10554,77,13,10,0.05,NULL),(10555,14,23.25,30,0.2,NULL),(10555,19,9.2,35,0.2,NULL),(10555,24,4.5,18,0.2,NULL),(10555,51,53,20,0.2,NULL),(10555,56,38,40,0.2,NULL),(10556,72,34.8,24,0,NULL),(10557,64,33.25,30,0,NULL),(10557,75,7.75,20,0,NULL),(10558,47,9.5,25,0,NULL),(10558,51,53,20,0,NULL),(10558,52,7,30,0,NULL),(10558,53,32.8,18,0,NULL),(10558,73,15,3,0,NULL),(10559,41,9.65,12,0.05,NULL),(10559,55,24,18,0.05,NULL),(10560,30,25.89,20,0,NULL),(10560,62,49.3,15,0.25,NULL),(10561,44,19.45,10,0,NULL),(10561,51,53,50,0,NULL),(10562,33,2.5,20,0.1,NULL),(10562,62,49.3,10,0.1,NULL),(10563,36,19,25,0,NULL),(10563,52,7,70,0,NULL),(10564,17,39,16,0.05,NULL),(10564,31,12.5,6,0.05,NULL),(10564,55,24,25,0.05,NULL),(10565,24,4.5,25,0.1,NULL),(10565,64,33.25,18,0.1,NULL),(10566,11,21,35,0.15,NULL),(10566,18,62.5,18,0.15,NULL),(10566,76,18,10,0,NULL),(10567,31,12.5,60,0.2,NULL),(10567,51,53,3,0,NULL),(10567,59,55,40,0.2,NULL),(10568,10,31,5,0,NULL),(10569,31,12.5,35,0.2,NULL),(10569,76,18,30,0,NULL),(10570,11,21,15,0.05,NULL),(10570,56,38,60,0.05,NULL),(10571,14,23.25,11,0.15,NULL),(10571,42,14,28,0.15,NULL),(10572,16,17.45,12,0.1,NULL),(10572,32,32,10,0.1,NULL),(10572,40,18.4,50,0,NULL),(10572,75,7.75,15,0.1,NULL),(10573,17,39,18,0,NULL),(10573,34,14,40,0,NULL),(10573,53,32.8,25,0,NULL),(10574,33,2.5,14,0,NULL),(10574,40,18.4,2,0,NULL),(10574,62,49.3,10,0,NULL),(10574,64,33.25,6,0,NULL),(10575,59,55,12,0,NULL),(10575,63,43.9,6,0,NULL),(10575,72,34.8,30,0,NULL),(10575,76,18,10,0,NULL),(10576,1,18,10,0,NULL),(10576,31,12.5,20,0,NULL),(10576,44,19.45,21,0,NULL),(10577,39,18,10,0,NULL),(10577,75,7.75,20,0,NULL),(10577,77,13,18,0,NULL),(10578,35,18,20,0,NULL),(10578,57,19.5,6,0,NULL),(10579,15,15.5,10,0,NULL),(10579,75,7.75,21,0,NULL),(10580,14,23.25,15,0.05,NULL),(10580,41,9.65,9,0.05,NULL),(10580,65,21.05,30,0.05,NULL),(10581,75,7.75,50,0.2,NULL),(10582,57,19.5,4,0,NULL),(10582,76,18,14,0,NULL),(10583,29,123.79,10,0,NULL),(10583,60,34,24,0.15,NULL),(10583,69,36,10,0.15,NULL),(10584,31,12.5,50,0.05,NULL),(10585,47,9.5,15,0,NULL),(10586,52,7,4,0.15,NULL),(10587,26,31.23,6,0,NULL),(10587,35,18,20,0,NULL),(10587,77,13,20,0,NULL),(10588,18,62.5,40,0.2,NULL),(10588,42,14,100,0.2,NULL),(10589,35,18,4,0,NULL),(10590,1,18,20,0,NULL),(10590,77,13,60,0.05,NULL),(10591,3,10,14,0,NULL),(10591,7,30,10,0,NULL),(10591,54,7.45,50,0,NULL),(10592,15,15.5,25,0.05,NULL),(10592,26,31.23,5,0.05,NULL),(10593,20,81,21,0.2,NULL),(10593,69,36,20,0.2,NULL),(10593,76,18,4,0.2,NULL),(10594,52,7,24,0,NULL),(10594,58,13.25,30,0,NULL),(10595,35,18,30,0.25,NULL),(10595,61,28.5,120,0.25,NULL),(10595,69,36,65,0.25,NULL),(10596,56,38,5,0.2,NULL),(10596,63,43.9,24,0.2,NULL),(10596,75,7.75,30,0.2,NULL),(10597,24,4.5,35,0.2,NULL),(10597,57,19.5,20,0,NULL),(10597,65,21.05,12,0.2,NULL),(10598,27,43.9,50,0,NULL),(10598,71,21.5,9,0,NULL),(10599,62,49.3,10,0,NULL),(10600,54,7.45,4,0,NULL),(10600,73,15,30,0,NULL),(10601,13,6,60,0,NULL),(10601,59,55,35,0,NULL),(10602,77,13,5,0.25,NULL),(10603,22,21,48,0,NULL),(10603,49,20,25,0.05,NULL),(10604,48,12.75,6,0.1,NULL),(10604,76,18,10,0.1,NULL),(10605,16,17.45,30,0.05,NULL),(10605,59,55,20,0.05,NULL),(10605,60,34,70,0.05,NULL),(10605,71,21.5,15,0.05,NULL),(10606,4,22,20,0.2,NULL),(10606,55,24,20,0.2,NULL),(10606,62,49.3,10,0.2,NULL),(10607,7,30,45,0,NULL),(10607,17,39,100,0,NULL),(10607,33,2.5,14,0,NULL),(10607,40,18.4,42,0,NULL),(10607,72,34.8,12,0,NULL),(10608,56,38,28,0,NULL),(10609,1,18,3,0,NULL),(10609,10,31,10,0,NULL),(10609,21,10,6,0,NULL),(10610,36,19,21,0.25,NULL),(10611,1,18,6,0,NULL),(10611,2,19,10,0,NULL),(10611,60,34,15,0,NULL),(10612,10,31,70,0,NULL),(10612,36,19,55,0,NULL),(10612,49,20,18,0,NULL),(10612,60,34,40,0,NULL),(10612,76,18,80,0,NULL),(10613,13,6,8,0.1,NULL),(10613,75,7.75,40,0,NULL),(10614,11,21,14,0,NULL),(10614,21,10,8,0,NULL),(10614,39,18,5,0,NULL),(10615,55,24,5,0,NULL),(10616,38,263.5,15,0.05,NULL),(10616,56,38,14,0,NULL),(10616,70,15,15,0.05,NULL),(10616,71,21.5,15,0.05,NULL),(10617,59,55,30,0.15,NULL),(10618,6,25,70,0,NULL),(10618,56,38,20,0,NULL),(10618,68,12.5,15,0,NULL),(10619,21,10,42,0,NULL),(10619,22,21,40,0,NULL),(10620,24,4.5,5,0,NULL),(10620,52,7,5,0,NULL),(10621,19,9.2,5,0,NULL),(10621,23,9,10,0,NULL),(10621,70,15,20,0,NULL),(10621,71,21.5,15,0,NULL),(10622,2,19,20,0,NULL),(10622,68,12.5,18,0.2,NULL),(10623,14,23.25,21,0,NULL),(10623,19,9.2,15,0.1,NULL),(10623,21,10,25,0.1,NULL),(10623,24,4.5,3,0,NULL),(10623,35,18,30,0.1,NULL),(10624,28,45.6,10,0,NULL),(10624,29,123.79,6,0,NULL),(10624,44,19.45,10,0,NULL),(10625,14,23.25,3,0,NULL),(10625,42,14,5,0,NULL),(10625,60,34,10,0,NULL),(10626,53,32.8,12,0,NULL),(10626,60,34,20,0,NULL),(10626,71,21.5,20,0,NULL),(10627,62,49.3,15,0,NULL),(10627,73,15,35,0.15,NULL),(10628,1,18,25,0,NULL),(10629,29,123.79,20,0,NULL),(10629,64,33.25,9,0,NULL),(10630,55,24,12,0.05,NULL),(10630,76,18,35,0,NULL),(10631,75,7.75,8,0.1,NULL),(10632,2,19,30,0.05,NULL),(10632,33,2.5,20,0.05,NULL),(10633,12,38,36,0.15,NULL),(10633,13,6,13,0.15,NULL),(10633,26,31.23,35,0.15,NULL),(10633,62,49.3,80,0.15,NULL),(10634,7,30,35,0,NULL),(10634,18,62.5,50,0,NULL),(10634,51,53,15,0,NULL),(10634,75,7.75,2,0,NULL),(10635,4,22,10,0.1,NULL),(10635,5,21.35,15,0.1,NULL),(10635,22,21,40,0,NULL),(10636,4,22,25,0,NULL),(10636,58,13.25,6,0,NULL),(10637,11,21,10,0,NULL),(10637,50,16.25,25,0.05,NULL),(10637,56,38,60,0.05,NULL),(10638,45,9.5,20,0,NULL),(10638,65,21.05,21,0,NULL),(10638,72,34.8,60,0,NULL),(10639,18,62.5,8,0,NULL),(10640,69,36,20,0.25,NULL),(10640,70,15,15,0.25,NULL),(10641,2,19,50,0,NULL),(10641,40,18.4,60,0,NULL),(10642,21,10,30,0.2,NULL),(10642,61,28.5,20,0.2,NULL),(10643,28,45.6,15,0.25,NULL),(10643,39,18,21,0.25,NULL),(10643,46,12,2,0.25,NULL),(10644,18,62.5,4,0.1,NULL),(10644,43,46,20,0,NULL),(10644,46,12,21,0.1,NULL),(10645,18,62.5,20,0,NULL),(10645,36,19,15,0,NULL),(10646,1,18,15,0.25,NULL),(10646,10,31,18,0.25,NULL),(10646,71,21.5,30,0.25,NULL),(10646,77,13,35,0.25,NULL),(10647,19,9.2,30,0,NULL),(10647,39,18,20,0,NULL),(10648,22,21,15,0,NULL),(10648,24,4.5,15,0.15,NULL),(10649,28,45.6,20,0,NULL),(10649,72,34.8,15,0,NULL),(10650,30,25.89,30,0,NULL),(10650,53,32.8,25,0.05,NULL),(10650,54,7.45,30,0,NULL),(10651,19,9.2,12,0.25,NULL),(10651,22,21,20,0.25,NULL),(10652,30,25.89,2,0.25,NULL),(10652,42,14,20,0,NULL),(10653,16,17.45,30,0.1,NULL),(10653,60,34,20,0.1,NULL),(10654,4,22,12,0.1,NULL),(10654,39,18,20,0.1,NULL),(10654,54,7.45,6,0.1,NULL),(10655,41,9.65,20,0.2,NULL),(10656,14,23.25,3,0.1,NULL),(10656,44,19.45,28,0.1,NULL),(10656,47,9.5,6,0.1,NULL),(10657,15,15.5,50,0,NULL),(10657,41,9.65,24,0,NULL),(10657,46,12,45,0,NULL),(10657,47,9.5,10,0,NULL),(10657,56,38,45,0,NULL),(10657,60,34,30,0,NULL),(10658,21,10,60,0,NULL),(10658,40,18.4,70,0.05,NULL),(10658,60,34,55,0.05,NULL),(10658,77,13,70,0.05,NULL),(10659,31,12.5,20,0.05,NULL),(10659,40,18.4,24,0.05,NULL),(10659,70,15,40,0.05,NULL),(10660,20,81,21,0,NULL),(10661,39,18,3,0.2,NULL),(10661,58,13.25,49,0.2,NULL),(10662,68,12.5,10,0,NULL),(10663,40,18.4,30,0.05,NULL),(10663,42,14,30,0.05,NULL),(10663,51,53,20,0.05,NULL),(10664,10,31,24,0.15,NULL),(10664,56,38,12,0.15,NULL),(10664,65,21.05,15,0.15,NULL),(10665,51,53,20,0,NULL),(10665,59,55,1,0,NULL),(10665,76,18,10,0,NULL),(10666,29,123.79,36,0,NULL),(10666,65,21.05,10,0,NULL),(10667,69,36,45,0.2,NULL),(10667,71,21.5,14,0.2,NULL),(10668,31,12.5,8,0.1,NULL),(10668,55,24,4,0.1,NULL),(10668,64,33.25,15,0.1,NULL),(10669,36,19,30,0,NULL),(10670,23,9,32,0,NULL),(10670,46,12,60,0,NULL),(10670,67,14,25,0,NULL),(10670,73,15,50,0,NULL),(10670,75,7.75,25,0,NULL),(10671,16,17.45,10,0,NULL),(10671,62,49.3,10,0,NULL),(10671,65,21.05,12,0,NULL),(10672,38,263.5,15,0.1,NULL),(10672,71,21.5,12,0,NULL),(10673,16,17.45,3,0,NULL),(10673,42,14,6,0,NULL),(10673,43,46,6,0,NULL),(10674,23,9,5,0,NULL),(10675,14,23.25,30,0,NULL),(10675,53,32.8,10,0,NULL),(10675,58,13.25,30,0,NULL),(10676,10,31,2,0,NULL),(10676,19,9.2,7,0,NULL),(10676,44,19.45,21,0,NULL),(10677,26,31.23,30,0.15,NULL),(10677,33,2.5,8,0.15,NULL),(10678,12,38,100,0,NULL),(10678,33,2.5,30,0,NULL),(10678,41,9.65,120,0,NULL),(10678,54,7.45,30,0,NULL),(10679,59,55,12,0,NULL),(10680,16,17.45,50,0.25,NULL),(10680,31,12.5,20,0.25,NULL),(10680,42,14,40,0.25,NULL),(10681,19,9.2,30,0.1,NULL),(10681,21,10,12,0.1,NULL),(10681,64,33.25,28,0,NULL),(10682,33,2.5,30,0,NULL),(10682,66,17,4,0,NULL),(10682,75,7.75,30,0,NULL),(10683,52,7,9,0,NULL),(10684,40,18.4,20,0,NULL),(10684,47,9.5,40,0,NULL),(10684,60,34,30,0,NULL),(10685,10,31,20,0,NULL),(10685,41,9.65,4,0,NULL),(10685,47,9.5,15,0,NULL),(10686,17,39,30,0.2,NULL),(10686,26,31.23,15,0,NULL),(10687,9,97,50,0.25,NULL),(10687,29,123.79,10,0,NULL),(10687,36,19,6,0.25,NULL),(10688,10,31,18,0.1,NULL),(10688,28,45.6,60,0.1,NULL),(10688,34,14,14,0,NULL),(10689,1,18,35,0.25,NULL),(10690,56,38,20,0.25,NULL),(10690,77,13,30,0.25,NULL),(10691,1,18,30,0,NULL),(10691,29,123.79,40,0,NULL),(10691,43,46,40,0,NULL),(10691,44,19.45,24,0,NULL),(10691,62,49.3,48,0,NULL),(10692,63,43.9,20,0,NULL),(10693,9,97,6,0,NULL),(10693,54,7.45,60,0.15,NULL),(10693,69,36,30,0.15,NULL),(10693,73,15,15,0.15,NULL),(10694,7,30,90,0,NULL),(10694,59,55,25,0,NULL),(10694,70,15,50,0,NULL),(10695,8,40,10,0,NULL),(10695,12,38,4,0,NULL),(10695,24,4.5,20,0,NULL),(10696,17,39,20,0,NULL),(10696,46,12,18,0,NULL),(10697,19,9.2,7,0.25,NULL),(10697,35,18,9,0.25,NULL),(10697,58,13.25,30,0.25,NULL),(10697,70,15,30,0.25,NULL),(10698,11,21,15,0,NULL),(10698,17,39,8,0.05,NULL),(10698,29,123.79,12,0.05,NULL),(10698,65,21.05,65,0.05,NULL),(10698,70,15,8,0.05,NULL),(10699,47,9.5,12,0,NULL),(10700,1,18,5,0.2,NULL),(10700,34,14,12,0.2,NULL),(10700,68,12.5,40,0.2,NULL),(10700,71,21.5,60,0.2,NULL),(10701,59,55,42,0.15,NULL),(10701,71,21.5,20,0.15,NULL),(10701,76,18,35,0.15,NULL),(10702,3,10,6,0,NULL),(10702,76,18,15,0,NULL),(10703,2,19,5,0,NULL),(10703,59,55,35,0,NULL),(10703,73,15,35,0,NULL),(10704,4,22,6,0,NULL),(10704,24,4.5,35,0,NULL),(10704,48,12.75,24,0,NULL),(10705,31,12.5,20,0,NULL),(10705,32,32,4,0,NULL),(10706,16,17.45,20,0,NULL),(10706,43,46,24,0,NULL),(10706,59,55,8,0,NULL),(10707,55,24,21,0,NULL),(10707,57,19.5,40,0,NULL),(10707,70,15,28,0.15,NULL),(10708,5,21.35,4,0,NULL),(10708,36,19,5,0,NULL),(10709,8,40,40,0,NULL),(10709,51,53,28,0,NULL),(10709,60,34,10,0,NULL),(10710,19,9.2,5,0,NULL),(10710,47,9.5,5,0,NULL),(10711,19,9.2,12,0,NULL),(10711,41,9.65,42,0,NULL),(10711,53,32.8,120,0,NULL),(10712,53,32.8,3,0.05,NULL),(10712,56,38,30,0,NULL),(10713,10,31,18,0,NULL),(10713,26,31.23,30,0,NULL),(10713,45,9.5,110,0,NULL),(10713,46,12,24,0,NULL),(10714,2,19,30,0.25,NULL),(10714,17,39,27,0.25,NULL),(10714,47,9.5,50,0.25,NULL),(10714,56,38,18,0.25,NULL),(10714,58,13.25,12,0.25,NULL),(10715,10,31,21,0,NULL),(10715,71,21.5,30,0,NULL),(10716,21,10,5,0,NULL),(10716,51,53,7,0,NULL),(10716,61,28.5,10,0,NULL),(10717,21,10,32,0.05,NULL),(10717,54,7.45,15,0,NULL),(10717,69,36,25,0.05,NULL),(10718,12,38,36,0,NULL),(10718,16,17.45,20,0,NULL),(10718,36,19,40,0,NULL),(10718,62,49.3,20,0,NULL),(10719,18,62.5,12,0.25,NULL),(10719,30,25.89,3,0.25,NULL),(10719,54,7.45,40,0.25,NULL),(10720,35,18,21,0,NULL),(10720,71,21.5,8,0,NULL),(10721,44,19.45,50,0.05,NULL),(10722,2,19,3,0,NULL),(10722,31,12.5,50,0,NULL),(10722,68,12.5,45,0,NULL),(10722,75,7.75,42,0,NULL),(10723,26,31.23,15,0,NULL),(10724,10,31,16,0,NULL),(10724,61,28.5,5,0,NULL),(10725,41,9.65,12,0,NULL),(10725,52,7,4,0,NULL),(10725,55,24,6,0,NULL),(10726,4,22,25,0,NULL),(10726,11,21,5,0,NULL),(10727,17,39,20,0.05,NULL),(10727,56,38,10,0.05,NULL),(10727,59,55,10,0.05,NULL),(10728,30,25.89,15,0,NULL),(10728,40,18.4,6,0,NULL),(10728,55,24,12,0,NULL),(10728,60,34,15,0,NULL),(10729,1,18,50,0,NULL),(10729,21,10,30,0,NULL),(10729,50,16.25,40,0,NULL),(10730,16,17.45,15,0.05,NULL),(10730,31,12.5,3,0.05,NULL),(10730,65,21.05,10,0.05,NULL),(10731,21,10,40,0.05,NULL),(10731,51,53,30,0.05,NULL),(10732,76,18,20,0,NULL),(10733,14,23.25,16,0,NULL),(10733,28,45.6,20,0,NULL),(10733,52,7,25,0,NULL),(10734,6,25,30,0,NULL),(10734,30,25.89,15,0,NULL),(10734,76,18,20,0,NULL),(10735,61,28.5,20,0.1,NULL),(10735,77,13,2,0.1,NULL),(10736,65,21.05,40,0,NULL),(10736,75,7.75,20,0,NULL),(10737,13,6,4,0,NULL),(10737,41,9.65,12,0,NULL),(10738,16,17.45,3,0,NULL),(10739,36,19,6,0,NULL),(10739,52,7,18,0,NULL),(10740,28,45.6,5,0.2,NULL),(10740,35,18,35,0.2,NULL),(10740,45,9.5,40,0.2,NULL),(10740,56,38,14,0.2,NULL),(10741,2,19,15,0.2,NULL),(10742,3,10,20,0,NULL),(10742,60,34,50,0,NULL),(10742,72,34.8,35,0,NULL),(10743,46,12,28,0.05,NULL),(10744,40,18.4,50,0.2,NULL),(10745,18,62.5,24,0,NULL),(10745,44,19.45,16,0,NULL),(10745,59,55,45,0,NULL),(10745,72,34.8,7,0,NULL),(10746,13,6,6,0,NULL),(10746,42,14,28,0,NULL),(10746,62,49.3,9,0,NULL),(10746,69,36,40,0,NULL),(10747,31,12.5,8,0,NULL),(10747,41,9.65,35,0,NULL),(10747,63,43.9,9,0,NULL),(10747,69,36,30,0,NULL),(10748,23,9,44,0,NULL),(10748,40,18.4,40,0,NULL),(10748,56,38,28,0,NULL),(10749,56,38,15,0,NULL),(10749,59,55,6,0,NULL),(10749,76,18,10,0,NULL),(10750,14,23.25,5,0.15,NULL),(10750,45,9.5,40,0.15,NULL),(10750,59,55,25,0.15,NULL),(10751,26,31.23,12,0.1,NULL),(10751,30,25.89,30,0,NULL),(10751,50,16.25,20,0.1,NULL),(10751,73,15,15,0,NULL),(10752,1,18,8,0,NULL),(10752,69,36,3,0,NULL),(10753,45,9.5,4,0,NULL),(10753,74,10,5,0,NULL),(10754,40,18.4,3,0,NULL),(10755,47,9.5,30,0.25,NULL),(10755,56,38,30,0.25,NULL),(10755,57,19.5,14,0.25,NULL),(10755,69,36,25,0.25,NULL),(10756,18,62.5,21,0.2,NULL),(10756,36,19,20,0.2,NULL),(10756,68,12.5,6,0.2,NULL),(10756,69,36,20,0.2,NULL),(10757,34,14,30,0,NULL),(10757,59,55,7,0,NULL),(10757,62,49.3,30,0,NULL),(10757,64,33.25,24,0,NULL),(10758,26,31.23,20,0,NULL),(10758,52,7,60,0,NULL),(10758,70,15,40,0,NULL),(10759,32,32,10,0,NULL),(10760,25,14,12,0.25,NULL),(10760,27,43.9,40,0,NULL),(10760,43,46,30,0.25,NULL),(10761,25,14,35,0.25,NULL),(10761,75,7.75,18,0,NULL),(10762,39,18,16,0,NULL),(10762,47,9.5,30,0,NULL),(10762,51,53,28,0,NULL),(10762,56,38,60,0,NULL),(10763,21,10,40,0,NULL),(10763,22,21,6,0,NULL),(10763,24,4.5,20,0,NULL),(10764,3,10,20,0.1,NULL),(10764,39,18,130,0.1,NULL),(10765,65,21.05,80,0.1,NULL),(10766,2,19,40,0,NULL),(10766,7,30,35,0,NULL),(10766,68,12.5,40,0,NULL),(10767,42,14,2,0,NULL),(10768,22,21,4,0,NULL),(10768,31,12.5,50,0,NULL),(10768,60,34,15,0,NULL),(10768,71,21.5,12,0,NULL),(10769,41,9.65,30,0.05,NULL),(10769,52,7,15,0.05,NULL),(10769,61,28.5,20,0,NULL),(10769,62,49.3,15,0,NULL),(10770,11,21,15,0.25,NULL),(10771,71,21.5,16,0,NULL),(10772,29,123.79,18,0,NULL),(10772,59,55,25,0,NULL),(10773,17,39,33,0,NULL),(10773,31,12.5,70,0.2,NULL),(10773,75,7.75,7,0.2,NULL),(10774,31,12.5,2,0.25,NULL),(10774,66,17,50,0,NULL),(10775,10,31,6,0,NULL),(10775,67,14,3,0,NULL),(10776,31,12.5,16,0.05,NULL),(10776,42,14,12,0.05,NULL),(10776,45,9.5,27,0.05,NULL),(10776,51,53,120,0.05,NULL),(10777,42,14,20,0.2,NULL),(10778,41,9.65,10,0,NULL),(10779,16,17.45,20,0,NULL),(10779,62,49.3,20,0,NULL),(10780,70,15,35,0,NULL),(10780,77,13,15,0,NULL),(10781,54,7.45,3,0.2,NULL),(10781,56,38,20,0.2,NULL),(10781,74,10,35,0,NULL),(10782,31,12.5,1,0,NULL),(10783,31,12.5,10,0,NULL),(10783,38,263.5,5,0,NULL),(10784,36,19,30,0,NULL),(10784,39,18,2,0.15,NULL),(10784,72,34.8,30,0.15,NULL),(10785,10,31,10,0,NULL),(10785,75,7.75,10,0,NULL),(10786,8,40,30,0.2,NULL),(10786,30,25.89,15,0.2,NULL),(10786,75,7.75,42,0.2,NULL),(10787,2,19,15,0.05,NULL),(10787,29,123.79,20,0.05,NULL),(10788,19,9.2,50,0.05,NULL),(10788,75,7.75,40,0.05,NULL),(10789,18,62.5,30,0,NULL),(10789,35,18,15,0,NULL),(10789,63,43.9,30,0,NULL),(10789,68,12.5,18,0,NULL),(10790,7,30,3,0.15,NULL),(10790,56,38,20,0.15,NULL),(10791,29,123.79,14,0.05,NULL),(10791,41,9.65,20,0.05,NULL),(10792,2,19,10,0,NULL),(10792,54,7.45,3,0,NULL),(10792,68,12.5,15,0,NULL),(10793,41,9.65,14,0,NULL),(10793,52,7,8,0,NULL),(10794,14,23.25,15,0.2,NULL),(10794,54,7.45,6,0.2,NULL),(10795,16,17.45,65,0,NULL),(10795,17,39,35,0.25,NULL),(10796,26,31.23,21,0.2,NULL),(10796,44,19.45,10,0,NULL),(10796,64,33.25,35,0.2,NULL),(10796,69,36,24,0.2,NULL),(10797,11,21,20,0,NULL),(10798,62,49.3,2,0,NULL),(10798,72,34.8,10,0,NULL),(10799,13,6,20,0.15,NULL),(10799,24,4.5,20,0.15,NULL),(10799,59,55,25,0,NULL),(10800,11,21,50,0.1,NULL),(10800,51,53,10,0.1,NULL),(10800,54,7.45,7,0.1,NULL),(10801,17,39,40,0.25,NULL),(10801,29,123.79,20,0.25,NULL),(10802,30,25.89,25,0.25,NULL),(10802,51,53,30,0.25,NULL),(10802,55,24,60,0.25,NULL),(10802,62,49.3,5,0.25,NULL),(10803,19,9.2,24,0.05,NULL),(10803,25,14,15,0.05,NULL),(10803,59,55,15,0.05,NULL),(10804,10,31,36,0,NULL),(10804,28,45.6,24,0,NULL),(10804,49,20,4,0.15,NULL),(10805,34,14,10,0,NULL),(10805,38,263.5,10,0,NULL),(10806,2,19,20,0.25,NULL),(10806,65,21.05,2,0,NULL),(10806,74,10,15,0.25,NULL),(10807,40,18.4,1,0,NULL),(10808,56,38,20,0.15,NULL),(10808,76,18,50,0.15,NULL),(10809,52,7,20,0,NULL),(10810,13,6,7,0,NULL),(10810,25,14,5,0,NULL),(10810,70,15,5,0,NULL),(10811,19,9.2,15,0,NULL),(10811,23,9,18,0,NULL),(10811,40,18.4,30,0,NULL),(10812,31,12.5,16,0.1,NULL),(10812,72,34.8,40,0.1,NULL),(10812,77,13,20,0,NULL),(10813,2,19,12,0.2,NULL),(10813,46,12,35,0,NULL),(10814,41,9.65,20,0,NULL),(10814,43,46,20,0.15,NULL),(10814,48,12.75,8,0.15,NULL),(10814,61,28.5,30,0.15,NULL),(10815,33,2.5,16,0,NULL),(10816,38,263.5,30,0.05,NULL),(10816,62,49.3,20,0.05,NULL),(10817,26,31.23,40,0.15,NULL),(10817,38,263.5,30,0,NULL),(10817,40,18.4,60,0.15,NULL),(10817,62,49.3,25,0.15,NULL),(10818,32,32,20,0,NULL),(10818,41,9.65,20,0,NULL),(10819,43,46,7,0,NULL),(10819,75,7.75,20,0,NULL),(10820,56,38,30,0,NULL),(10821,35,18,20,0,NULL),(10821,51,53,6,0,NULL),(10822,62,49.3,3,0,NULL),(10822,70,15,6,0,NULL),(10823,11,21,20,0.1,NULL),(10823,57,19.5,15,0,NULL),(10823,59,55,40,0.1,NULL),(10823,77,13,15,0.1,NULL),(10824,41,9.65,12,0,NULL),(10824,70,15,9,0,NULL),(10825,26,31.23,12,0,NULL),(10825,53,32.8,20,0,NULL),(10826,31,12.5,35,0,NULL),(10826,57,19.5,15,0,NULL),(10827,10,31,15,0,NULL),(10827,39,18,21,0,NULL),(10828,20,81,5,0,NULL),(10828,38,263.5,2,0,NULL),(10829,2,19,10,0,NULL),(10829,8,40,20,0,NULL),(10829,13,6,10,0,NULL),(10829,60,34,21,0,NULL),(10830,6,25,6,0,NULL),(10830,39,18,28,0,NULL),(10830,60,34,30,0,NULL),(10830,68,12.5,24,0,NULL),(10831,19,9.2,2,0,NULL),(10831,35,18,8,0,NULL),(10831,38,263.5,8,0,NULL),(10831,43,46,9,0,NULL),(10832,13,6,3,0.2,NULL),(10832,25,14,10,0.2,NULL),(10832,44,19.45,16,0.2,NULL),(10832,64,33.25,3,0,NULL),(10833,7,30,20,0.1,NULL),(10833,31,12.5,9,0.1,NULL),(10833,53,32.8,9,0.1,NULL),(10834,29,123.79,8,0.05,NULL),(10834,30,25.89,20,0.05,NULL),(10835,59,55,15,0,NULL),(10835,77,13,2,0.2,NULL),(10836,22,21,52,0,NULL),(10836,35,18,6,0,NULL),(10836,57,19.5,24,0,NULL),(10836,60,34,60,0,NULL),(10836,64,33.25,30,0,NULL),(10837,13,6,6,0,NULL),(10837,40,18.4,25,0,NULL),(10837,47,9.5,40,0.25,NULL),(10837,76,18,21,0.25,NULL),(10838,1,18,4,0.25,NULL),(10838,18,62.5,25,0.25,NULL),(10838,36,19,50,0.25,NULL),(10839,58,13.25,30,0.1,NULL),(10839,72,34.8,15,0.1,NULL),(10840,25,14,6,0.2,NULL),(10840,39,18,10,0.2,NULL),(10841,10,31,16,0,NULL),(10841,56,38,30,0,NULL),(10841,59,55,50,0,NULL),(10841,77,13,15,0,NULL),(10842,11,21,15,0,NULL),(10842,43,46,5,0,NULL),(10842,68,12.5,20,0,NULL),(10842,70,15,12,0,NULL),(10843,51,53,4,0.25,NULL),(10844,22,21,35,0,NULL),(10845,23,9,70,0.1,NULL),(10845,35,18,25,0.1,NULL),(10845,42,14,42,0.1,NULL),(10845,58,13.25,60,0.1,NULL),(10845,64,33.25,48,0,NULL),(10846,4,22,21,0,NULL),(10846,70,15,30,0,NULL),(10846,74,10,20,0,NULL),(10847,1,18,80,0.2,NULL),(10847,19,9.2,12,0.2,NULL),(10847,37,26,60,0.2,NULL),(10847,45,9.5,36,0.2,NULL),(10847,60,34,45,0.2,NULL),(10847,71,21.5,55,0.2,NULL),(10848,5,21.35,30,0,NULL),(10848,9,97,3,0,NULL),(10849,3,10,49,0,NULL),(10849,26,31.23,18,0.15,NULL),(10850,25,14,20,0.15,NULL),(10850,33,2.5,4,0.15,NULL),(10850,70,15,30,0.15,NULL),(10851,2,19,5,0.05,NULL),(10851,25,14,10,0.05,NULL),(10851,57,19.5,10,0.05,NULL),(10851,59,55,42,0.05,NULL),(10852,2,19,15,0,NULL),(10852,17,39,6,0,NULL),(10852,62,49.3,50,0,NULL),(10853,18,62.5,10,0,NULL),(10854,10,31,100,0.15,NULL),(10854,13,6,65,0.15,NULL),(10855,16,17.45,50,0,NULL),(10855,31,12.5,14,0,NULL),(10855,56,38,24,0,NULL),(10855,65,21.05,15,0.15,NULL),(10856,2,19,20,0,NULL),(10856,42,14,20,0,NULL),(10857,3,10,30,0,NULL),(10857,26,31.23,35,0.25,NULL),(10857,29,123.79,10,0.25,NULL),(10858,7,30,5,0,NULL),(10858,27,43.9,10,0,NULL),(10858,70,15,4,0,NULL),(10859,24,4.5,40,0.25,NULL),(10859,54,7.45,35,0.25,NULL),(10859,64,33.25,30,0.25,NULL),(10860,51,53,3,0,NULL),(10860,76,18,20,0,NULL),(10861,17,39,42,0,NULL),(10861,18,62.5,20,0,NULL),(10861,21,10,40,0,NULL),(10861,33,2.5,35,0,NULL),(10861,62,49.3,3,0,NULL),(10862,11,21,25,0,NULL),(10862,52,7,8,0,NULL),(10863,1,18,20,0.15,NULL),(10863,58,13.25,12,0.15,NULL),(10864,35,18,4,0,NULL),(10864,67,14,15,0,NULL),(10865,38,263.5,60,0.05,NULL),(10865,39,18,80,0.05,NULL),(10866,2,19,21,0.25,NULL),(10866,24,4.5,6,0.25,NULL),(10866,30,25.89,40,0.25,NULL),(10867,53,32.8,3,0,NULL),(10868,26,31.23,20,0,NULL),(10868,35,18,30,0,NULL),(10868,49,20,42,0.1,NULL),(10869,1,18,40,0,NULL),(10869,11,21,10,0,NULL),(10869,23,9,50,0,NULL),(10869,68,12.5,20,0,NULL),(10870,35,18,3,0,NULL),(10870,51,53,2,0,NULL),(10871,6,25,50,0.05,NULL),(10871,16,17.45,12,0.05,NULL),(10871,17,39,16,0.05,NULL),(10872,55,24,10,0.05,NULL),(10872,62,49.3,20,0.05,NULL),(10872,64,33.25,15,0.05,NULL),(10872,65,21.05,21,0.05,NULL),(10873,21,10,20,0,NULL),(10873,28,45.6,3,0,NULL),(10874,10,31,10,0,NULL),(10875,19,9.2,25,0,NULL),(10875,47,9.5,21,0.1,NULL),(10875,49,20,15,0,NULL),(10876,46,12,21,0,NULL),(10876,64,33.25,20,0,NULL),(10877,16,17.45,30,0.25,NULL),(10877,18,62.5,25,0,NULL),(10878,20,81,20,0.05,NULL),(10879,40,18.4,12,0,NULL),(10879,65,21.05,10,0,NULL),(10879,76,18,10,0,NULL),(10880,23,9,30,0.2,NULL),(10880,61,28.5,30,0.2,NULL),(10880,70,15,50,0.2,NULL),(10881,73,15,10,0,NULL),(10882,42,14,25,0,NULL),(10882,49,20,20,0.15,NULL),(10882,54,7.45,32,0.15,NULL),(10883,24,4.5,8,0,NULL),(10884,21,10,40,0.05,NULL),(10884,56,38,21,0.05,NULL),(10884,65,21.05,12,0.05,NULL),(10885,2,19,20,0,NULL),(10885,24,4.5,12,0,NULL),(10885,70,15,30,0,NULL),(10885,77,13,25,0,NULL),(10886,10,31,70,0,NULL),(10886,31,12.5,35,0,NULL),(10886,77,13,40,0,NULL),(10887,25,14,5,0,NULL),(10888,2,19,20,0,NULL),(10888,68,12.5,18,0,NULL),(10889,11,21,40,0,NULL),(10889,38,263.5,40,0,NULL),(10890,17,39,15,0,NULL),(10890,34,14,10,0,NULL),(10890,41,9.65,14,0,NULL),(10891,30,25.89,15,0.05,NULL),(10892,59,55,40,0.05,NULL),(10893,8,40,30,0,NULL),(10893,24,4.5,10,0,NULL),(10893,29,123.79,24,0,NULL),(10893,30,25.89,35,0,NULL),(10893,36,19,20,0,NULL),(10894,13,6,28,0.05,NULL),(10894,69,36,50,0.05,NULL),(10894,75,7.75,120,0.05,NULL),(10895,24,4.5,110,0,NULL),(10895,39,18,45,0,NULL),(10895,40,18.4,91,0,NULL),(10895,60,34,100,0,NULL),(10896,45,9.5,15,0,NULL),(10896,56,38,16,0,NULL),(10897,29,123.79,80,0,NULL),(10897,30,25.89,36,0,NULL),(10898,13,6,5,0,NULL),(10899,39,18,8,0.15,NULL),(10900,70,15,3,0.25,NULL),(10901,41,9.65,30,0,NULL),(10901,71,21.5,30,0,NULL),(10902,55,24,30,0.15,NULL),(10902,62,49.3,6,0.15,NULL),(10903,13,6,40,0,NULL),(10903,65,21.05,21,0,NULL),(10903,68,12.5,20,0,NULL),(10904,58,13.25,15,0,NULL),(10904,62,49.3,35,0,NULL),(10905,1,18,20,0.05,NULL),(10906,61,28.5,15,0,NULL),(10907,75,7.75,14,0,NULL),(10908,7,30,20,0.05,NULL),(10908,52,7,14,0.05,NULL),(10909,7,30,12,0,NULL),(10909,16,17.45,15,0,NULL),(10909,41,9.65,5,0,NULL),(10910,19,9.2,12,0,NULL),(10910,49,20,10,0,NULL),(10910,61,28.5,5,0,NULL),(10911,1,18,10,0,NULL),(10911,17,39,12,0,NULL),(10911,67,14,15,0,NULL),(10912,11,21,40,0.25,NULL),(10912,29,123.79,60,0.25,NULL),(10913,4,22,30,0.25,NULL),(10913,33,2.5,40,0.25,NULL),(10913,58,13.25,15,0,NULL),(10914,71,21.5,25,0,NULL),(10915,17,39,10,0,NULL),(10915,33,2.5,30,0,NULL),(10915,54,7.45,10,0,NULL),(10916,16,17.45,6,0,NULL),(10916,32,32,6,0,NULL),(10916,57,19.5,20,0,NULL),(10917,30,25.89,1,0,NULL),(10917,60,34,10,0,NULL),(10918,1,18,60,0.25,NULL),(10918,60,34,25,0.25,NULL),(10919,16,17.45,24,0,NULL),(10919,25,14,24,0,NULL),(10919,40,18.4,20,0,NULL),(10920,50,16.25,24,0,NULL),(10921,35,18,10,0,NULL),(10921,63,43.9,40,0,NULL),(10922,17,39,15,0,NULL),(10922,24,4.5,35,0,NULL),(10923,42,14,10,0.2,NULL),(10923,43,46,10,0.2,NULL),(10923,67,14,24,0.2,NULL),(10924,10,31,20,0.1,NULL),(10924,28,45.6,30,0.1,NULL),(10924,75,7.75,6,0,NULL),(10925,36,19,25,0.15,NULL),(10925,52,7,12,0.15,NULL),(10926,11,21,2,0,NULL),(10926,13,6,10,0,NULL),(10926,19,9.2,7,0,NULL),(10926,72,34.8,10,0,NULL),(10927,20,81,5,0,NULL),(10927,52,7,5,0,NULL),(10927,76,18,20,0,NULL),(10928,47,9.5,5,0,NULL),(10928,76,18,5,0,NULL),(10929,21,10,60,0,NULL),(10929,75,7.75,49,0,NULL),(10929,77,13,15,0,NULL),(10930,21,10,36,0,NULL),(10930,27,43.9,25,0,NULL),(10930,55,24,25,0.2,NULL),(10930,58,13.25,30,0.2,NULL),(10931,13,6,42,0.15,NULL),(10931,57,19.5,30,0,NULL),(10932,16,17.45,30,0.1,NULL),(10932,62,49.3,14,0.1,NULL),(10932,72,34.8,16,0,NULL),(10932,75,7.75,20,0.1,NULL),(10933,53,32.8,2,0,NULL),(10933,61,28.5,30,0,NULL),(10934,6,25,20,0,NULL),(10935,1,18,21,0,NULL),(10935,18,62.5,4,0.25,NULL),(10935,23,9,8,0.25,NULL),(10936,36,19,30,0.2,NULL),(10937,28,45.6,8,0,NULL),(10937,34,14,20,0,NULL),(10938,13,6,20,0.25,NULL),(10938,43,46,24,0.25,NULL),(10938,60,34,49,0.25,NULL),(10938,71,21.5,35,0.25,NULL),(10939,2,19,10,0.15,NULL),(10939,67,14,40,0.15,NULL),(10940,7,30,8,0,NULL),(10940,13,6,20,0,NULL),(10941,31,12.5,44,0.25,NULL),(10941,62,49.3,30,0.25,NULL),(10941,68,12.5,80,0.25,NULL),(10941,72,34.8,50,0,NULL),(10942,49,20,28,0,NULL),(10943,13,6,15,0,NULL),(10943,22,21,21,0,NULL),(10943,46,12,15,0,NULL),(10944,11,21,5,0.25,NULL),(10944,44,19.45,18,0.25,NULL),(10944,56,38,18,0,NULL),(10945,13,6,20,0,NULL),(10945,31,12.5,10,0,NULL),(10946,10,31,25,0,NULL),(10946,24,4.5,25,0,NULL),(10946,77,13,40,0,NULL),(10947,59,55,4,0,NULL),(10948,50,16.25,9,0,NULL),(10948,51,53,40,0,NULL),(10948,55,24,4,0,NULL),(10949,6,25,12,0,NULL),(10949,10,31,30,0,NULL),(10949,17,39,6,0,NULL),(10949,62,49.3,60,0,NULL),(10950,4,22,5,0,NULL),(10951,33,2.5,15,0.05,NULL),(10951,41,9.65,6,0.05,NULL),(10951,75,7.75,50,0.05,NULL),(10952,6,25,16,0.05,NULL),(10952,28,45.6,2,0,NULL),(10953,20,81,50,0.05,NULL),(10953,31,12.5,50,0.05,NULL),(10954,16,17.45,28,0.15,NULL),(10954,31,12.5,25,0.15,NULL),(10954,45,9.5,30,0,NULL),(10954,60,34,24,0.15,NULL),(10955,75,7.75,12,0.2,NULL),(10956,21,10,12,0,NULL),(10956,47,9.5,14,0,NULL),(10956,51,53,8,0,NULL),(10957,30,25.89,30,0,NULL),(10957,35,18,40,0,NULL),(10957,64,33.25,8,0,NULL),(10958,5,21.35,20,0,NULL),(10958,7,30,6,0,NULL),(10958,72,34.8,5,0,NULL),(10959,75,7.75,20,0.15,NULL),(10960,24,4.5,10,0.25,NULL),(10960,41,9.65,24,0,NULL),(10961,52,7,6,0.05,NULL),(10961,76,18,60,0,NULL),(10962,7,30,45,0,NULL),(10962,13,6,77,0,NULL),(10962,53,32.8,20,0,NULL),(10962,69,36,9,0,NULL),(10962,76,18,44,0,NULL),(10963,60,34,2,0.15,NULL),(10964,18,62.5,6,0,NULL),(10964,38,263.5,5,0,NULL),(10964,69,36,10,0,NULL),(10965,51,53,16,0,NULL),(10966,37,26,8,0,NULL),(10966,56,38,12,0.15,NULL),(10966,62,49.3,12,0.15,NULL),(10967,19,9.2,12,0,NULL),(10967,49,20,40,0,NULL),(10968,12,38,30,0,NULL),(10968,24,4.5,30,0,NULL),(10968,64,33.25,4,0,NULL),(10969,46,12,9,0,NULL),(10970,52,7,40,0.2,NULL),(10971,29,123.79,14,0,NULL),(10972,17,39,6,0,NULL),(10972,33,2.5,7,0,NULL),(10973,26,31.23,5,0,NULL),(10973,41,9.65,6,0,NULL),(10973,75,7.75,10,0,NULL),(10974,63,43.9,10,0,NULL),(10975,8,40,16,0,NULL),(10975,75,7.75,10,0,NULL),(10976,28,45.6,20,0,NULL),(10977,39,18,30,0,NULL),(10977,47,9.5,30,0,NULL),(10977,51,53,10,0,NULL),(10977,63,43.9,20,0,NULL),(10978,8,40,20,0.15,NULL),(10978,21,10,40,0.15,NULL),(10978,40,18.4,10,0,NULL),(10978,44,19.45,6,0.15,NULL),(10979,7,30,18,0,NULL),(10979,12,38,20,0,NULL),(10979,24,4.5,80,0,NULL),(10979,27,43.9,30,0,NULL),(10979,31,12.5,24,0,NULL),(10979,63,43.9,35,0,NULL),(10980,75,7.75,40,0.2,NULL),(10981,38,263.5,60,0,NULL),(10982,7,30,20,0,NULL),(10982,43,46,9,0,NULL),(10983,13,6,84,0.15,NULL),(10983,57,19.5,15,0,NULL),(10984,16,17.45,55,0,NULL),(10984,24,4.5,20,0,NULL),(10984,36,19,40,0,NULL),(10985,16,17.45,36,0.1,NULL),(10985,18,62.5,8,0.1,NULL),(10985,32,32,35,0.1,NULL),(10986,11,21,30,0,NULL),(10986,20,81,15,0,NULL),(10986,76,18,10,0,NULL),(10986,77,13,15,0,NULL),(10987,7,30,60,0,NULL),(10987,43,46,6,0,NULL),(10987,72,34.8,20,0,NULL),(10988,7,30,60,0,NULL),(10988,62,49.3,40,0.1,NULL),(10989,6,25,40,0,NULL),(10989,11,21,15,0,NULL),(10989,41,9.65,4,0,NULL),(10990,21,10,65,0,NULL),(10990,34,14,60,0.15,NULL),(10990,55,24,65,0.15,NULL),(10990,61,28.5,66,0.15,NULL),(10991,2,19,50,0.2,NULL),(10991,70,15,20,0.2,NULL),(10991,76,18,90,0.2,NULL),(10992,72,34.8,2,0,NULL),(10993,29,123.79,50,0.25,NULL),(10993,41,9.65,35,0.25,NULL),(10994,59,55,18,0.05,NULL),(10995,51,53,20,0,NULL),(10995,60,34,4,0,NULL),(10996,42,14,40,0,NULL),(10997,32,32,50,0,NULL),(10997,46,12,20,0.25,NULL),(10997,52,7,20,0.25,NULL),(10998,24,4.5,12,0,NULL),(10998,61,28.5,7,0,NULL),(10998,74,10,20,0,NULL),(10998,75,7.75,30,0,NULL),(10999,41,9.65,20,0.05,NULL),(10999,51,53,15,0.05,NULL),(10999,77,13,21,0.05,NULL),(11000,4,22,25,0.25,NULL),(11000,24,4.5,30,0.25,NULL),(11000,77,13,30,0,NULL),(11001,7,30,60,0,NULL),(11001,22,21,25,0,NULL),(11001,46,12,25,0,NULL),(11001,55,24,6,0,NULL),(11002,13,6,56,0,NULL),(11002,35,18,15,0.15,NULL),(11002,42,14,24,0.15,NULL),(11002,55,24,40,0,NULL),(11003,1,18,4,0,NULL),(11003,40,18.4,10,0,NULL),(11003,52,7,10,0,NULL),(11004,26,31.23,6,0,NULL),(11004,76,18,6,0,NULL),(11005,1,18,2,0,NULL),(11005,59,55,10,0,NULL),(11006,1,18,8,0,NULL),(11006,29,123.79,2,0.25,NULL),(11007,8,40,30,0,NULL),(11007,29,123.79,10,0,NULL),(11007,42,14,14,0,NULL),(11008,28,45.6,70,0.05,NULL),(11008,34,14,90,0.05,NULL),(11008,71,21.5,21,0,NULL),(11009,24,4.5,12,0,NULL),(11009,36,19,18,0.25,NULL),(11009,60,34,9,0,NULL),(11010,7,30,20,0,NULL),(11010,24,4.5,10,0,NULL),(11011,58,13.25,40,0.05,NULL),(11011,71,21.5,20,0,NULL),(11012,19,9.2,50,0.05,NULL),(11012,60,34,36,0.05,NULL),(11012,71,21.5,60,0.05,NULL),(11013,23,9,10,0,NULL),(11013,42,14,4,0,NULL),(11013,45,9.5,20,0,NULL),(11013,68,12.5,2,0,NULL),(11014,41,9.65,28,0.1,NULL),(11015,30,25.89,15,0,NULL),(11015,77,13,18,0,NULL),(11016,31,12.5,15,0,NULL),(11016,36,19,16,0,NULL),(11017,3,10,25,0,NULL),(11017,59,55,110,0,NULL),(11017,70,15,30,0,NULL),(11018,12,38,20,0,NULL),(11018,18,62.5,10,0,NULL),(11018,56,38,5,0,NULL),(11019,46,12,3,0,NULL),(11019,49,20,2,0,NULL),(11020,10,31,24,0.15,NULL),(11021,2,19,11,0.25,NULL),(11021,20,81,15,0,NULL),(11021,26,31.23,63,0,NULL),(11021,51,53,44,0.25,NULL),(11021,72,34.8,35,0,NULL),(11022,19,9.2,35,0,NULL),(11022,69,36,30,0,NULL),(11023,7,30,4,0,NULL),(11023,43,46,30,0,NULL),(11024,26,31.23,12,0,NULL),(11024,33,2.5,30,0,NULL),(11024,65,21.05,21,0,NULL),(11024,71,21.5,50,0,NULL),(11025,1,18,10,0.1,NULL),(11025,13,6,20,0.1,NULL),(11026,18,62.5,8,0,NULL),(11026,51,53,10,0,NULL),(11027,24,4.5,30,0.25,NULL),(11027,62,49.3,21,0.25,NULL),(11028,55,24,35,0,NULL),(11028,59,55,24,0,NULL),(11029,56,38,20,0,NULL),(11029,63,43.9,12,0,NULL),(11030,2,19,100,0.25,NULL),(11030,5,21.35,70,0,NULL),(11030,29,123.79,60,0.25,NULL),(11030,59,55,100,0.25,NULL),(11031,1,18,45,0,NULL),(11031,13,6,80,0,NULL),(11031,24,4.5,21,0,NULL),(11031,64,33.25,20,0,NULL),(11031,71,21.5,16,0,NULL),(11032,36,19,35,0,NULL),(11032,38,263.5,25,0,NULL),(11032,59,55,30,0,NULL),(11033,53,32.8,70,0.1,NULL),(11033,69,36,36,0.1,NULL),(11034,21,10,15,0.1,NULL),(11034,44,19.45,12,0,NULL),(11034,61,28.5,6,0,NULL),(11035,1,18,10,0,NULL),(11035,35,18,60,0,NULL),(11035,42,14,30,0,NULL),(11035,54,7.45,10,0,NULL),(11036,13,6,7,0,NULL),(11036,59,55,30,0,NULL),(11037,70,15,4,0,NULL),(11038,40,18.4,5,0.2,NULL),(11038,52,7,2,0,NULL),(11038,71,21.5,30,0,NULL),(11039,28,45.6,20,0,NULL),(11039,35,18,24,0,NULL),(11039,49,20,60,0,NULL),(11039,57,19.5,28,0,NULL),(11040,21,10,20,0,NULL),(11041,2,19,30,0.2,NULL),(11041,63,43.9,30,0,NULL),(11042,44,19.45,15,0,NULL),(11042,61,28.5,4,0,NULL),(11043,11,21,10,0,NULL),(11044,62,49.3,12,0,NULL),(11045,33,2.5,15,0,NULL),(11045,51,53,24,0,NULL),(11046,12,38,20,0.05,NULL),(11046,32,32,15,0.05,NULL),(11046,35,18,18,0.05,NULL),(11047,1,18,25,0.25,NULL),(11047,5,21.35,30,0.25,NULL),(11048,68,12.5,42,0,NULL),(11049,2,19,10,0.2,NULL),(11049,12,38,4,0.2,NULL),(11050,76,18,50,0.1,NULL),(11051,24,4.5,10,0.2,NULL),(11052,43,46,30,0.2,NULL),(11052,61,28.5,10,0.2,NULL),(11053,18,62.5,35,0.2,NULL),(11053,32,32,20,0,NULL),(11053,64,33.25,25,0.2,NULL),(11054,33,2.5,10,0,NULL),(11054,67,14,20,0,NULL),(11055,24,4.5,15,0,NULL),(11055,25,14,15,0,NULL),(11055,51,53,20,0,NULL),(11055,57,19.5,20,0,NULL),(11056,7,30,40,0,NULL),(11056,55,24,35,0,NULL),(11056,60,34,50,0,NULL),(11057,70,15,3,0,NULL),(11058,21,10,3,0,NULL),(11058,60,34,21,0,NULL),(11058,61,28.5,4,0,NULL),(11059,13,6,30,0,NULL),(11059,17,39,12,0,NULL),(11059,60,34,35,0,NULL),(11060,60,34,4,0,NULL),(11060,77,13,10,0,NULL),(11061,60,34,15,0,NULL),(11062,53,32.8,10,0.2,NULL),(11062,70,15,12,0.2,NULL),(11063,34,14,30,0,NULL),(11063,40,18.4,40,0.1,NULL),(11063,41,9.65,30,0.1,NULL),(11064,17,39,77,0.1,NULL),(11064,41,9.65,12,0,NULL),(11064,53,32.8,25,0.1,NULL),(11064,55,24,4,0.1,NULL),(11064,68,12.5,55,0,NULL),(11065,30,25.89,4,0.25,NULL),(11065,54,7.45,20,0.25,NULL),(11066,16,17.45,3,0,NULL),(11066,19,9.2,42,0,NULL),(11066,34,14,35,0,NULL),(11067,41,9.65,9,0,NULL),(11068,28,45.6,8,0.15,NULL),(11068,43,46,36,0.15,NULL),(11068,77,13,28,0.15,NULL),(11069,39,18,20,0,NULL),(11070,1,18,40,0.15,NULL),(11070,2,19,20,0.15,NULL),(11070,16,17.45,30,0.15,NULL),(11070,31,12.5,20,0,NULL),(11071,7,30,15,0.05,NULL),(11071,13,6,10,0.05,NULL),(11072,2,19,8,0,NULL),(11072,41,9.65,40,0,NULL),(11072,50,16.25,22,0,NULL),(11072,64,33.25,130,0,NULL),(11073,11,21,10,0,NULL),(11073,24,4.5,20,0,NULL),(11074,16,17.45,14,0.05,NULL),(11075,2,19,10,0.15,NULL),(11075,46,12,30,0.15,NULL),(11075,76,18,2,0.15,NULL),(11076,6,25,20,0.25,NULL),(11076,14,23.25,20,0.25,NULL),(11076,19,9.2,10,0.25,NULL),(11077,2,19,24,0.2,NULL),(11077,3,10,4,0,NULL),(11077,4,22,1,0,NULL),(11077,6,25,1,0.02,NULL),(11077,7,30,1,0.05,NULL),(11077,8,40,2,0.1,NULL),(11077,10,31,1,0,NULL),(11077,12,38,2,0.05,NULL),(11077,13,6,4,0,NULL),(11077,14,23.25,1,0.03,NULL),(11077,16,17.45,2,0.03,NULL),(11077,20,81,1,0.04,NULL),(11077,23,9,2,0,NULL),(11077,32,32,1,0,NULL),(11077,39,18,2,0.05,NULL),(11077,41,9.65,3,0,NULL),(11077,46,12,3,0.02,NULL),(11077,52,7,2,0,NULL),(11077,55,24,2,0,NULL),(11077,60,34,2,0.06,NULL),(11077,64,33.25,2,0.03,NULL),(11077,66,17,1,0,NULL),(11077,73,15,2,0.01,NULL),(11077,75,7.75,4,0,NULL),(11077,77,13,2,0,NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `OrderID` int NOT NULL AUTO_INCREMENT,
  `CustomerID` varchar(5) DEFAULT NULL,
  `EmployeeID` int NOT NULL,
  `OrderDate` datetime DEFAULT NULL,
  `RequiredDate` datetime DEFAULT NULL,
  `ShippedDate` datetime DEFAULT NULL,
  `ShipVia` int NOT NULL,
  `Freight` float DEFAULT '0',
  `ShipName` varchar(40) DEFAULT NULL,
  `ShipAddress` varchar(60) DEFAULT NULL,
  `ShipCity` varchar(15) DEFAULT NULL,
  `ShipRegion` varchar(15) DEFAULT NULL,
  `ShipPostalCode` varchar(10) DEFAULT NULL,
  `ShipCountry` varchar(15) DEFAULT NULL,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`OrderID`),
  KEY `CustomerID` (`CustomerID`),
  KEY `EmployeeID` (`EmployeeID`),
  KEY `ShipVia` (`ShipVia`),
  KEY `OrderDate` (`OrderDate`),
  KEY `ShippedDate` (`ShippedDate`),
  KEY `ShipPostalCode` (`ShipPostalCode`),
  CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`CustomerID`) REFERENCES `customers` (`CustomerID`),
  CONSTRAINT `orders_ibfk_2` FOREIGN KEY (`EmployeeID`) REFERENCES `employees` (`EmployeeID`),
  CONSTRAINT `orders_ibfk_3` FOREIGN KEY (`ShipVia`) REFERENCES `shippers` (`ShipperID`)
) ENGINE=InnoDB AUTO_INCREMENT=11078 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `orders` VALUES (10248,'WILMK',5,'1996-07-04 00:00:00','1996-08-01 00:00:00','1996-07-16 00:00:00',3,32.38,'Vins et alcools Chevalier','59 rue de l\'Abbaye','Reims',NULL,'51100','France',NULL),(10251,'VICTE',3,'1996-07-08 00:00:00','1996-08-05 00:00:00','1996-07-15 00:00:00',1,41.34,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10254,'CHOPS',5,'1996-07-11 00:00:00','1996-08-08 00:00:00','1996-07-23 00:00:00',2,22.98,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10256,'WELLI',3,'1996-07-15 00:00:00','1996-08-12 00:00:00','1996-07-17 00:00:00',2,13.97,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10258,'ERNSH',1,'1996-07-17 00:00:00','1996-08-14 00:00:00','1996-07-23 00:00:00',1,140.51,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10262,'RATTC',8,'1996-07-22 00:00:00','1996-08-19 00:00:00','1996-07-25 00:00:00',3,48.29,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10263,'ERNSH',9,'1996-07-23 00:00:00','1996-08-20 00:00:00','1996-07-31 00:00:00',3,146.06,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10266,'WARTH',3,'1996-07-26 00:00:00','1996-09-06 00:00:00','1996-07-31 00:00:00',3,25.73,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10269,'WHITC',5,'1996-07-31 00:00:00','1996-08-14 00:00:00','1996-08-09 00:00:00',1,4.56,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10270,'WARTH',1,'1996-08-01 00:00:00','1996-08-29 00:00:00','1996-08-02 00:00:00',1,136.54,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10271,'SPLIR',6,'1996-08-01 00:00:00','1996-08-29 00:00:00','1996-08-30 00:00:00',2,4.54,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10272,'RATTC',6,'1996-08-02 00:00:00','1996-08-30 00:00:00','1996-08-06 00:00:00',2,98.03,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10274,'VINET',6,'1996-08-06 00:00:00','1996-09-03 00:00:00','1996-08-16 00:00:00',1,6.01,'Vins et alcools Chevalier','59 rue de l\'Abbaye','Reims',NULL,'51100','France',NULL),(10275,'MAGAA',1,'1996-08-07 00:00:00','1996-09-04 00:00:00','1996-08-09 00:00:00',1,26.93,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10277,'MORGK',2,'1996-08-09 00:00:00','1996-09-06 00:00:00','1996-08-13 00:00:00',3,125.77,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',NULL,'04179','Germany',NULL),(10279,'LEHMS',8,'1996-08-13 00:00:00','1996-09-10 00:00:00','1996-08-16 00:00:00',2,25.83,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10284,'LEHMS',4,'1996-08-19 00:00:00','1996-09-16 00:00:00','1996-08-27 00:00:00',1,76.56,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10287,'RICAR',8,'1996-08-22 00:00:00','1996-09-19 00:00:00','1996-08-28 00:00:00',3,12.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10288,'REGGC',4,'1996-08-23 00:00:00','1996-09-20 00:00:00','1996-09-03 00:00:00',1,7.45,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10289,'BSBEV',7,'1996-08-26 00:00:00','1996-09-23 00:00:00','1996-08-28 00:00:00',3,22.77,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10294,'RATTC',4,'1996-08-30 00:00:00','1996-09-27 00:00:00','1996-09-05 00:00:00',2,147.26,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10295,'VINET',2,'1996-09-02 00:00:00','1996-09-30 00:00:00','1996-09-10 00:00:00',2,1.15,'Vins et alcools Chevalier','59 rue de l\'Abbaye','Reims',NULL,'51100','France',NULL),(10298,'HUNGO',6,'1996-09-05 00:00:00','1996-10-03 00:00:00','1996-09-11 00:00:00',2,168.22,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10299,'RICAR',4,'1996-09-06 00:00:00','1996-10-04 00:00:00','1996-09-13 00:00:00',2,29.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10300,'MAGAA',2,'1996-09-09 00:00:00','1996-10-07 00:00:00','1996-09-18 00:00:00',2,17.68,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10301,'WANDK',8,'1996-09-09 00:00:00','1996-10-07 00:00:00','1996-09-17 00:00:00',2,45.08,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10305,'OLDWO',8,'1996-09-13 00:00:00','1996-10-11 00:00:00','1996-10-09 00:00:00',3,257.62,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10307,'LONEP',2,'1996-09-17 00:00:00','1996-10-15 00:00:00','1996-09-25 00:00:00',2,0.56,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10309,'HUNGO',3,'1996-09-19 00:00:00','1996-10-17 00:00:00','1996-10-23 00:00:00',1,47.3,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10310,'THEBI',8,'1996-09-20 00:00:00','1996-10-18 00:00:00','1996-09-27 00:00:00',2,17.52,'The Big Cheese','89 Jefferson Way\nSuite 2','Portland','OR','97201','USA',NULL),(10311,'DUMON',1,'1996-09-20 00:00:00','1996-10-04 00:00:00','1996-09-26 00:00:00',3,24.69,'Du monde entier','67, rue des Cinquante Otages','Nantes',NULL,'44000','France',NULL),(10312,'WANDK',2,'1996-09-23 00:00:00','1996-10-21 00:00:00','1996-10-03 00:00:00',2,40.26,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10314,'RATTC',1,'1996-09-25 00:00:00','1996-10-23 00:00:00','1996-10-04 00:00:00',2,74.16,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10315,'ISLAT',4,'1996-09-26 00:00:00','1996-10-24 00:00:00','1996-10-03 00:00:00',2,41.76,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10316,'RATTC',1,'1996-09-27 00:00:00','1996-10-25 00:00:00','1996-10-08 00:00:00',3,150.15,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10317,'LONEP',6,'1996-09-30 00:00:00','1996-10-28 00:00:00','1996-10-10 00:00:00',1,12.69,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10318,'ISLAT',8,'1996-10-01 00:00:00','1996-10-29 00:00:00','1996-10-04 00:00:00',2,4.73,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10320,'WARTH',5,'1996-10-03 00:00:00','1996-10-17 00:00:00','1996-10-18 00:00:00',3,34.57,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10321,'ISLAT',3,'1996-10-03 00:00:00','1996-10-31 00:00:00','1996-10-11 00:00:00',2,3.43,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10324,'SAVEA',9,'1996-10-08 00:00:00','1996-11-05 00:00:00','1996-10-10 00:00:00',1,214.27,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10328,'FURIB',4,'1996-10-14 00:00:00','1996-11-11 00:00:00','1996-10-17 00:00:00',3,87.03,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10329,'SPLIR',4,'1996-10-15 00:00:00','1996-11-26 00:00:00','1996-10-23 00:00:00',2,191.67,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10331,'BONAP',9,'1996-10-16 00:00:00','1996-11-27 00:00:00','1996-10-21 00:00:00',1,10.19,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10333,'WARTH',5,'1996-10-18 00:00:00','1996-11-15 00:00:00','1996-10-25 00:00:00',3,0.59,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10334,'VICTE',8,'1996-10-21 00:00:00','1996-11-18 00:00:00','1996-10-28 00:00:00',2,8.56,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10335,'HUNGO',7,'1996-10-22 00:00:00','1996-11-19 00:00:00','1996-10-24 00:00:00',2,42.11,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10338,'OLDWO',4,'1996-10-25 00:00:00','1996-11-22 00:00:00','1996-10-29 00:00:00',3,84.21,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10340,'BONAP',1,'1996-10-29 00:00:00','1996-11-26 00:00:00','1996-11-08 00:00:00',3,166.31,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10343,'LEHMS',4,'1996-10-31 00:00:00','1996-11-28 00:00:00','1996-11-06 00:00:00',1,110.37,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10344,'WHITC',4,'1996-11-01 00:00:00','1996-11-29 00:00:00','1996-11-05 00:00:00',2,23.29,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10346,'RATTC',3,'1996-11-05 00:00:00','1996-12-17 00:00:00','1996-11-08 00:00:00',3,142.08,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10348,'WANDK',4,'1996-11-07 00:00:00','1996-12-05 00:00:00','1996-11-15 00:00:00',2,0.78,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10349,'SPLIR',7,'1996-11-08 00:00:00','1996-12-06 00:00:00','1996-11-15 00:00:00',1,8.63,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10350,'LAMAI',6,'1996-11-11 00:00:00','1996-12-09 00:00:00','1996-12-03 00:00:00',2,64.19,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10351,'ERNSH',1,'1996-11-11 00:00:00','1996-12-09 00:00:00','1996-11-20 00:00:00',1,162.33,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10352,'FURIB',3,'1996-11-12 00:00:00','1996-11-26 00:00:00','1996-11-18 00:00:00',3,1.3,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10353,'PICCO',7,'1996-11-13 00:00:00','1996-12-11 00:00:00','1996-11-25 00:00:00',3,360.63,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10355,'AROUT',6,'1996-11-15 00:00:00','1996-12-13 00:00:00','1996-11-20 00:00:00',1,41.95,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10356,'WANDK',6,'1996-11-18 00:00:00','1996-12-16 00:00:00','1996-11-27 00:00:00',2,36.71,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10358,'LAMAI',5,'1996-11-20 00:00:00','1996-12-18 00:00:00','1996-11-27 00:00:00',1,19.64,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10359,'SEVES',5,'1996-11-21 00:00:00','1996-12-19 00:00:00','1996-11-26 00:00:00',3,288.43,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10362,'BONAP',3,'1996-11-25 00:00:00','1996-12-23 00:00:00','1996-11-28 00:00:00',1,96.04,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10363,'DRACD',4,'1996-11-26 00:00:00','1996-12-24 00:00:00','1996-12-04 00:00:00',3,30.54,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(10364,'EASTC',1,'1996-11-26 00:00:00','1997-01-07 00:00:00','1996-12-04 00:00:00',1,71.97,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(10368,'ERNSH',2,'1996-11-29 00:00:00','1996-12-27 00:00:00','1996-12-02 00:00:00',2,101.95,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10369,'SPLIR',8,'1996-12-02 00:00:00','1996-12-30 00:00:00','1996-12-09 00:00:00',2,195.68,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10370,'CHOPS',6,'1996-12-03 00:00:00','1996-12-31 00:00:00','1996-12-27 00:00:00',2,1.17,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10371,'LAMAI',1,'1996-12-03 00:00:00','1996-12-31 00:00:00','1996-12-24 00:00:00',1,0.45,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10373,'HUNGO',4,'1996-12-05 00:00:00','1997-01-02 00:00:00','1996-12-11 00:00:00',3,124.12,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10374,'WOLZA',1,'1996-12-05 00:00:00','1997-01-02 00:00:00','1996-12-09 00:00:00',3,3.94,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(10375,'HUNGC',3,'1996-12-06 00:00:00','1997-01-03 00:00:00','1996-12-09 00:00:00',2,20.12,'Hungry Coyote Import Store','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA',NULL),(10377,'SEVES',1,'1996-12-09 00:00:00','1997-01-06 00:00:00','1996-12-13 00:00:00',3,22.21,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10380,'HUNGO',8,'1996-12-12 00:00:00','1997-01-09 00:00:00','1997-01-16 00:00:00',3,35.03,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10382,'ERNSH',4,'1996-12-13 00:00:00','1997-01-10 00:00:00','1996-12-16 00:00:00',1,94.77,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10383,'AROUT',8,'1996-12-16 00:00:00','1997-01-13 00:00:00','1996-12-18 00:00:00',3,34.24,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10385,'SPLIR',1,'1996-12-17 00:00:00','1997-01-14 00:00:00','1996-12-23 00:00:00',2,30.96,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10388,'SEVES',2,'1996-12-19 00:00:00','1997-01-16 00:00:00','1996-12-20 00:00:00',1,34.86,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10389,'BOTTM',4,'1996-12-20 00:00:00','1997-01-17 00:00:00','1996-12-24 00:00:00',2,47.42,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10390,'ERNSH',6,'1996-12-23 00:00:00','1997-01-20 00:00:00','1996-12-26 00:00:00',1,126.38,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10391,'DRACD',3,'1996-12-23 00:00:00','1997-01-20 00:00:00','1996-12-31 00:00:00',3,5.45,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(10392,'PICCO',2,'1996-12-24 00:00:00','1997-01-21 00:00:00','1997-01-01 00:00:00',3,122.46,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10393,'SAVEA',1,'1996-12-25 00:00:00','1997-01-22 00:00:00','1997-01-03 00:00:00',3,126.56,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10394,'HUNGC',1,'1996-12-25 00:00:00','1997-01-22 00:00:00','1997-01-03 00:00:00',3,30.34,'Hungry Coyote Import Store','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA',NULL),(10398,'SAVEA',2,'1996-12-30 00:00:00','1997-01-27 00:00:00','1997-01-09 00:00:00',3,89.16,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10400,'EASTC',1,'1997-01-01 00:00:00','1997-01-29 00:00:00','1997-01-16 00:00:00',3,83.93,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(10401,'RATTC',1,'1997-01-01 00:00:00','1997-01-29 00:00:00','1997-01-10 00:00:00',1,12.51,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10402,'ERNSH',8,'1997-01-02 00:00:00','1997-02-13 00:00:00','1997-01-10 00:00:00',2,67.88,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10403,'ERNSH',4,'1997-01-03 00:00:00','1997-01-31 00:00:00','1997-01-09 00:00:00',3,73.79,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10404,'MAGAA',2,'1997-01-03 00:00:00','1997-01-31 00:00:00','1997-01-08 00:00:00',1,155.97,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10405,'LINOD',1,'1997-01-06 00:00:00','1997-02-03 00:00:00','1997-01-22 00:00:00',1,34.82,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10410,'BOTTM',3,'1997-01-10 00:00:00','1997-02-07 00:00:00','1997-01-15 00:00:00',3,2.4,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10411,'BOTTM',9,'1997-01-10 00:00:00','1997-02-07 00:00:00','1997-01-21 00:00:00',3,23.65,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10412,'WARTH',8,'1997-01-13 00:00:00','1997-02-10 00:00:00','1997-01-15 00:00:00',2,3.77,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10413,'LAMAI',3,'1997-01-14 00:00:00','1997-02-11 00:00:00','1997-01-16 00:00:00',2,95.66,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10415,'HUNGC',3,'1997-01-15 00:00:00','1997-02-12 00:00:00','1997-01-24 00:00:00',1,0.2,'Hungry Coyote Import Store','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA',NULL),(10416,'WARTH',8,'1997-01-16 00:00:00','1997-02-13 00:00:00','1997-01-27 00:00:00',3,22.72,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10420,'WELLI',3,'1997-01-21 00:00:00','1997-02-18 00:00:00','1997-01-27 00:00:00',1,44.12,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10422,'FRANS',2,'1997-01-22 00:00:00','1997-02-19 00:00:00','1997-01-31 00:00:00',1,3.02,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(10423,'GOURL',6,'1997-01-23 00:00:00','1997-02-06 00:00:00','1997-02-24 00:00:00',3,24.5,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10425,'LAMAI',6,'1997-01-24 00:00:00','1997-02-21 00:00:00','1997-02-14 00:00:00',2,7.93,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10427,'PICCO',4,'1997-01-27 00:00:00','1997-02-24 00:00:00','1997-03-03 00:00:00',2,31.29,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10428,'REGGC',7,'1997-01-28 00:00:00','1997-02-25 00:00:00','1997-02-04 00:00:00',1,11.09,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10429,'HUNGO',3,'1997-01-29 00:00:00','1997-03-12 00:00:00','1997-02-07 00:00:00',2,56.63,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10430,'ERNSH',4,'1997-01-30 00:00:00','1997-02-13 00:00:00','1997-02-03 00:00:00',1,458.78,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10431,'BOTTM',4,'1997-01-30 00:00:00','1997-02-13 00:00:00','1997-02-07 00:00:00',2,44.17,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10432,'SPLIR',3,'1997-01-31 00:00:00','1997-02-14 00:00:00','1997-02-07 00:00:00',2,4.34,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10435,'CONSH',8,'1997-02-04 00:00:00','1997-03-18 00:00:00','1997-02-07 00:00:00',2,9.21,'Consolidated Holdings','Berkeley Gardens\n12  Brewery ','London',NULL,'WX1 6LT','UK',NULL),(10437,'WARTH',8,'1997-02-05 00:00:00','1997-03-05 00:00:00','1997-02-12 00:00:00',1,19.97,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10440,'SAVEA',4,'1997-02-10 00:00:00','1997-03-10 00:00:00','1997-02-28 00:00:00',2,86.53,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10441,'OLDWO',3,'1997-02-10 00:00:00','1997-03-24 00:00:00','1997-03-14 00:00:00',2,73.02,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10442,'ERNSH',3,'1997-02-11 00:00:00','1997-03-11 00:00:00','1997-02-18 00:00:00',2,47.94,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10443,'REGGC',8,'1997-02-12 00:00:00','1997-03-12 00:00:00','1997-02-14 00:00:00',1,13.95,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10447,'RICAR',4,'1997-02-14 00:00:00','1997-03-14 00:00:00','1997-03-07 00:00:00',2,68.66,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10448,'RANCH',4,'1997-02-17 00:00:00','1997-03-17 00:00:00','1997-02-24 00:00:00',2,38.82,'Rancho grande','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina',NULL),(10450,'VICTE',8,'1997-02-19 00:00:00','1997-03-19 00:00:00','1997-03-11 00:00:00',2,7.23,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10452,'SAVEA',8,'1997-02-20 00:00:00','1997-03-20 00:00:00','1997-02-26 00:00:00',1,140.26,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10453,'AROUT',1,'1997-02-21 00:00:00','1997-03-21 00:00:00','1997-02-26 00:00:00',2,25.36,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10454,'LAMAI',4,'1997-02-21 00:00:00','1997-03-21 00:00:00','1997-02-25 00:00:00',3,2.74,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10455,'WARTH',8,'1997-02-24 00:00:00','1997-04-07 00:00:00','1997-03-03 00:00:00',2,180.45,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10459,'VICTE',4,'1997-02-27 00:00:00','1997-03-27 00:00:00','1997-02-28 00:00:00',2,25.09,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10462,'CONSH',2,'1997-03-03 00:00:00','1997-03-31 00:00:00','1997-03-18 00:00:00',1,6.17,'Consolidated Holdings','Berkeley Gardens\n12  Brewery ','London',NULL,'WX1 6LT','UK',NULL),(10464,'FURIB',4,'1997-03-04 00:00:00','1997-04-01 00:00:00','1997-03-14 00:00:00',2,89,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10467,'MAGAA',8,'1997-03-06 00:00:00','1997-04-03 00:00:00','1997-03-11 00:00:00',2,4.93,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10469,'WHITC',1,'1997-03-10 00:00:00','1997-04-07 00:00:00','1997-03-14 00:00:00',1,60.18,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10470,'BONAP',4,'1997-03-11 00:00:00','1997-04-08 00:00:00','1997-03-14 00:00:00',2,64.56,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10471,'BSBEV',2,'1997-03-11 00:00:00','1997-04-08 00:00:00','1997-03-18 00:00:00',3,45.59,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10472,'SEVES',8,'1997-03-12 00:00:00','1997-04-09 00:00:00','1997-03-19 00:00:00',1,4.2,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10473,'ISLAT',1,'1997-03-13 00:00:00','1997-03-27 00:00:00','1997-03-21 00:00:00',3,16.37,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10478,'VICTE',2,'1997-03-18 00:00:00','1997-04-01 00:00:00','1997-03-26 00:00:00',3,4.81,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10479,'RATTC',3,'1997-03-19 00:00:00','1997-04-16 00:00:00','1997-03-21 00:00:00',3,708.95,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10481,'RICAR',8,'1997-03-20 00:00:00','1997-04-17 00:00:00','1997-03-25 00:00:00',2,64.33,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10482,'LAZYK',1,'1997-03-21 00:00:00','1997-04-18 00:00:00','1997-04-10 00:00:00',3,7.48,'Lazy K Kountry Store','12 Orchestra Terrace','Walla Walla','WA','99362','USA',NULL),(10483,'WHITC',7,'1997-03-24 00:00:00','1997-04-21 00:00:00','1997-04-25 00:00:00',2,15.28,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10484,'BSBEV',3,'1997-03-24 00:00:00','1997-04-21 00:00:00','1997-04-01 00:00:00',3,6.88,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10485,'LINOD',4,'1997-03-25 00:00:00','1997-04-08 00:00:00','1997-03-31 00:00:00',2,64.45,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10489,'PICCO',6,'1997-03-28 00:00:00','1997-04-25 00:00:00','1997-04-09 00:00:00',2,5.29,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10491,'FURIB',8,'1997-03-31 00:00:00','1997-04-28 00:00:00','1997-04-08 00:00:00',3,16.96,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10492,'BOTTM',3,'1997-04-01 00:00:00','1997-04-29 00:00:00','1997-04-11 00:00:00',1,62.89,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10493,'LAMAI',4,'1997-04-02 00:00:00','1997-04-30 00:00:00','1997-04-10 00:00:00',3,10.64,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10495,'LAUGB',3,'1997-04-03 00:00:00','1997-05-01 00:00:00','1997-04-11 00:00:00',3,4.65,'Laughing Bacchus Wine Cellars','2319 Elm St.','Vancouver','BC','V3F 2K1','Canada',NULL),(10497,'LEHMS',7,'1997-04-04 00:00:00','1997-05-02 00:00:00','1997-04-07 00:00:00',1,36.21,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10500,'LAMAI',6,'1997-04-09 00:00:00','1997-05-07 00:00:00','1997-04-17 00:00:00',1,42.68,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10501,'BLAUS',9,'1997-04-09 00:00:00','1997-05-07 00:00:00','1997-04-16 00:00:00',3,8.85,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10503,'HUNGO',6,'1997-04-11 00:00:00','1997-05-09 00:00:00','1997-04-16 00:00:00',2,16.74,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10504,'WHITC',4,'1997-04-11 00:00:00','1997-05-09 00:00:00','1997-04-18 00:00:00',3,59.13,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10509,'BLAUS',4,'1997-04-17 00:00:00','1997-05-15 00:00:00','1997-04-29 00:00:00',1,0.15,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10510,'SAVEA',6,'1997-04-18 00:00:00','1997-05-16 00:00:00','1997-04-28 00:00:00',3,367.63,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10511,'BONAP',4,'1997-04-18 00:00:00','1997-05-16 00:00:00','1997-04-21 00:00:00',3,350.64,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10513,'WANDK',7,'1997-04-22 00:00:00','1997-06-03 00:00:00','1997-04-28 00:00:00',1,105.65,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10514,'ERNSH',3,'1997-04-22 00:00:00','1997-05-20 00:00:00','1997-05-16 00:00:00',2,789.95,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10516,'HUNGO',2,'1997-04-24 00:00:00','1997-05-22 00:00:00','1997-05-01 00:00:00',3,62.78,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10517,'NORTS',3,'1997-04-24 00:00:00','1997-05-22 00:00:00','1997-04-29 00:00:00',3,32.07,'North/South','South House\n300 Queensbridge','London',NULL,'SW7 1RZ','UK',NULL),(10519,'CHOPS',6,'1997-04-28 00:00:00','1997-05-26 00:00:00','1997-05-01 00:00:00',3,91.76,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10521,'CACTU',8,'1997-04-29 00:00:00','1997-05-27 00:00:00','1997-05-02 00:00:00',2,17.22,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(10522,'LEHMS',4,'1997-04-30 00:00:00','1997-05-28 00:00:00','1997-05-06 00:00:00',1,45.33,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10523,'SEVES',7,'1997-05-01 00:00:00','1997-05-29 00:00:00','1997-05-30 00:00:00',2,77.63,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10525,'BONAP',1,'1997-05-02 00:00:00','1997-05-30 00:00:00','1997-05-23 00:00:00',2,11.06,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10526,'WARTH',4,'1997-05-05 00:00:00','1997-06-02 00:00:00','1997-05-15 00:00:00',2,58.59,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10528,'GREAL',6,'1997-05-06 00:00:00','1997-05-20 00:00:00','1997-05-09 00:00:00',2,3.35,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10529,'MAISD',5,'1997-05-07 00:00:00','1997-06-04 00:00:00','1997-05-09 00:00:00',2,66.69,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10530,'PICCO',3,'1997-05-08 00:00:00','1997-06-05 00:00:00','1997-05-12 00:00:00',2,339.22,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10532,'EASTC',7,'1997-05-09 00:00:00','1997-06-06 00:00:00','1997-05-12 00:00:00',3,74.46,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(10534,'LEHMS',8,'1997-05-12 00:00:00','1997-06-09 00:00:00','1997-05-14 00:00:00',2,27.94,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10536,'LEHMS',3,'1997-05-14 00:00:00','1997-06-11 00:00:00','1997-06-06 00:00:00',2,58.88,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10538,'BSBEV',9,'1997-05-15 00:00:00','1997-06-12 00:00:00','1997-05-16 00:00:00',3,4.87,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10539,'BSBEV',6,'1997-05-16 00:00:00','1997-06-13 00:00:00','1997-05-23 00:00:00',3,12.36,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10544,'LONEP',4,'1997-05-21 00:00:00','1997-06-18 00:00:00','1997-05-30 00:00:00',1,24.91,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10545,'LAZYK',8,'1997-05-22 00:00:00','1997-06-19 00:00:00','1997-06-26 00:00:00',2,11.92,'Lazy K Kountry Store','12 Orchestra Terrace','Walla Walla','WA','99362','USA',NULL),(10546,'VICTE',1,'1997-05-23 00:00:00','1997-06-20 00:00:00','1997-05-27 00:00:00',3,194.72,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10547,'SEVES',3,'1997-05-23 00:00:00','1997-06-20 00:00:00','1997-06-02 00:00:00',2,178.43,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10551,'FURIB',4,'1997-05-28 00:00:00','1997-07-09 00:00:00','1997-06-06 00:00:00',3,72.95,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10553,'WARTH',2,'1997-05-30 00:00:00','1997-06-27 00:00:00','1997-06-03 00:00:00',2,149.49,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10555,'SAVEA',6,'1997-06-02 00:00:00','1997-06-30 00:00:00','1997-06-04 00:00:00',3,252.49,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10557,'LEHMS',9,'1997-06-03 00:00:00','1997-06-17 00:00:00','1997-06-06 00:00:00',2,96.72,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10558,'AROUT',1,'1997-06-04 00:00:00','1997-07-02 00:00:00','1997-06-10 00:00:00',2,72.97,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10562,'REGGC',1,'1997-06-09 00:00:00','1997-07-07 00:00:00','1997-06-12 00:00:00',1,22.95,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10563,'RICAR',2,'1997-06-10 00:00:00','1997-07-22 00:00:00','1997-06-24 00:00:00',2,60.43,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10564,'RATTC',4,'1997-06-10 00:00:00','1997-07-08 00:00:00','1997-06-16 00:00:00',3,13.75,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10567,'HUNGO',1,'1997-06-12 00:00:00','1997-07-10 00:00:00','1997-06-17 00:00:00',1,33.97,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10569,'RATTC',5,'1997-06-16 00:00:00','1997-07-14 00:00:00','1997-07-11 00:00:00',1,58.98,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10571,'ERNSH',8,'1997-06-17 00:00:00','1997-07-29 00:00:00','1997-07-04 00:00:00',3,26.06,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10574,'TRAIH',4,'1997-06-19 00:00:00','1997-07-17 00:00:00','1997-06-30 00:00:00',2,37.6,'Trail\'s Head Gourmet Provisioners','722 DaVinci Blvd.','Kirkland','WA','98034','USA',NULL),(10575,'MORGK',5,'1997-06-20 00:00:00','1997-07-04 00:00:00','1997-06-30 00:00:00',1,127.34,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',NULL,'04179','Germany',NULL),(10577,'TRAIH',9,'1997-06-23 00:00:00','1997-08-04 00:00:00','1997-06-30 00:00:00',2,25.41,'Trail\'s Head Gourmet Provisioners','722 DaVinci Blvd.','Kirkland','WA','98034','USA',NULL),(10578,'BSBEV',4,'1997-06-24 00:00:00','1997-07-22 00:00:00','1997-07-25 00:00:00',3,29.6,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10579,'LETSS',1,'1997-06-25 00:00:00','1997-07-23 00:00:00','1997-07-04 00:00:00',2,13.73,'Let\'s Stop N Shop','87 Polk St.\nSuite 5','San Francisco','CA','94117','USA',NULL),(10582,'BLAUS',3,'1997-06-27 00:00:00','1997-07-25 00:00:00','1997-07-14 00:00:00',2,27.71,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10583,'WARTH',2,'1997-06-30 00:00:00','1997-07-28 00:00:00','1997-07-04 00:00:00',2,7.28,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10585,'WELLI',7,'1997-07-01 00:00:00','1997-07-29 00:00:00','1997-07-10 00:00:00',1,13.41,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10586,'REGGC',9,'1997-07-02 00:00:00','1997-07-30 00:00:00','1997-07-09 00:00:00',1,0.48,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10589,'GREAL',8,'1997-07-04 00:00:00','1997-08-01 00:00:00','1997-07-14 00:00:00',2,4.42,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10592,'LEHMS',3,'1997-07-08 00:00:00','1997-08-05 00:00:00','1997-07-16 00:00:00',1,32.1,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10593,'LEHMS',7,'1997-07-09 00:00:00','1997-08-06 00:00:00','1997-08-13 00:00:00',2,174.2,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10594,'OLDWO',3,'1997-07-09 00:00:00','1997-08-06 00:00:00','1997-07-16 00:00:00',2,5.24,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10595,'ERNSH',2,'1997-07-10 00:00:00','1997-08-07 00:00:00','1997-07-14 00:00:00',1,96.78,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10596,'WHITC',8,'1997-07-11 00:00:00','1997-08-08 00:00:00','1997-08-12 00:00:00',1,16.34,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10597,'PICCO',7,'1997-07-11 00:00:00','1997-08-08 00:00:00','1997-07-18 00:00:00',3,35.12,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10598,'RATTC',1,'1997-07-14 00:00:00','1997-08-11 00:00:00','1997-07-18 00:00:00',3,44.42,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10599,'BSBEV',6,'1997-07-15 00:00:00','1997-08-26 00:00:00','1997-07-21 00:00:00',3,29.98,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10600,'HUNGC',4,'1997-07-16 00:00:00','1997-08-13 00:00:00','1997-07-21 00:00:00',1,45.13,'Hungry Coyote Import Store','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA',NULL),(10603,'SAVEA',8,'1997-07-18 00:00:00','1997-08-15 00:00:00','1997-08-08 00:00:00',2,48.77,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10604,'FURIB',1,'1997-07-18 00:00:00','1997-08-15 00:00:00','1997-07-29 00:00:00',1,7.46,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10607,'SAVEA',5,'1997-07-22 00:00:00','1997-08-19 00:00:00','1997-07-25 00:00:00',1,200.24,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10609,'DUMON',7,'1997-07-24 00:00:00','1997-08-21 00:00:00','1997-07-30 00:00:00',2,1.85,'Du monde entier','67, rue des Cinquante Otages','Nantes',NULL,'44000','France',NULL),(10610,'LAMAI',8,'1997-07-25 00:00:00','1997-08-22 00:00:00','1997-08-06 00:00:00',1,26.78,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10611,'WOLZA',6,'1997-07-25 00:00:00','1997-08-22 00:00:00','1997-08-01 00:00:00',2,80.65,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(10612,'SAVEA',1,'1997-07-28 00:00:00','1997-08-25 00:00:00','1997-08-01 00:00:00',2,544.08,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10614,'BLAUS',8,'1997-07-29 00:00:00','1997-08-26 00:00:00','1997-08-01 00:00:00',3,1.93,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10615,'WILMK',2,'1997-07-30 00:00:00','1997-08-27 00:00:00','1997-08-06 00:00:00',3,0.75,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10616,'GREAL',1,'1997-07-31 00:00:00','1997-08-28 00:00:00','1997-08-05 00:00:00',2,116.53,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10617,'GREAL',4,'1997-07-31 00:00:00','1997-08-28 00:00:00','1997-08-04 00:00:00',2,18.53,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10620,'LAUGB',2,'1997-08-05 00:00:00','1997-09-02 00:00:00','1997-08-14 00:00:00',3,0.94,'Laughing Bacchus Wine Cellars','2319 Elm St.','Vancouver','BC','V3F 2K1','Canada',NULL),(10621,'ISLAT',4,'1997-08-05 00:00:00','1997-09-02 00:00:00','1997-08-11 00:00:00',2,23.73,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10622,'RICAR',4,'1997-08-06 00:00:00','1997-09-03 00:00:00','1997-08-11 00:00:00',3,50.97,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10624,'THECR',4,'1997-08-07 00:00:00','1997-09-04 00:00:00','1997-08-19 00:00:00',2,94.8,'The Cracker Box','55 Grizzly Peak Rd.','Butte','MT','59801','USA',NULL),(10627,'SAVEA',8,'1997-08-11 00:00:00','1997-09-22 00:00:00','1997-08-21 00:00:00',3,107.46,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10631,'LAMAI',8,'1997-08-14 00:00:00','1997-09-11 00:00:00','1997-08-15 00:00:00',1,0.87,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10632,'WANDK',8,'1997-08-14 00:00:00','1997-09-11 00:00:00','1997-08-19 00:00:00',1,41.38,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10633,'ERNSH',7,'1997-08-15 00:00:00','1997-09-12 00:00:00','1997-08-18 00:00:00',3,477.9,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10635,'MAGAA',8,'1997-08-18 00:00:00','1997-09-15 00:00:00','1997-08-21 00:00:00',3,47.46,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10636,'WARTH',4,'1997-08-19 00:00:00','1997-09-16 00:00:00','1997-08-26 00:00:00',1,1.15,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10638,'LINOD',3,'1997-08-20 00:00:00','1997-09-17 00:00:00','1997-09-01 00:00:00',1,158.44,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10640,'WANDK',4,'1997-08-21 00:00:00','1997-09-18 00:00:00','1997-08-28 00:00:00',1,23.55,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10643,'ALFKI',6,'1997-08-25 00:00:00','1997-09-22 00:00:00','1997-09-02 00:00:00',1,29.46,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(10644,'WELLI',3,'1997-08-25 00:00:00','1997-09-22 00:00:00','1997-09-01 00:00:00',2,0.14,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10646,'HUNGO',9,'1997-08-27 00:00:00','1997-10-08 00:00:00','1997-09-03 00:00:00',3,142.33,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10648,'RICAR',5,'1997-08-28 00:00:00','1997-10-09 00:00:00','1997-09-09 00:00:00',2,14.25,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10649,'MAISD',5,'1997-08-28 00:00:00','1997-09-25 00:00:00','1997-08-29 00:00:00',3,6.2,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10651,'WANDK',8,'1997-09-01 00:00:00','1997-09-29 00:00:00','1997-09-11 00:00:00',2,20.6,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10652,'GOURL',4,'1997-09-01 00:00:00','1997-09-29 00:00:00','1997-09-08 00:00:00',2,7.14,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10655,'REGGC',1,'1997-09-03 00:00:00','1997-10-01 00:00:00','1997-09-11 00:00:00',2,4.41,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10656,'GREAL',6,'1997-09-04 00:00:00','1997-10-02 00:00:00','1997-09-10 00:00:00',1,57.15,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10657,'SAVEA',2,'1997-09-04 00:00:00','1997-10-02 00:00:00','1997-09-15 00:00:00',2,352.69,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10660,'HUNGC',8,'1997-09-08 00:00:00','1997-10-06 00:00:00','1997-10-15 00:00:00',1,111.29,'Hungry Coyote Import Store','City Center Plaza\n516 Main St.','Elgin','OR','97827','USA',NULL),(10661,'HUNGO',7,'1997-09-09 00:00:00','1997-10-07 00:00:00','1997-09-15 00:00:00',3,17.55,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10662,'LONEP',3,'1997-09-09 00:00:00','1997-10-07 00:00:00','1997-09-18 00:00:00',2,1.28,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10663,'BONAP',2,'1997-09-10 00:00:00','1997-09-24 00:00:00','1997-10-03 00:00:00',2,113.15,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10664,'FURIB',1,'1997-09-10 00:00:00','1997-10-08 00:00:00','1997-09-19 00:00:00',3,1.27,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10665,'LONEP',1,'1997-09-11 00:00:00','1997-10-09 00:00:00','1997-09-17 00:00:00',2,26.31,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10667,'ERNSH',7,'1997-09-12 00:00:00','1997-10-10 00:00:00','1997-09-19 00:00:00',1,78.09,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10668,'WANDK',1,'1997-09-15 00:00:00','1997-10-13 00:00:00','1997-09-23 00:00:00',2,47.22,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(10671,'FRANR',1,'1997-09-17 00:00:00','1997-10-15 00:00:00','1997-09-24 00:00:00',1,30.34,'France restauration','54, rue Royale','Nantes',NULL,'44000','France',NULL),(10673,'WILMK',2,'1997-09-18 00:00:00','1997-10-16 00:00:00','1997-09-19 00:00:00',1,22.76,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10674,'ISLAT',4,'1997-09-18 00:00:00','1997-10-16 00:00:00','1997-09-30 00:00:00',2,0.9,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10678,'SAVEA',7,'1997-09-23 00:00:00','1997-10-21 00:00:00','1997-10-16 00:00:00',3,388.98,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10680,'OLDWO',1,'1997-09-24 00:00:00','1997-10-22 00:00:00','1997-09-26 00:00:00',1,26.61,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10681,'GREAL',3,'1997-09-25 00:00:00','1997-10-23 00:00:00','1997-09-30 00:00:00',3,76.13,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10683,'DUMON',2,'1997-09-26 00:00:00','1997-10-24 00:00:00','1997-10-01 00:00:00',1,4.4,'Du monde entier','67, rue des Cinquante Otages','Nantes',NULL,'44000','France',NULL),(10685,'GOURL',4,'1997-09-29 00:00:00','1997-10-13 00:00:00','1997-10-03 00:00:00',2,33.75,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10686,'PICCO',2,'1997-09-30 00:00:00','1997-10-28 00:00:00','1997-10-08 00:00:00',1,96.5,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10687,'HUNGO',9,'1997-09-30 00:00:00','1997-10-28 00:00:00','1997-10-30 00:00:00',2,296.43,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10692,'ALFKI',4,'1997-10-03 00:00:00','1997-10-31 00:00:00','1997-10-13 00:00:00',2,61.02,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(10693,'WHITC',3,'1997-10-06 00:00:00','1997-10-20 00:00:00','1997-10-10 00:00:00',3,139.34,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10695,'WILMK',7,'1997-10-07 00:00:00','1997-11-18 00:00:00','1997-10-14 00:00:00',1,16.72,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10696,'WHITC',8,'1997-10-08 00:00:00','1997-11-19 00:00:00','1997-10-14 00:00:00',3,102.55,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10697,'LINOD',3,'1997-10-08 00:00:00','1997-11-05 00:00:00','1997-10-14 00:00:00',1,45.52,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10698,'ERNSH',4,'1997-10-09 00:00:00','1997-11-06 00:00:00','1997-10-17 00:00:00',1,272.47,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10699,'MORGK',3,'1997-10-09 00:00:00','1997-11-06 00:00:00','1997-10-13 00:00:00',3,0.58,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',NULL,'04179','Germany',NULL),(10700,'SAVEA',3,'1997-10-10 00:00:00','1997-11-07 00:00:00','1997-10-16 00:00:00',1,65.1,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10701,'HUNGO',6,'1997-10-13 00:00:00','1997-10-27 00:00:00','1997-10-15 00:00:00',3,220.31,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10702,'ALFKI',4,'1997-10-13 00:00:00','1997-11-24 00:00:00','1997-10-21 00:00:00',1,23.94,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(10706,'OLDWO',8,'1997-10-16 00:00:00','1997-11-13 00:00:00','1997-10-21 00:00:00',3,135.63,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10707,'AROUT',4,'1997-10-16 00:00:00','1997-10-30 00:00:00','1997-10-23 00:00:00',3,21.74,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10708,'THEBI',6,'1997-10-17 00:00:00','1997-11-28 00:00:00','1997-11-05 00:00:00',2,2.96,'The Big Cheese','89 Jefferson Way\nSuite 2','Portland','OR','97201','USA',NULL),(10709,'GOURL',1,'1997-10-17 00:00:00','1997-11-14 00:00:00','1997-11-20 00:00:00',3,210.8,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10710,'FRANS',1,'1997-10-20 00:00:00','1997-11-17 00:00:00','1997-10-23 00:00:00',1,4.98,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(10711,'SAVEA',5,'1997-10-21 00:00:00','1997-12-02 00:00:00','1997-10-29 00:00:00',2,52.41,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10712,'HUNGO',3,'1997-10-21 00:00:00','1997-11-18 00:00:00','1997-10-31 00:00:00',1,89.93,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10713,'SAVEA',1,'1997-10-22 00:00:00','1997-11-19 00:00:00','1997-10-24 00:00:00',1,167.05,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10714,'SAVEA',5,'1997-10-22 00:00:00','1997-11-19 00:00:00','1997-10-27 00:00:00',3,24.49,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10715,'BONAP',3,'1997-10-23 00:00:00','1997-11-06 00:00:00','1997-10-29 00:00:00',1,63.2,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10716,'RANCH',4,'1997-10-24 00:00:00','1997-11-21 00:00:00','1997-10-27 00:00:00',2,22.57,'Rancho grande','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina',NULL),(10719,'LETSS',8,'1997-10-27 00:00:00','1997-11-24 00:00:00','1997-11-05 00:00:00',2,51.44,'Let\'s Stop N Shop','87 Polk St.\nSuite 5','San Francisco','CA','94117','USA',NULL),(10722,'SAVEA',8,'1997-10-29 00:00:00','1997-12-10 00:00:00','1997-11-04 00:00:00',1,74.58,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10723,'WHITC',3,'1997-10-30 00:00:00','1997-11-27 00:00:00','1997-11-25 00:00:00',1,21.72,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10726,'EASTC',4,'1997-11-03 00:00:00','1997-11-17 00:00:00','1997-12-05 00:00:00',1,16.56,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(10727,'REGGC',2,'1997-11-03 00:00:00','1997-12-01 00:00:00','1997-12-05 00:00:00',1,89.9,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10729,'LINOD',8,'1997-11-04 00:00:00','1997-12-16 00:00:00','1997-11-14 00:00:00',3,141.06,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10730,'BONAP',5,'1997-11-05 00:00:00','1997-12-03 00:00:00','1997-11-14 00:00:00',1,20.12,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10731,'CHOPS',7,'1997-11-06 00:00:00','1997-12-04 00:00:00','1997-11-14 00:00:00',1,96.65,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10732,'BONAP',3,'1997-11-06 00:00:00','1997-12-04 00:00:00','1997-11-07 00:00:00',1,16.97,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10734,'GOURL',2,'1997-11-07 00:00:00','1997-12-05 00:00:00','1997-11-12 00:00:00',3,1.63,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10735,'LETSS',6,'1997-11-10 00:00:00','1997-12-08 00:00:00','1997-11-21 00:00:00',2,45.97,'Let\'s Stop N Shop','87 Polk St.\nSuite 5','San Francisco','CA','94117','USA',NULL),(10736,'HUNGO',9,'1997-11-11 00:00:00','1997-12-09 00:00:00','1997-11-21 00:00:00',2,44.1,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10737,'VINET',2,'1997-11-11 00:00:00','1997-12-09 00:00:00','1997-11-18 00:00:00',2,7.79,'Vins et alcools Chevalier','59 rue de l\'Abbaye','Reims',NULL,'51100','France',NULL),(10739,'VINET',3,'1997-11-12 00:00:00','1997-12-10 00:00:00','1997-11-17 00:00:00',3,11.08,'Vins et alcools Chevalier','59 rue de l\'Abbaye','Reims',NULL,'51100','France',NULL),(10740,'WHITC',4,'1997-11-13 00:00:00','1997-12-11 00:00:00','1997-11-25 00:00:00',2,81.88,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10741,'AROUT',4,'1997-11-14 00:00:00','1997-11-28 00:00:00','1997-11-18 00:00:00',3,10.96,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10742,'BOTTM',3,'1997-11-14 00:00:00','1997-12-12 00:00:00','1997-11-18 00:00:00',3,243.73,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10743,'AROUT',1,'1997-11-17 00:00:00','1997-12-15 00:00:00','1997-11-21 00:00:00',2,23.72,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10746,'CHOPS',1,'1997-11-19 00:00:00','1997-12-17 00:00:00','1997-11-21 00:00:00',3,31.43,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10747,'PICCO',6,'1997-11-19 00:00:00','1997-12-17 00:00:00','1997-11-26 00:00:00',1,117.33,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10748,'SAVEA',3,'1997-11-20 00:00:00','1997-12-18 00:00:00','1997-11-28 00:00:00',1,232.55,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10749,'ISLAT',4,'1997-11-20 00:00:00','1997-12-18 00:00:00','1997-12-19 00:00:00',2,61.53,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10750,'WARTH',9,'1997-11-21 00:00:00','1997-12-19 00:00:00','1997-11-24 00:00:00',1,79.3,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10752,'NORTS',2,'1997-11-24 00:00:00','1997-12-22 00:00:00','1997-11-28 00:00:00',3,1.39,'North/South','South House\n300 Queensbridge','London',NULL,'SW7 1RZ','UK',NULL),(10753,'FRANS',3,'1997-11-25 00:00:00','1997-12-23 00:00:00','1997-11-27 00:00:00',1,7.7,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(10754,'MAGAA',6,'1997-11-25 00:00:00','1997-12-23 00:00:00','1997-11-27 00:00:00',3,2.38,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10755,'BONAP',4,'1997-11-26 00:00:00','1997-12-24 00:00:00','1997-11-28 00:00:00',2,16.71,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10756,'SPLIR',8,'1997-11-27 00:00:00','1997-12-25 00:00:00','1997-12-02 00:00:00',2,73.21,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10757,'SAVEA',6,'1997-11-27 00:00:00','1997-12-25 00:00:00','1997-12-15 00:00:00',1,8.19,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10760,'MAISD',4,'1997-12-01 00:00:00','1997-12-29 00:00:00','1997-12-10 00:00:00',1,155.64,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10761,'RATTC',5,'1997-12-02 00:00:00','1997-12-30 00:00:00','1997-12-08 00:00:00',2,18.66,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10764,'ERNSH',6,'1997-12-03 00:00:00','1997-12-31 00:00:00','1997-12-08 00:00:00',3,145.45,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10768,'AROUT',3,'1997-12-08 00:00:00','1998-01-05 00:00:00','1997-12-15 00:00:00',2,146.32,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10771,'ERNSH',9,'1997-12-10 00:00:00','1998-01-07 00:00:00','1998-01-02 00:00:00',2,11.19,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10772,'LEHMS',3,'1997-12-10 00:00:00','1998-01-07 00:00:00','1997-12-19 00:00:00',2,91.28,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10773,'ERNSH',1,'1997-12-11 00:00:00','1998-01-08 00:00:00','1997-12-16 00:00:00',3,96.43,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10775,'THECR',7,'1997-12-12 00:00:00','1998-01-09 00:00:00','1997-12-26 00:00:00',1,20.25,'The Cracker Box','55 Grizzly Peak Rd.','Butte','MT','59801','USA',NULL),(10776,'ERNSH',1,'1997-12-15 00:00:00','1998-01-12 00:00:00','1997-12-18 00:00:00',3,351.53,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10777,'GOURL',7,'1997-12-15 00:00:00','1997-12-29 00:00:00','1998-01-21 00:00:00',2,3.01,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10779,'MORGK',3,'1997-12-16 00:00:00','1998-01-13 00:00:00','1998-01-14 00:00:00',2,58.13,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',NULL,'04179','Germany',NULL),(10781,'WARTH',2,'1997-12-17 00:00:00','1998-01-14 00:00:00','1997-12-19 00:00:00',3,73.16,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(10782,'CACTU',9,'1997-12-17 00:00:00','1998-01-14 00:00:00','1997-12-22 00:00:00',3,1.1,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(10784,'MAGAA',4,'1997-12-18 00:00:00','1998-01-15 00:00:00','1997-12-22 00:00:00',3,70.09,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10787,'LAMAI',2,'1997-12-19 00:00:00','1998-01-02 00:00:00','1997-12-26 00:00:00',1,249.93,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10790,'GOURL',6,'1997-12-22 00:00:00','1998-01-19 00:00:00','1997-12-26 00:00:00',1,28.23,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10792,'WOLZA',1,'1997-12-23 00:00:00','1998-01-20 00:00:00','1997-12-31 00:00:00',3,23.79,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(10793,'AROUT',3,'1997-12-24 00:00:00','1998-01-21 00:00:00','1998-01-08 00:00:00',3,4.52,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10795,'ERNSH',8,'1997-12-24 00:00:00','1998-01-21 00:00:00','1998-01-20 00:00:00',2,126.66,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10797,'DRACD',7,'1997-12-25 00:00:00','1998-01-22 00:00:00','1998-01-05 00:00:00',2,33.35,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(10798,'ISLAT',2,'1997-12-26 00:00:00','1998-01-23 00:00:00','1998-01-05 00:00:00',1,2.33,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10800,'SEVES',1,'1997-12-26 00:00:00','1998-01-23 00:00:00','1998-01-05 00:00:00',3,137.44,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10803,'WELLI',4,'1997-12-30 00:00:00','1998-01-27 00:00:00','1998-01-06 00:00:00',1,55.23,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10804,'SEVES',6,'1997-12-30 00:00:00','1998-01-27 00:00:00','1998-01-07 00:00:00',2,27.33,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10805,'THEBI',2,'1997-12-30 00:00:00','1998-01-27 00:00:00','1998-01-09 00:00:00',3,237.34,'The Big Cheese','89 Jefferson Way\nSuite 2','Portland','OR','97201','USA',NULL),(10806,'VICTE',3,'1997-12-31 00:00:00','1998-01-28 00:00:00','1998-01-05 00:00:00',2,22.11,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10807,'FRANS',4,'1997-12-31 00:00:00','1998-01-28 00:00:00','1998-01-30 00:00:00',1,1.36,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(10808,'PRINI',2,'1998-01-01 00:00:00','1998-01-29 00:00:00','1998-01-09 00:00:00',3,45.53,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10809,'WELLI',7,'1998-01-01 00:00:00','1998-01-29 00:00:00','1998-01-07 00:00:00',1,4.87,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10810,'LAUGB',2,'1998-01-01 00:00:00','1998-01-29 00:00:00','1998-01-07 00:00:00',3,4.33,'Laughing Bacchus Wine Cellars','2319 Elm St.','Vancouver','BC','V3F 2K1','Canada',NULL),(10811,'LINOD',8,'1998-01-02 00:00:00','1998-01-30 00:00:00','1998-01-08 00:00:00',1,31.22,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10812,'REGGC',5,'1998-01-02 00:00:00','1998-01-30 00:00:00','1998-01-12 00:00:00',1,59.78,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10813,'RICAR',1,'1998-01-05 00:00:00','1998-02-02 00:00:00','1998-01-09 00:00:00',1,47.38,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10814,'VICTE',3,'1998-01-05 00:00:00','1998-02-02 00:00:00','1998-01-14 00:00:00',3,130.94,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10815,'SAVEA',2,'1998-01-05 00:00:00','1998-02-02 00:00:00','1998-01-14 00:00:00',3,14.62,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10816,'GREAL',4,'1998-01-06 00:00:00','1998-02-03 00:00:00','1998-02-04 00:00:00',2,719.78,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10818,'MAGAA',7,'1998-01-07 00:00:00','1998-02-04 00:00:00','1998-01-12 00:00:00',3,65.48,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10819,'CACTU',2,'1998-01-07 00:00:00','1998-02-04 00:00:00','1998-01-16 00:00:00',3,19.76,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(10820,'RATTC',3,'1998-01-07 00:00:00','1998-02-04 00:00:00','1998-01-13 00:00:00',2,37.52,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10821,'SPLIR',1,'1998-01-08 00:00:00','1998-02-05 00:00:00','1998-01-15 00:00:00',1,36.68,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10822,'TRAIH',6,'1998-01-08 00:00:00','1998-02-05 00:00:00','1998-01-16 00:00:00',3,7,'Trail\'s Head Gourmet Provisioners','722 DaVinci Blvd.','Kirkland','WA','98034','USA',NULL),(10825,'DRACD',1,'1998-01-09 00:00:00','1998-02-06 00:00:00','1998-01-14 00:00:00',1,79.25,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(10827,'BONAP',1,'1998-01-12 00:00:00','1998-01-26 00:00:00','1998-02-06 00:00:00',2,63.54,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10828,'RANCH',9,'1998-01-13 00:00:00','1998-01-27 00:00:00','1998-02-04 00:00:00',1,90.85,'Rancho grande','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina',NULL),(10829,'ISLAT',9,'1998-01-13 00:00:00','1998-02-10 00:00:00','1998-01-23 00:00:00',1,154.72,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10832,'LAMAI',2,'1998-01-14 00:00:00','1998-02-11 00:00:00','1998-01-19 00:00:00',2,43.26,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10835,'ALFKI',1,'1998-01-15 00:00:00','1998-02-12 00:00:00','1998-01-21 00:00:00',3,69.53,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(10836,'ERNSH',7,'1998-01-16 00:00:00','1998-02-13 00:00:00','1998-01-21 00:00:00',1,411.88,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10838,'LINOD',3,'1998-01-19 00:00:00','1998-02-16 00:00:00','1998-01-23 00:00:00',3,59.28,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10840,'LINOD',4,'1998-01-19 00:00:00','1998-03-02 00:00:00','1998-02-16 00:00:00',2,2.71,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10843,'VICTE',4,'1998-01-21 00:00:00','1998-02-18 00:00:00','1998-01-26 00:00:00',2,9.26,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10844,'PICCO',8,'1998-01-21 00:00:00','1998-02-18 00:00:00','1998-01-26 00:00:00',2,25.22,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(10847,'SAVEA',4,'1998-01-22 00:00:00','1998-02-05 00:00:00','1998-02-10 00:00:00',3,487.57,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10848,'CONSH',7,'1998-01-23 00:00:00','1998-02-20 00:00:00','1998-01-29 00:00:00',2,38.24,'Consolidated Holdings','Berkeley Gardens\n12  Brewery ','London',NULL,'WX1 6LT','UK',NULL),(10850,'VICTE',1,'1998-01-23 00:00:00','1998-03-06 00:00:00','1998-01-30 00:00:00',1,49.19,'Victuailles en stock','2, rue du Commerce','Lyon',NULL,'69004','France',NULL),(10851,'RICAR',5,'1998-01-26 00:00:00','1998-02-23 00:00:00','1998-02-02 00:00:00',1,160.55,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10852,'RATTC',8,'1998-01-26 00:00:00','1998-02-09 00:00:00','1998-01-30 00:00:00',1,174.05,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10853,'BLAUS',9,'1998-01-27 00:00:00','1998-02-24 00:00:00','1998-02-03 00:00:00',2,53.83,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10854,'ERNSH',3,'1998-01-27 00:00:00','1998-02-24 00:00:00','1998-02-05 00:00:00',2,100.22,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10855,'OLDWO',3,'1998-01-27 00:00:00','1998-02-24 00:00:00','1998-02-04 00:00:00',1,170.97,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10858,'LACOR',2,'1998-01-29 00:00:00','1998-02-26 00:00:00','1998-02-03 00:00:00',1,52.51,'La corne d\'abondance','67, avenue de l\'Europe','Versailles',NULL,'78000','France',NULL),(10860,'FRANR',3,'1998-01-29 00:00:00','1998-02-26 00:00:00','1998-02-04 00:00:00',3,19.26,'France restauration','54, rue Royale','Nantes',NULL,'44000','France',NULL),(10861,'WHITC',4,'1998-01-30 00:00:00','1998-02-27 00:00:00','1998-02-17 00:00:00',2,14.93,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10862,'LEHMS',8,'1998-01-30 00:00:00','1998-03-13 00:00:00','1998-02-02 00:00:00',2,53.23,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10864,'AROUT',4,'1998-02-02 00:00:00','1998-03-02 00:00:00','1998-02-09 00:00:00',2,3.04,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10867,'LONEP',6,'1998-02-03 00:00:00','1998-03-17 00:00:00','1998-02-11 00:00:00',1,1.93,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10869,'SEVES',5,'1998-02-04 00:00:00','1998-03-04 00:00:00','1998-02-09 00:00:00',1,143.28,'Seven Seas Imports','90 Wadhurst Rd.','London',NULL,'OX15 4NB','UK',NULL),(10870,'WOLZA',5,'1998-02-04 00:00:00','1998-03-04 00:00:00','1998-02-13 00:00:00',3,12.04,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(10871,'BONAP',9,'1998-02-05 00:00:00','1998-03-05 00:00:00','1998-02-10 00:00:00',2,112.27,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10873,'WILMK',4,'1998-02-06 00:00:00','1998-03-06 00:00:00','1998-02-09 00:00:00',1,0.82,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10876,'BONAP',7,'1998-02-09 00:00:00','1998-03-09 00:00:00','1998-02-12 00:00:00',3,60.42,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10877,'RICAR',1,'1998-02-09 00:00:00','1998-03-09 00:00:00','1998-02-19 00:00:00',1,38.06,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(10879,'WILMK',3,'1998-02-10 00:00:00','1998-03-10 00:00:00','1998-02-12 00:00:00',3,8.5,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10881,'CACTU',4,'1998-02-11 00:00:00','1998-03-11 00:00:00','1998-02-18 00:00:00',1,2.84,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(10882,'SAVEA',4,'1998-02-11 00:00:00','1998-03-11 00:00:00','1998-02-20 00:00:00',3,23.1,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10883,'LONEP',8,'1998-02-12 00:00:00','1998-03-12 00:00:00','1998-02-20 00:00:00',3,0.53,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(10884,'LETSS',4,'1998-02-12 00:00:00','1998-03-12 00:00:00','1998-02-13 00:00:00',2,90.97,'Let\'s Stop N Shop','87 Polk St.\nSuite 5','San Francisco','CA','94117','USA',NULL),(10889,'RATTC',9,'1998-02-16 00:00:00','1998-03-16 00:00:00','1998-02-23 00:00:00',3,280.61,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10890,'DUMON',7,'1998-02-16 00:00:00','1998-03-16 00:00:00','1998-02-18 00:00:00',1,32.76,'Du monde entier','67, rue des Cinquante Otages','Nantes',NULL,'44000','France',NULL),(10891,'LEHMS',7,'1998-02-17 00:00:00','1998-03-17 00:00:00','1998-02-19 00:00:00',2,20.37,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10892,'MAISD',4,'1998-02-17 00:00:00','1998-03-17 00:00:00','1998-02-19 00:00:00',2,120.27,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10894,'SAVEA',1,'1998-02-18 00:00:00','1998-03-18 00:00:00','1998-02-20 00:00:00',1,116.13,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10895,'ERNSH',3,'1998-02-18 00:00:00','1998-03-18 00:00:00','1998-02-23 00:00:00',1,162.75,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10896,'MAISD',7,'1998-02-19 00:00:00','1998-03-19 00:00:00','1998-02-27 00:00:00',3,32.45,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10897,'HUNGO',3,'1998-02-19 00:00:00','1998-03-19 00:00:00','1998-02-25 00:00:00',2,603.54,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10900,'WELLI',1,'1998-02-20 00:00:00','1998-03-20 00:00:00','1998-03-04 00:00:00',2,1.66,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10904,'WHITC',3,'1998-02-24 00:00:00','1998-03-24 00:00:00','1998-02-27 00:00:00',3,162.95,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(10905,'WELLI',9,'1998-02-24 00:00:00','1998-03-24 00:00:00','1998-03-06 00:00:00',2,13.72,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10906,'WOLZA',4,'1998-02-25 00:00:00','1998-03-11 00:00:00','1998-03-03 00:00:00',3,26.29,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(10908,'REGGC',4,'1998-02-26 00:00:00','1998-03-26 00:00:00','1998-03-06 00:00:00',2,32.96,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10910,'WILMK',1,'1998-02-26 00:00:00','1998-03-26 00:00:00','1998-03-04 00:00:00',3,38.11,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(10912,'HUNGO',2,'1998-02-26 00:00:00','1998-03-26 00:00:00','1998-03-18 00:00:00',2,580.91,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10916,'RANCH',1,'1998-02-27 00:00:00','1998-03-27 00:00:00','1998-03-09 00:00:00',2,63.77,'Rancho grande','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina',NULL),(10918,'BOTTM',3,'1998-03-02 00:00:00','1998-03-30 00:00:00','1998-03-11 00:00:00',3,48.83,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10919,'LINOD',2,'1998-03-02 00:00:00','1998-03-30 00:00:00','1998-03-04 00:00:00',2,19.8,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10920,'AROUT',4,'1998-03-03 00:00:00','1998-03-31 00:00:00','1998-03-09 00:00:00',2,29.61,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10923,'LAMAI',7,'1998-03-03 00:00:00','1998-04-14 00:00:00','1998-03-13 00:00:00',3,68.26,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(10927,'LACOR',4,'1998-03-05 00:00:00','1998-04-02 00:00:00','1998-04-08 00:00:00',1,19.79,'La corne d\'abondance','67, avenue de l\'Europe','Versailles',NULL,'78000','France',NULL),(10932,'BONAP',8,'1998-03-06 00:00:00','1998-04-03 00:00:00','1998-03-24 00:00:00',1,134.64,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10933,'ISLAT',6,'1998-03-06 00:00:00','1998-04-03 00:00:00','1998-03-16 00:00:00',3,54.15,'Island Trading','Garden House\nCrowther Way','Cowes','Isle of Wight','PO31 7PJ','UK',NULL),(10934,'LEHMS',3,'1998-03-09 00:00:00','1998-04-06 00:00:00','1998-03-12 00:00:00',3,32.01,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(10935,'WELLI',4,'1998-03-09 00:00:00','1998-04-06 00:00:00','1998-03-18 00:00:00',3,47.59,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil',NULL),(10936,'GREAL',3,'1998-03-09 00:00:00','1998-04-06 00:00:00','1998-03-18 00:00:00',2,33.68,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(10937,'CACTU',7,'1998-03-10 00:00:00','1998-03-24 00:00:00','1998-03-13 00:00:00',3,31.51,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(10939,'MAGAA',2,'1998-03-10 00:00:00','1998-04-07 00:00:00','1998-03-13 00:00:00',2,76.33,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10940,'BONAP',8,'1998-03-11 00:00:00','1998-04-08 00:00:00','1998-03-23 00:00:00',3,19.77,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(10941,'SAVEA',7,'1998-03-11 00:00:00','1998-04-08 00:00:00','1998-03-20 00:00:00',2,400.81,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10942,'REGGC',9,'1998-03-11 00:00:00','1998-04-08 00:00:00','1998-03-18 00:00:00',3,17.95,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(10943,'BSBEV',4,'1998-03-11 00:00:00','1998-04-08 00:00:00','1998-03-19 00:00:00',2,2.17,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10944,'BOTTM',6,'1998-03-12 00:00:00','1998-03-26 00:00:00','1998-03-13 00:00:00',3,52.92,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10945,'MORGK',4,'1998-03-12 00:00:00','1998-04-09 00:00:00','1998-03-18 00:00:00',1,10.22,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',NULL,'04179','Germany',NULL),(10947,'BSBEV',3,'1998-03-13 00:00:00','1998-04-10 00:00:00','1998-03-16 00:00:00',2,3.26,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(10949,'BOTTM',2,'1998-03-13 00:00:00','1998-04-10 00:00:00','1998-03-17 00:00:00',3,74.44,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10950,'MAGAA',1,'1998-03-16 00:00:00','1998-04-13 00:00:00','1998-03-23 00:00:00',2,2.5,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',NULL,'24100','Italy',NULL),(10952,'ALFKI',1,'1998-03-16 00:00:00','1998-04-27 00:00:00','1998-03-24 00:00:00',1,40.42,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(10953,'AROUT',9,'1998-03-16 00:00:00','1998-03-30 00:00:00','1998-03-25 00:00:00',2,23.72,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(10954,'LINOD',5,'1998-03-17 00:00:00','1998-04-28 00:00:00','1998-03-20 00:00:00',1,27.91,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(10956,'BLAUS',6,'1998-03-17 00:00:00','1998-04-28 00:00:00','1998-03-20 00:00:00',2,44.65,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(10959,'GOURL',6,'1998-03-18 00:00:00','1998-04-29 00:00:00','1998-03-23 00:00:00',2,4.98,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(10963,'FURIB',9,'1998-03-19 00:00:00','1998-04-16 00:00:00','1998-03-26 00:00:00',3,2.7,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',NULL,'1675','Portugal',NULL),(10965,'OLDWO',6,'1998-03-20 00:00:00','1998-04-17 00:00:00','1998-03-30 00:00:00',3,144.38,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(10966,'CHOPS',4,'1998-03-20 00:00:00','1998-04-17 00:00:00','1998-04-08 00:00:00',1,27.19,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(10968,'ERNSH',1,'1998-03-23 00:00:00','1998-04-20 00:00:00','1998-04-01 00:00:00',3,74.6,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10971,'FRANR',2,'1998-03-24 00:00:00','1998-04-21 00:00:00','1998-04-02 00:00:00',2,121.82,'France restauration','54, rue Royale','Nantes',NULL,'44000','France',NULL),(10972,'LACOR',4,'1998-03-24 00:00:00','1998-04-21 00:00:00','1998-03-26 00:00:00',2,0.02,'La corne d\'abondance','67, avenue de l\'Europe','Versailles',NULL,'78000','France',NULL),(10973,'LACOR',6,'1998-03-24 00:00:00','1998-04-21 00:00:00','1998-03-27 00:00:00',2,15.17,'La corne d\'abondance','67, avenue de l\'Europe','Versailles',NULL,'78000','France',NULL),(10974,'SPLIR',3,'1998-03-25 00:00:00','1998-04-08 00:00:00','1998-04-03 00:00:00',3,12.96,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA',NULL),(10975,'BOTTM',1,'1998-03-25 00:00:00','1998-04-22 00:00:00','1998-03-27 00:00:00',3,32.27,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10978,'MAISD',9,'1998-03-26 00:00:00','1998-04-23 00:00:00','1998-04-23 00:00:00',2,32.82,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(10979,'ERNSH',8,'1998-03-26 00:00:00','1998-04-23 00:00:00','1998-03-31 00:00:00',2,353.07,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10982,'BOTTM',2,'1998-03-27 00:00:00','1998-04-24 00:00:00','1998-04-08 00:00:00',1,14.01,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(10983,'SAVEA',2,'1998-03-27 00:00:00','1998-04-24 00:00:00','1998-04-06 00:00:00',2,657.54,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10984,'SAVEA',1,'1998-03-30 00:00:00','1998-04-27 00:00:00','1998-04-03 00:00:00',3,211.22,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(10985,'HUNGO',2,'1998-03-30 00:00:00','1998-04-27 00:00:00','1998-04-02 00:00:00',1,91.51,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(10987,'EASTC',8,'1998-03-31 00:00:00','1998-04-28 00:00:00','1998-04-06 00:00:00',1,185.48,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(10988,'RATTC',3,'1998-03-31 00:00:00','1998-04-28 00:00:00','1998-04-10 00:00:00',2,61.14,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(10990,'ERNSH',2,'1998-04-01 00:00:00','1998-05-13 00:00:00','1998-04-07 00:00:00',3,117.61,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(10992,'THEBI',1,'1998-04-01 00:00:00','1998-04-29 00:00:00','1998-04-03 00:00:00',3,4.27,'The Big Cheese','89 Jefferson Way\nSuite 2','Portland','OR','97201','USA',NULL),(10998,'WOLZA',8,'1998-04-03 00:00:00','1998-04-17 00:00:00','1998-04-17 00:00:00',2,20.31,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(11000,'RATTC',2,'1998-04-06 00:00:00','1998-05-04 00:00:00','1998-04-14 00:00:00',3,55.12,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL),(11002,'SAVEA',4,'1998-04-06 00:00:00','1998-05-04 00:00:00','1998-04-16 00:00:00',1,141.16,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(11003,'THECR',3,'1998-04-06 00:00:00','1998-05-04 00:00:00','1998-04-08 00:00:00',3,14.91,'The Cracker Box','55 Grizzly Peak Rd.','Butte','MT','59801','USA',NULL),(11004,'MAISD',3,'1998-04-07 00:00:00','1998-05-05 00:00:00','1998-04-20 00:00:00',1,44.84,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',NULL,'B-1180','Belgium',NULL),(11005,'WILMK',2,'1998-04-07 00:00:00','1998-05-05 00:00:00','1998-04-10 00:00:00',1,0.75,'Wilman Kala','Keskuskatu 45','Helsinki',NULL,'21240','Finland',NULL),(11006,'GREAL',3,'1998-04-07 00:00:00','1998-05-05 00:00:00','1998-04-15 00:00:00',2,25.19,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(11008,'ERNSH',7,'1998-04-08 00:00:00','1998-05-06 00:00:00',NULL,3,79.46,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(11010,'REGGC',2,'1998-04-09 00:00:00','1998-05-07 00:00:00','1998-04-21 00:00:00',2,28.71,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(11011,'ALFKI',3,'1998-04-09 00:00:00','1998-05-07 00:00:00','1998-04-13 00:00:00',1,1.21,'Alfreds Futterkiste','Obere Str. 57','Berlin',NULL,'12209','Germany',NULL),(11014,'LINOD',2,'1998-04-10 00:00:00','1998-05-08 00:00:00','1998-04-15 00:00:00',3,23.6,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(11016,'AROUT',9,'1998-04-10 00:00:00','1998-05-08 00:00:00','1998-04-13 00:00:00',2,33.8,'Around the Horn','Brook Farm\nStratford St. Mary','Colchester','Essex','CO7 6JX','UK',NULL),(11017,'ERNSH',9,'1998-04-13 00:00:00','1998-05-11 00:00:00','1998-04-20 00:00:00',2,754.26,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(11018,'LONEP',4,'1998-04-13 00:00:00','1998-05-11 00:00:00','1998-04-16 00:00:00',2,11.65,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA',NULL),(11019,'RANCH',6,'1998-04-13 00:00:00','1998-05-11 00:00:00',NULL,3,3.17,'Rancho grande','Av. del Libertador 900','Buenos Aires',NULL,'1010','Argentina',NULL),(11023,'BSBEV',1,'1998-04-14 00:00:00','1998-04-28 00:00:00','1998-04-24 00:00:00',2,123.83,'B\'s Beverages','Fauntleroy Circus','London',NULL,'EC2 5NT','UK',NULL),(11024,'EASTC',4,'1998-04-15 00:00:00','1998-05-13 00:00:00','1998-04-20 00:00:00',1,74.36,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(11025,'WARTH',6,'1998-04-15 00:00:00','1998-05-13 00:00:00','1998-04-24 00:00:00',3,29.17,'Wartian Herkku','Torikatu 38','Oulu',NULL,'90110','Finland',NULL),(11026,'FRANS',4,'1998-04-15 00:00:00','1998-05-13 00:00:00','1998-04-28 00:00:00',1,47.09,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(11027,'BOTTM',1,'1998-04-16 00:00:00','1998-05-14 00:00:00','1998-04-20 00:00:00',1,52.52,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(11029,'CHOPS',4,'1998-04-16 00:00:00','1998-05-14 00:00:00','1998-04-27 00:00:00',1,47.84,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(11030,'SAVEA',7,'1998-04-17 00:00:00','1998-05-15 00:00:00','1998-04-27 00:00:00',2,830.75,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(11031,'SAVEA',6,'1998-04-17 00:00:00','1998-05-15 00:00:00','1998-04-24 00:00:00',2,227.22,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(11032,'WHITC',2,'1998-04-17 00:00:00','1998-05-15 00:00:00','1998-04-23 00:00:00',3,606.19,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(11034,'OLDWO',8,'1998-04-20 00:00:00','1998-06-01 00:00:00','1998-04-27 00:00:00',1,40.32,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA',NULL),(11036,'DRACD',8,'1998-04-20 00:00:00','1998-05-18 00:00:00','1998-04-22 00:00:00',3,149.47,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(11039,'LINOD',1,'1998-04-21 00:00:00','1998-05-19 00:00:00',NULL,2,65,'LINO-Delicateses','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela',NULL),(11040,'GREAL',4,'1998-04-22 00:00:00','1998-05-20 00:00:00',NULL,3,18.84,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(11041,'CHOPS',3,'1998-04-22 00:00:00','1998-05-20 00:00:00','1998-04-28 00:00:00',2,48.22,'Chop-suey Chinese','Hauptstr. 31','Bern',NULL,'3012','Switzerland',NULL),(11044,'WOLZA',4,'1998-04-23 00:00:00','1998-05-21 00:00:00','1998-05-01 00:00:00',1,8.72,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',NULL,'01-012','Poland',NULL),(11045,'BOTTM',6,'1998-04-23 00:00:00','1998-05-21 00:00:00',NULL,2,70.58,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(11046,'WANDK',8,'1998-04-23 00:00:00','1998-05-21 00:00:00','1998-04-24 00:00:00',2,71.64,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',NULL,'70563','Germany',NULL),(11047,'EASTC',7,'1998-04-24 00:00:00','1998-05-22 00:00:00','1998-05-01 00:00:00',3,46.62,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(11048,'BOTTM',7,'1998-04-24 00:00:00','1998-05-22 00:00:00','1998-04-30 00:00:00',3,24.12,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada',NULL),(11049,'GOURL',3,'1998-04-24 00:00:00','1998-05-22 00:00:00','1998-05-04 00:00:00',1,8.34,'Gourmet Lanchonetes','Av. Brasil, 442','Campinas','SP','04876-786','Brazil',NULL),(11051,'LAMAI',7,'1998-04-27 00:00:00','1998-05-25 00:00:00',NULL,3,2.79,'La maison d\'Asie','1 rue Alsace-Lorraine','Toulouse',NULL,'31000','France',NULL),(11053,'PICCO',2,'1998-04-27 00:00:00','1998-05-25 00:00:00','1998-04-29 00:00:00',2,53.05,'Piccolo und mehr','Geislweg 14','Salzburg',NULL,'5020','Austria',NULL),(11054,'CACTU',8,'1998-04-28 00:00:00','1998-05-26 00:00:00',NULL,1,0.33,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',NULL,'1010','Argentina',NULL),(11056,'EASTC',8,'1998-04-28 00:00:00','1998-05-12 00:00:00','1998-05-01 00:00:00',2,278.96,'Eastern Connection','35 King George','London',NULL,'WX3 6FW','UK',NULL),(11057,'NORTS',3,'1998-04-29 00:00:00','1998-05-27 00:00:00','1998-05-01 00:00:00',3,4.13,'North/South','South House\n300 Queensbridge','London',NULL,'SW7 1RZ','UK',NULL),(11058,'BLAUS',9,'1998-04-29 00:00:00','1998-05-27 00:00:00',NULL,3,31.14,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',NULL,'68306','Germany',NULL),(11059,'RICAR',2,'1998-04-29 00:00:00','1998-06-10 00:00:00',NULL,2,85.8,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil',NULL),(11060,'FRANS',2,'1998-04-30 00:00:00','1998-05-28 00:00:00','1998-05-04 00:00:00',2,10.98,'Franchi S.p.A.','Via Monte Bianco 34','Torino',NULL,'10100','Italy',NULL),(11061,'GREAL',4,'1998-04-30 00:00:00','1998-06-11 00:00:00',NULL,3,14.01,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA',NULL),(11062,'REGGC',4,'1998-04-30 00:00:00','1998-05-28 00:00:00',NULL,2,29.93,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',NULL,'42100','Italy',NULL),(11063,'HUNGO',3,'1998-04-30 00:00:00','1998-05-28 00:00:00','1998-05-06 00:00:00',2,81.73,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',NULL,'Ireland',NULL),(11064,'SAVEA',1,'1998-05-01 00:00:00','1998-05-29 00:00:00','1998-05-04 00:00:00',1,30.09,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA',NULL),(11066,'WHITC',7,'1998-05-01 00:00:00','1998-05-29 00:00:00','1998-05-04 00:00:00',2,44.72,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA',NULL),(11067,'DRACD',1,'1998-05-04 00:00:00','1998-05-18 00:00:00','1998-05-06 00:00:00',2,7.98,'Drachenblut Delikatessen','Walserweg 21','Aachen',NULL,'52066','Germany',NULL),(11070,'LEHMS',2,'1998-05-05 00:00:00','1998-06-02 00:00:00',NULL,1,136,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M. ',NULL,'60528','Germany',NULL),(11072,'ERNSH',4,'1998-05-05 00:00:00','1998-06-02 00:00:00',NULL,2,258.64,'Ernst Handel','Kirchgasse 6','Graz',NULL,'8010','Austria',NULL),(11076,'BONAP',4,'1998-05-06 00:00:00','1998-06-03 00:00:00',NULL,2,38.28,'Bon app','12, rue des Bouchers','Marseille',NULL,'13008','France',NULL),(11077,'RATTC',1,'1998-05-06 00:00:00','1998-06-03 00:00:00',NULL,2,8.53,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA',NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `ProductID` int NOT NULL AUTO_INCREMENT,
  `ProductName` varchar(40) NOT NULL,
  `SupplierID` int NOT NULL,
  `CategoryID` int NOT NULL,
  `QuantityPerUnit` varchar(20) DEFAULT NULL,
  `UnitPrice` float DEFAULT '0',
  `UnitsInStock` smallint DEFAULT '0',
  `UnitsOnOrder` smallint DEFAULT '0',
  `ReorderLevel` smallint DEFAULT '0',
  `Discontinued` tinyint NOT NULL DEFAULT '0',
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ProductID`),
  KEY `CategoryID` (`CategoryID`),
  KEY `SupplierID` (`SupplierID`),
  KEY `ProductName` (`ProductName`),
  CONSTRAINT `products_ibfk_1` FOREIGN KEY (`CategoryID`) REFERENCES `categories` (`CategoryID`),
  CONSTRAINT `products_ibfk_2` FOREIGN KEY (`SupplierID`) REFERENCES `suppliers` (`SupplierID`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `products` VALUES (1,'Chai',1,1,'10 boxes x 20 bags',18,39,0,10,0,NULL),(2,'Chang',1,1,'24 - 12 oz bottles',19,17,40,25,0,NULL),(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10,13,70,25,0,NULL),(4,'Chef Anton\'s Cajun Seasoning',2,2,'48 - 6 oz jars',22,53,0,0,0,NULL),(5,'Chef Anton\'s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1,NULL),(6,'Grandma\'s Boysenberry Spread',3,2,'12 - 8 oz jars',25,120,0,25,0,NULL),(7,'Uncle Bob\'s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30,15,0,10,0,NULL),(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40,6,0,0,0,NULL),(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97,29,0,0,1,NULL),(10,'Ikura',4,8,'12 - 200 ml jars',31,31,0,0,0,NULL),(11,'Queso Cabrales',5,4,'1 kg pkg.',21,22,30,30,0,NULL),(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38,86,0,0,0,NULL),(13,'Konbu',6,8,'2 kg box',6,24,0,5,0,NULL),(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25,35,0,0,0,NULL),(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5,39,0,5,0,NULL),(16,'Pavlova',7,3,'32 - 500 g boxes',17.45,29,0,10,0,NULL),(17,'Alice Mutton',7,6,'20 - 1 kg tins',39,0,0,0,1,NULL),(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5,42,0,0,0,NULL),(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2,25,0,5,0,NULL),(20,'Sir Rodney\'s Marmalade',8,3,'30 gift boxes',81,40,0,0,0,NULL),(21,'Sir Rodney\'s Scones',8,3,'24 pkgs. x 4 pieces',10,3,40,5,0,NULL),(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9,49,0,30,0,NULL),(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89,10,0,15,0,NULL),(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5,0,70,20,0,NULL),(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32,9,40,25,0,NULL),(33,'Geitost',15,4,'500 g',2.5,112,0,20,0,NULL),(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14,111,0,15,0,NULL),(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18,20,0,15,0,NULL),(36,'Inlagd Sill',17,8,'24 - 250 g  jars',19,112,0,20,0,NULL),(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26,11,50,25,0,NULL),(39,'Chartreuse verte',18,1,'750 cc per bottle',18,69,0,5,0,NULL),(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4,123,0,30,0,NULL),(41,'Jack\'s New England Clam Chowder',19,8,'12 - 12 oz cans',9.65,85,0,10,0,NULL),(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14,26,0,0,1,NULL),(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46,17,10,25,0,NULL),(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45,27,0,15,0,NULL),(46,'Spegesild',21,8,'4 - 450 g glasses',12,95,0,0,0,NULL),(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5,36,0,0,0,NULL),(48,'Chocolade',22,3,'10 pkgs.',12.75,15,70,25,0,NULL),(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20,10,60,15,0,NULL),(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25,65,0,30,0,NULL),(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53,20,0,10,0,NULL),(52,'Filo Mix',24,5,'16 - 2 kg boxes',7,38,0,25,0,NULL),(53,'Perth Pasties',24,6,'48 pieces',32.8,0,0,0,1,NULL),(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38,21,10,30,0,NULL),(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5,36,0,20,0,NULL),(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25,62,0,20,0,NULL),(59,'Raclette Courdavault',28,4,'5 kg pkg.',55,79,0,0,0,NULL),(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34,19,0,0,0,NULL),(62,'Tarte au sucre',29,3,'48 pies',49.3,17,0,0,0,NULL),(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9,24,0,5,0,NULL),(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05,76,0,0,0,NULL),(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17,4,100,20,0,NULL),(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14,52,0,10,0,NULL),(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5,6,10,15,0,NULL),(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36,26,0,15,0,NULL),(70,'Outback Lager',7,1,'24 - 355 ml bottles',15,15,10,30,0,NULL),(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8,14,0,0,0,NULL),(74,'Longlife Tofu',4,7,'5 kg pkg.',10,4,20,5,0,NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shippers` (
  `ShipperID` int NOT NULL AUTO_INCREMENT,
  `CompanyName` varchar(40) NOT NULL,
  `Phone` varchar(24) DEFAULT NULL,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`ShipperID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `shippers` VALUES (1,'Speedy Express','(503) 555-9831',NULL),(2,'United Package','(503) 555-3199',NULL),(3,'Federal Shipping','(503) 555-9931',NULL);
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppliers` (
  `SupplierID` int NOT NULL AUTO_INCREMENT,
  `CompanyName` varchar(40) NOT NULL,
  `ContactName` varchar(30) DEFAULT NULL,
  `ContactTitle` varchar(30) DEFAULT NULL,
  `Address` varchar(60) DEFAULT NULL,
  `City` varchar(15) DEFAULT NULL,
  `Region` varchar(15) DEFAULT NULL,
  `PostalCode` varchar(10) DEFAULT NULL,
  `Country` varchar(15) DEFAULT NULL,
  `Phone` varchar(24) DEFAULT NULL,
  `Fax` varchar(24) DEFAULT NULL,
  `HomePage` varchar(50) DEFAULT NULL,
  `Timestamp` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`SupplierID`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
INSERT INTO `suppliers` VALUES (1,'Exotic Liquids','Charlotte Cooper','Purchasing Manager','49 Gilbert St.','London',NULL,'EC1 4SD','UK','(171) 555-2222',NULL,NULL,NULL),(2,'New Orleans Cajun Delights','Shelley Burke','Order Administrator','P.O. Box 78934','New Orleans','LA','70117','USA','(100) 555-4822',NULL,NULL,NULL),(3,'Grandma Kelly\'s Homestead','Regina Murphy','Sales Representative','707 Oxford Rd.','Ann Arbor','MI','48104','USA','(313) 555-5735','(313) 555-3349',NULL,NULL),(4,'Tokyo Traders','Yoshi Nagase','Marketing Manager','9-8 Sekimai\nMusashino-shi','Tokyo',NULL,'100','Japan','(03) 3555-5011',NULL,NULL,NULL),(5,'Cooperativa de Quesos \'Las Cabras\'','Antonio del Valle Saavedra ','Export Administrator','Calle del Rosal 4','Oviedo','Asturias','33007','Spain','(98) 598 76 54',NULL,NULL,NULL),(6,'Mayumi\'s','Mayumi Ohno','Marketing Representative','92 Setsuko\nChuo-ku','Osaka',NULL,'545','Japan','(06) 431-7877',NULL,'Mayumi\'s (on the World Wide Web)#http://www.micros',NULL),(7,'Pavlova, Ltd.','Ian Devling','Marketing Manager','74 Rose St.\nMoonie Ponds','Melbourne','Victoria','3058','Australia','(03) 444-2343','(03) 444-6588',NULL,NULL),(8,'Specialty Biscuits, Ltd.','Peter Wilson','Sales Representative','29 King\'s Way','Manchester',NULL,'M14 GSD','UK','(161) 555-4448',NULL,NULL,NULL),(13,'Nord-Ost-Fisch Handelsgesellschaft mbH','Sven Petersen','Coordinator Foreign Markets','Frahmredder 112a','Cuxhaven',NULL,'27478','Germany','(04721) 8713','(04721) 8714',NULL,NULL),(14,'Formaggi Fortini s.r.l.','Elio Rossi','Sales Representative','Viale Dante, 75','Ravenna',NULL,'48100','Italy','(0544) 60323','(0544) 60603',NULL,NULL),(15,'Norske Meierier','Beate Vileid','Marketing Manager','Hatlevegen 5','Sandvika',NULL,'1320','Norway','(0)2-953010',NULL,NULL,NULL),(16,'Bigfoot Breweries','Cheryl Saylor','Regional Account Rep.','3400 - 8th Avenue\nSuite 210','Bend','OR','97101','USA','(503) 555-9931',NULL,NULL,NULL),(19,'New England Seafood Cannery','Robb Merchant','Wholesale Account Agent','Order Processing Dept.\n2100 Paul Revere Blvd.','Boston','MA','02134','USA','(617) 555-3267','(617) 555-3389',NULL,NULL),(20,'Leka Trading','Chandra Leka','Owner','471 Serangoon Loop, Suite #402','Singapore',NULL,'0512','Singapore','555-8787',NULL,NULL,NULL),(21,'Lyngbysild','Niels Petersen','Sales Manager','Lyngbysild\nFiskebakken 10','Lyngby',NULL,'2800','Denmark','43844108','43844115',NULL,NULL),(22,'Zaanse Snoepfabriek','Dirk Luchte','Accounting Manager','Verkoop\nRijnweg 22','Zaandam',NULL,'9999 ZZ','Netherlands','(12345) 1212','(12345) 1210',NULL,NULL),(23,'Karkki Oy','Anne Heikkonen','Product Manager','Valtakatu 12','Lappeenranta',NULL,'53120','Finland','(953) 10956',NULL,NULL,NULL),(24,'G\'day, Mate','Wendy Mackenzie','Sales Representative','170 Prince Edward Parade\nHunter\'s Hill','Sydney','NSW','2042','Australia','(02) 555-5914','(02) 555-4873','G\'day Mate (on the World Wide Web)#http://www.micr',NULL),(26,'Pasta Buttini s.r.l.','Giovanni Giudici','Order Administrator','Via dei Gelsomini, 153','Salerno',NULL,'84100','Italy','(089) 6547665','(089) 6547667',NULL,NULL),(27,'Escargots Nouveaux','Marie Delamare','Sales Manager','22, rue H. Voiron','Montceau',NULL,'71300','France','85.57.00.07',NULL,NULL,NULL);
/*!50001 DROP TABLE IF EXISTS `nwib_by_continent`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`pietari`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `nwib_by_continent` AS select `o`.`OrderDate` AS `orderdate`,`d`.`Quantity` AS `quantity`,`c`.`Continent` AS `continent` from ((`orders` `o` join `orderdetails` `d` on((`o`.`OrderID` = `d`.`OrderID`))) join `world`.`country` `c` on((`o`.`ShipCountry` = `c`.`Name`))) where (`c`.`Continent` in ('Africa','Asia','Europe','North America','South America')) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

Last updated 21 May 2020


Return to the Artful MySQL Tips page