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');
