INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Notes,OrderDate) VALUES (1,'Chai Tea',1,1,'10 boxes x 20 bags',18.0000,39,-7,10,' ','2001-12-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Notes) VALUES (2,'Changie',1,1,'24 - 12 oz bottles',0.0000,17,40,25,'Array');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Notes,OrderDate) VALUES (3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10.0000,13,70,25,'Array','1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,Notes,OrderDate) VALUES (4,'Chef Anton',2,2,'48 - 6 oz jars',21.0000,53,-60,'Array','1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,Discontinued,OrderDate) VALUES (5,'Chef Anton\'s Sugar',2,2,'36 boxes',21.3500,20,-20,1,'1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel,Notes,OrderDate) VALUES (6,'Grandma\'s Boysenberry Spread',3,2,'12 - 8 oz jars',25.0000,120,25,'oy','1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (7,'Uncle Bob\'s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30.0000,15,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Notes,OrderDate) VALUES (8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40.0000,6,' ','2012-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Discontinued) VALUES (9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97.0000,29,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (10,'Ikura',4,8,'12 - 200 ml jars',31.0000,31);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Notes,OrderDate) VALUES (11,'Queso Cabrales',5,4,'1 kg pkg.',21.0000,22,30,30,' ','2011-12-21');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38.0000,86);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (13,'Konbu',6,8,'2 kg box',6.0000,24,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (14,'Tofu',6,7,'40 - 100 g pkgs.',23.2500,35);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5000,39,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (16,'Pavlova',7,3,'32 - 500 g boxes',17.4500,29,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,Discontinued) VALUES (17,'Alice Mutton',7,6,'20 - 1 kg tins',39.0000,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5000,42);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2000,25,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (20,'Sir Rodney\'s Marmalade',8,3,'30 gift boxes',81.0000,40);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Notes,OrderDate) VALUES (21,'Sir Rodney\'s Scones',8,3,'24 pkgs. x 4 pieces',10.0000,3,40,5,' ','2000-01-30');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (22,'Gustaf\'s Knckebrd',9,5,'24 - 500 g pkgs.',21.0000,104,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (23,'Tunnbrd',9,5,'12 - 250 g pkgs.',9.0000,61,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Discontinued) VALUES (24,'Guaran Fantstica',10,1,'12 - 355 ml cans',4.5000,20,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (25,'NuNuCa Nu-Nougat-Creme',11,3,'20 - 450 g glasses',14.0000,76,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (26,'Gumbr Gummibrchen',11,3,'100 - 250 g bags',31.2300,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9000,49,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Discontinued) VALUES (28,'Rssle Sauerkraut',12,7,'25 - 825 g cans',45.6000,26,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,Discontinued) VALUES (29,'Thringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.7900,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.8900,10,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsOnOrder,ReorderLevel,Notes,OrderDate) VALUES (31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.6000,70,20,' ','2001-03-12');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32.0000,9,40,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (33,'Geitost',15,4,'500 g',2.5000,112,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14.0000,111,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18.0000,20,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (36,'Inlagd Sill',17,8,'24 - 250 g  jars',19.0000,112,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (37,'Gravad lax',17,8,'12 - 500 g pkgs.',26.0000,11,50,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (38,'Cte de Blaye',18,1,'12 - 75 cl bottles',263.5000,17,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (39,'Chartreuse verte',18,1,'750 cc per bottle',18.0000,69,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4000,123,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (41,'Jack\'s New England Clam Chowder',19,8,'12 - 12 oz cans',9.6500,85,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Discontinued) VALUES (42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14.0000,26,1);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (43,'Ipoh Coffee',20,1,'16 - 500 g tins',46.0000,17,10,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (44,'Gula Malacca',20,2,'20 - 2 kg bags',19.4500,27,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (45,'Rgede sild',21,8,'1k pkg.',9.5000,5,70,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (46,'Spegesild',21,8,'4 - 450 g glasses',12.0000,95);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5000,36);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (48,'Chocolade',22,3,'10 pkgs.',12.7500,15,70,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (49,'Maxilaku',23,3,'24 - 50 g pkgs.',20.0000,10,60,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.2500,65,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53.0000,20,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (52,'Filo Mix',24,5,'16 - 2 kg boxes',7.0000,38,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,Discontinued,Notes,OrderDate) VALUES (53,'Perth Pasties',24,6,'48 pieces',32.8000,1,' ','2000-01-10');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (54,'Tourtire',25,6,'16 pies',7.4500,21,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (55,'Pt chinois',25,6,'24 boxes x 2 pies',24.0000,115,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38.0000,21,10,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5000,36,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (58,'Escargots de Bourgogne',27,8,'24 pieces',13.2500,62,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (59,'Raclette Courdavault',28,4,'5 kg pkg.',55.0000,79);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34.0000,19);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (61,'Sirop d\'rable',29,2,'24 - 500 ml bottles',28.5000,113,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (62,'Tarte au sucre',29,3,'48 pies',49.3000,17);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (63,'Vegie-spread',7,2,'15 - 625 g jars',43.9000,24,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (64,'Wimmers gute Semmelkndel',12,5,'20 bags x 4 pieces',33.2500,22,80,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.0500,76);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17.0000,4,100,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14.0000,52,10);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5000,6,10,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36.0000,26,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (70,'Outback Lager',7,1,'24 - 355 ml bottles',15.0000,15,10,30);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (71,'Fltemysost',15,4,'10 - 500 g pkgs.',21.5000,26);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock) VALUES (72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8000,14);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (73,'Rd Kaviar',17,8,'24 - 150 g jars',15.0000,101,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel) VALUES (74,'Longlife Tofu',4,7,'5 kg pkg.',10.0000,4,20,5);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (75,'Rhnbru Klosterbier',12,1,'24 - 0.5 l bottles',7.7500,125,25);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (76,'Lakkalikri',23,1,'500 ml',18.0000,57,20);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,ReorderLevel) VALUES (77,'Original Frankfurter grne Soe',12,2,'12 boxes',13.0000,32,15);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,UnitPrice,UnitsInStock,OrderDate) VALUES (81,'A Product 4',2,2,0.0000,4599,'1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,UnitPrice) VALUES (83,'A Product BB',1,1,0.0000);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,UnitPrice) VALUES (84,'A Product CC',1,1,0.0000);
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,OrderDate) VALUES (86,'Bad tea',1,1,'10',0.0000,'1970-01-01');
INSERT INTO products (ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,Notes) VALUES (89,'PROD-AGFF',1,1,'10',0.0000,33,'Some notes');