drop table if exists clients;
drop table if exists commandes;

CREATE TABLE IF NOT EXISTS clients (
  pk_client varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  Societe varchar(40) CHARACTER SET utf8 DEFAULT NULL,
  Contact varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Fonction varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Adresse varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Ville varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Region varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  CodePostal varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Pays varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Telephone varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  Fax varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY(pk_client)
) ENGINE=InnoDB;

CREATE TABLE IF NOT EXISTS commandes (
  pk_commande int(10) NOT NULL AUTO_INCREMENT,
  fk_client varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  NumEmploye int(11) DEFAULT NULL,
  DateCommande date DEFAULT NULL,
  LivrerAvant date DEFAULT NULL,
  DateEnvoi date DEFAULT NULL,
  NumMessager int(11) DEFAULT NULL,
  Port float DEFAULT NULL,
  Destinataire varchar(40) DEFAULT NULL,
  PRIMARY KEY(pk_commande) 
) ENGINE=InnoDB;

INSERT INTO clients (pk_client, Societe, Contact, Fonction, Adresse, Ville, Region, CodePostal, Pays, Telephone, Fax) VALUES
('ALFKI', 'Alfreds Futterkiste', 'Maria Anders', 'Représentant(e)', 'Obere Str. 57', 'Berlin', NULL, '12209', 'Allemagne', '030-0074321', '030-0076545'),
('ANATR', 'Ana Trujillo Emparedados y helados', 'Ana Trujillo', 'Propriétaire', 'Avda. de la Constitución 2222', 'México D.F.', NULL, '05021', 'Mexique', '(5) 555-4729', '(5) 555-3745'),
('ANTON', 'Antonio Moreno Taquería', 'Antonio Moreno', 'Propriétaire', 'Mataderos  2312', 'México D.F.', NULL, '05023', 'Mexique', '(5) 555-3932', NULL),
('AROUT', 'Around the Horn', 'Thomas Hardy', 'Représentant(e)', '120 Hanover Sq.', 'London', NULL, 'WA1 1DP', 'Royaume-Uni', '(71) 555-7788', '(71) 555-6750'),
('BERGS', 'Berglunds snabbköp', 'Christina Berglund', 'Acheteur', 'Berguvsvägen  8', 'Luleå', NULL, 'S-958 22', 'Suède', '0921-12 34 65', '0921-12 34 67'),
('BLAUS', 'Blauer See Delikatessen', 'Hanna Moos', 'Représentant(e)', 'Forsterstr. 57', 'Mannheim', NULL, '68306', 'Allemagne', '0621-08460', '0621-08924'),
('BLONP', 'EU_societe', 'Frédérique Citeaux', 'Directeur du marketing', '24, place Kléber', 'Strasbourg', NULL, '67000', 'EU', '03.88.60.15.31', '03.88.60.15.32'),
('BONAP', 'Bon app', 'Laurence Lebihan', 'Propriétaire', '12, rue des Bouchers', 'Marseille', NULL, '13008', 'France', '04.91.24.45.40', '04.91.24.45.41'),
('BOTTM', 'Bottom-Dollar Markets', 'Elizabeth Lincoln', 'Chef comptable', '23 Tsawassen Blvd.', 'Tsawassen', 'BC', 'T2F 8M4', 'Canada', '(604) 555-4729', '(604) 555-3745'),
('BSBEV', 'Bs Beverages', 'Victoria Ashworth', 'Représentant(e)', 'Fauntleroy Circus', 'London', NULL, 'EC2 5NT', 'Royaume-Uni', '(71) 555-1212', NULL),
('CACTU', 'Cactus Comidas para llevar', 'Patricio Simpson', 'Assistant(e) des ventes', 'Cerrito 333', 'Buenos Aires', NULL, '1010', 'Argentine', '(1) 135-5555', '(1) 135-4892'),
('CENTC', 'Centro comercial Moctezuma', 'Francisco Chang', 'Directeur du marketing', 'Sierras de Granada 9993', 'México D.F.', NULL, '05022', 'Mexique', '(5) 555-3392', '(5) 555-7293'),
('CHOPS', 'Chop-suey Chinese', 'Yang Wang', 'Propriétaire', 'Hauptstr. 29', 'Bern', NULL, '3012', 'Suisse', '0452-076545', NULL),
('COMMI', 'Comércio Mineiro', 'Pedro Afonso', 'Assistant(e) des ventes', 'Av. dos Lusíadas, 23', 'São Paulo', 'SP', '05432-043', 'Brésil', '(11) 555-7647', NULL),
('CONSH', 'Consolidated Holdings', 'Elizabeth Brown', 'Représentant(e)', 'Berkeley Gardens\r\n12  Brewery', 'London', NULL, 'WX1 6LT', 'Royaume-Uni', '(71) 555-2282', '(71) 555-9199'),
('DRACD', 'Drachenblut Delikatessen', 'Sven Ottlieb', 'Acheteur', 'Walserweg 21', 'Aachen', NULL, '52066', 'Allemagne', '0241-039123', '0241-059428'),
('DUMON', 'Du monde entier', 'Janine Labrune', 'Propriétaire', '67, rue des Cinquante Otages', 'Nantes', NULL, '44000', 'France', '02.40.67.88.88', '02.40.67.89.89'),
('EASTC', 'Eastern Connection', 'Ann Devon', 'Assistant(e) des ventes', '35 King George', 'London', NULL, 'WX3 6FW', 'Royaume-Uni', '(71) 555-0297', '(71) 555-3373'),
('ERNSH', 'Ernst Handel', 'Roland Mendel', 'Chef des ventes', 'Kirchgasse 6', 'Graz', NULL, '8010', 'Autriche', '7675-3425', '7675-3426'),
('FAMIA', 'Familia Arquibaldo', 'Aria Cruz', 'Assistant(e) marketing', 'Rua Orós, 92', 'São Paulo', 'SP', '05442-030', 'Brésil', '(11) 555-9857', NULL),
('FOLIG', 'Folies gourmandes', 'Martine Rancé', 'Représentant(e)', '184, chaussée de Tournai', 'Lille', NULL, '59000', 'France', '03.20.16.10.16', '03.20.16.10.17'),
('FOLKO', 'Folk och fä HB', 'Maria Larsson', 'Propriétaire', 'Åkergatan 24', 'Bräcke', NULL, 'S-844 67', 'Suède', '0695-34 67 21', NULL),
('FRANK', 'Frankenversand', 'Peter Franken', 'Directeur du marketing', 'Berliner Platz 43', 'München', NULL, '80805', 'Allemagne', '089-0877310', '089-0877451'),
('FRANR', 'France restauration', 'Carine Schmitt', 'Directeur du marketing', '54, rue Royale', 'Nantes', NULL, '44000', 'France', '02.40.32.21.21', '02.40.32.21.20'),
('FURIB', 'Furia Bacalhau e Frutos do Mar', 'Lino Rodriguez', 'Chef des ventes', 'Jardim das rosas n. 32', 'Lisboa', NULL, '1675', 'Portugal', '(1) 354-2534', '(1) 354-2535'),
('PICO', 'EU_societe', NULL, NULL, NULL, 'NICE', NULL, NULL, 'EU', NULL, NULL),
('GODOS', 'Godos Cocina Típica', 'José Pedro Freyre', 'Chef des ventes', 'C/ Romero, 33', 'Sevilla', NULL, '41101', 'Espagne', '(95) 555 82 82', NULL),
('GOURL', 'Gourmet Lanchonetes', 'André Fonseca', 'Assistant(e) des ventes', 'Av. Brasil, 442', 'Campinas', 'SP', '04876-786', 'Brésil', '(11) 555-9482', NULL),
('GREAL', 'Great Lakes Food Market', 'Howard Snyder', 'Directeur du marketing', '2732 Baker Blvd.', 'Eugene', 'OR', '97403', 'États-Unis', '(503) 555-7555', NULL),
('GROSR', 'GROSELLA-Restaurante', 'Manuel Pereira', 'Propriétaire', '5ª Ave. Los Palos Grandes', 'Caracas', 'DF', '1081', 'Venezuela', '(2) 283-2951', '(2) 283-3397'),
('HANAR', 'Hanari Carnes', 'Mario Pontes', 'Chef comptable', 'Rua do Paço, 67', 'Rio de Janeiro', 'RJ', '05454-876', 'Brésil', '(21) 555-0091', '(21) 555-8765'),
('HILAA', 'HILARIÓN-Abastos', 'Carlos Hernández', 'Représentant(e)', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristóbal', 'Táchira', '5022', 'Venezuela', '(5) 555-1340', '(5) 555-1948'),
('HUNGC', 'Hungry Coyote Import Store', 'Yoshi Latimer', 'Représentant(e)', 'City Center Plaza\r\n516 Main St.', 'Elgin', 'OR', '97827', 'États-Unis', '(503) 555-6874', '(503) 555-2376'),
('HUNGO', 'Hungry Owl All-Night Grocers', 'Patricia McKenna', 'Assistant(e) des ventes', '8 Johnstown Road', 'Cork', 'Co. Cork', NULL, 'Irlande', '2967 542', '2967 3333'),
('ISLAT', 'Island Trading', 'Helen Bennett', 'Directeur du marketing', 'Garden House\r\nCrowther Way', 'Cowes', 'Isle of Wight', 'PO31 7PJ', 'Royaume-Uni', '(198) 555-8888', NULL),
('KOENE', 'Königlich Essen', 'Philip Cramer', 'Assistant(e) des ventes', 'Maubelstr. 90', 'Brandenburg', NULL, '14776', 'Allemagne', '0555-09876', NULL),
('LACOR', 'La corne dabondance', 'Daniel Tonini', 'Représentant(e)', '67, avenue de lEurope', 'Versailles', NULL, '78000', 'France', '01.30.59.84.10', '01.30.59.85.11'),
('LAMAI', 'La maison dAsie', 'Annette Roulet', 'Chef des ventes', '1 rue Alsace-Lorraine', 'Toulouse', NULL, '31000', 'France', '05.61.77.61.10', '05.61.77.61.11'),
('LAUGB', 'Laughing Bacchus Wine Cellars', 'Yoshi Tannamuri', 'Assistant(e) marketing', '1900 Oak St.', 'Vancouver', 'BC', 'V3F 2K1', 'Canada', '(604) 555-3392', '(604) 555-7293'),
('LAZYK', 'Lazy K Kountry Store', 'John Steel', 'Directeur du marketing', '12 Orchestra Terrace', 'Walla Walla', 'WA', '99362', 'États-Unis', '(509) 555-7969', '(509) 555-6221'),
('LEHMS', 'Lehmanns Marktstand', 'Renate Messner', 'Représentant(e)', 'Magazinweg 7', 'Frankfurt a.M.', NULL, '60528', 'Allemagne', '069-0245984', '069-0245874'),
('LETSS', 'Lets Stop N Shop', 'Jaime Yorres', 'Propriétaire', '87 Polk St.\r\nSuite 5', 'San Francisco', 'CA', '94117', 'États-Unis', '(415) 555-5938', NULL),
('LILAS', 'LILA-Supermercado', 'Carlos González', 'Chef comptable', 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', 'Barquisimeto', 'Lara', '3508', 'Venezuela', '(9) 331-6954', '(9) 331-7256'),
('LINOD', 'LINO-Delicateses', 'Felipe Izquierdo', 'Propriétaire', 'Ave. 5 de Mayo Porlamar', 'I. de Margarita', 'Nueva Esparta', '4980', 'Venezuela', '(8) 34-56-12', '(8) 34-93-93'),
('LONEP', 'Lonesome Pine Restaurant', 'Fran Wilson', 'Chef des ventes', '89 Chiaroscuro Rd.', 'Portland', 'OR', '97219', 'États-Unis', '(503) 555-9573', '(503) 555-9646'),
('MAGAA', 'Magazzini Alimentari Riuniti', 'Giovanni Rovelli', 'Directeur du marketing', 'Via Ludovico il Moro 22', 'Bergamo', NULL, '24100', 'Italie', '035-640230', '035-640231'),
('MAISD', 'Maison Dewey', 'Catherine Dewey', 'Assistant(e) des ventes', 'Rue Joseph-Bens 532', 'Bruxelles', NULL, 'B-1180', 'Belgique', '(02) 201 24 67', '(02) 201 24 68'),
('MEREP', 'Mère Paillarde', 'Jean Fresnière', 'Assistant(e) marketing', '43 rue St. Laurent', 'Montréal', 'Québec', 'H1J 1C3', 'Canada', '(514) 555-8054', '(514) 555-8055'),
('MORGK', 'Morgenstern Gesundkost', 'Alexander Feuer', 'Assistant(e) marketing', 'Heerstr. 22', 'Leipzig', NULL, '04179', 'Allemagne', '0342-023176', NULL),
('NORTS', 'North/South', 'Simon Crowther', 'Assistant(e) des ventes', 'South House\r\n300 Queensbridge', 'London', NULL, 'SW7 1RZ', 'Royaume-Uni', '(71) 555-7733', '(71) 555-2530'),
('OCEAN', 'Océano Atlántico Ltda.', 'Yvonne Moncada', 'Assistant(e) des ventes', 'Ing. Gustavo Moncada 8585\r\nPiso 20-A', 'Buenos Aires', NULL, '1010', 'Argentine', '(1) 135-5333', '(1) 135-5535'),
('OLDWO', 'Old World Delicatessen', 'Rene Phillips', 'Représentant(e)', '2743 Bering St.', 'Anchorage', 'AK', '99508', 'États-Unis', '(907) 555-7584', '(907) 555-2880'),
('OTTIK', 'Ottilies Käseladen', 'Henriette Pfalzheim', 'Propriétaire', 'Mehrheimerstr. 369', 'Köln', NULL, '50739', 'Allemagne', '0221-0644327', '0221-0765721'),
('PARIS', 'Paris spécialités', 'Marie Bertrand', 'Propriétaire', '265, boulevard Charonne', 'Paris', NULL, '75012', 'PaysFrance', '01.42.34.22.66', '01.42.34.22.77'),
('PERIC', 'Pericles Comidas clásicas', 'Guillermo Fernández', 'Représentant(e)', 'Calle Dr. Jorge Cash 321', 'México D.F.', NULL, '05033', 'Mexique', '(5) 552-3745', '(5) 545-3745'),
('PICCO', 'Piccolo und mehr', 'Georg Pipps', 'Chef des ventes', 'Geislweg 14', 'Salzburg', NULL, '5020', 'Autriche', '6562-9722', '6562-9723'),
('PRINI', 'Princesa Isabel Vinhos', 'Isabel de Castro', 'Représentant(e)', 'Estrada da saúde n. 58', 'Lisboa', NULL, '1756', 'Portugal', '(1) 356-5634', NULL),
('QUEDE', 'Que Delícia', 'Bernardo Batista', 'Chef comptable', 'Rua da Panificadora, 12', 'Rio de Janeiro', 'RJ', '02389-673', 'Brésil', '(21) 555-4252', '(21) 555-4545'),
('QUEEN', 'Queen Cozinha', 'Lúcia Carvalho', 'Assistant(e) marketing', 'Alameda dos Canàrios, 891', 'São Paulo', 'SP', '05487-020', 'Brésil', '(11) 555-1189', NULL),
('QUICK', 'QUICK-Stop', 'Horst Kloss', 'Chef comptable', 'Taucherstraße 10', 'Cunewalde', NULL, '01307', 'Allemagne', '0372-035188', NULL),
('RANCH', 'Rancho grande', 'Sergio Gutiérrez', 'Représentant(e)', 'Av. del Libertador 900', 'Buenos Aires', NULL, '1010', 'Argentine', '(1) 123-5555', '(1) 123-5556'),
('RATTC', 'Rattlesnake Canyon Grocery', 'Paula Wilson', 'Représentant(e)', '2817 Milton Dr.', 'Albuquerque', 'NM', '87110', 'États-Unis', '(505) 555-5939', '(505) 555-3620'),
('REGGC', 'Reggiani Caseifici', 'Maurizio Moroni', 'Assistant(e) des ventes', 'Strada Provinciale 124', 'Reggio Emilia', NULL, '42100', 'Italie', '0522-556721', '0522-556722'),
('RICAR', 'Ricardo Adocicados', 'Janete Limeira', 'Représentant(e)', 'Av. Copacabana, 267', 'Rio de Janeiro', 'RJ', '02389-890', 'Brésil', '(21) 555-3412', NULL),
('RICSU', 'Richter Supermarkt', 'Michael Holz', 'Chef des ventes', 'Grenzacherweg 237', 'Genève', NULL, '1203', 'Suisse', '0897-034214', NULL),
('GIE AMT', NULL, NULL, NULL, NULL, 'DRAGUIGNAN2', NULL, NULL, 'FRANCE', NULL, NULL),
('GIE AMT2', NULL, NULL, NULL, NULL, 'ÉTÉ À', NULL, NULL, 'FRANCE', NULL, NULL),
('SANTG', 'Santé Gourmet', 'Jonas Bergulfsen', 'Propriétaire', 'Erling Skakkes gate 78', 'Stavern', NULL, '4110', 'Norvège', '07-98 92 35', '07-98 92 47'),
('SAVEA', 'Save-a-lot Markets', 'Jose Pavarotti', 'Représentant(e)', '187 Suffolk Ln.', 'Boise', 'ID', '83720', 'États-Unis', '(208) 555-8097', NULL),
('SEVES', 'Seven Seas Imports', 'Hari Kumar', 'Chef des ventes', '90 Wadhurst Rd.', 'London', NULL, 'OX15 4NB', 'Royaume-Uni', '(71) 555-1717', '(71) 555-5646'),
('SIMOB', 'Simons bistro', 'Jytte Petersen', 'Propriétaire', 'Vinbæltet 34', 'København', NULL, '1734', 'Danemark', '31 12 34 56', '31 13 35 57'),
('SPECD', 'Spécialités du monde', 'Dominique Perrier', 'Directeur du marketing', '25, rue Lauriston', 'Paris', NULL, '75016', 'PaysFrance', '01.47.55.60.10', '01.47.55.60.20'),
('SPLIR', 'Split Rail Beer & Ale', 'Art Braunschweiger', 'Chef des ventes', 'P.O. Box 555', 'Lander', 'WY', '82520', 'États-Unis', '(307) 555-4680', '(307) 555-6525'),
('SUPRD', 'Suprêmes délices', 'Pascale Cartrain', 'Chef comptable', 'Boulevard Tirou, 255', 'Charleroi', NULL, 'B-6000', 'Belgique', '(071) 23 67 22 20', '(071) 23 67 22 21'),
('THEBI', 'The Big Cheese', 'Liz Nixon', 'Directeur du marketing', '89 Jefferson Way\r\nSuite 2', 'Portland', 'OR', '97201', 'États-Unis', '(503) 555-3612', NULL),
('THECR', 'The Cracker Box', 'Liu Wong', 'Assistant(e) marketing', '55 Grizzly Peak Rd.', 'Butte', 'MT', '59801', 'États-Unis', '(406) 555-5834', '(406) 555-8083'),
('TOMSP', 'Toms Spezialitäten', 'Karin Josephs', 'Directeur du marketing', 'Luisenstr. 48', 'Münster', NULL, '44087', 'Allemagne', '0251-031259', '0251-035695'),
('TORTU', 'Tortuga Restaurante', 'Miguel Angel Paolino', 'Propriétaire', 'Avda. Azteca 123', 'México D.F.', NULL, '05033', 'Mexique', '(5) 555-2933', NULL),
('TRADH', 'Tradição Hipermercados', 'Anabela Domingues', 'Représentant(e)', 'Av. Inês de Castro, 414', 'São Paulo', 'SP', '05634-030', 'Brésil', '(11) 555-2167', '(11) 555-2168'),
('TRAIH', 'Trails Head Gourmet Provisioners', 'Helvetius Nagy', 'Assistant(e) des ventes', '722 DaVinci Blvd.', 'Kirkland', 'WA', '98034', 'États-Unis', '(206) 555-8257', '(206) 555-2174'),
('VAFFE', 'Vaffeljernet', 'Palle Ibsen', 'Chef des ventes', 'Smagsløget 45', 'Århus', NULL, '8200', 'Danemark', '86 21 32 43', '86 22 33 44'),
('VICTE', 'Victuailles en stock', 'Mary Saveley', 'Assistant(e) des ventes', '2, rue du Commerce', 'Lyon', NULL, '69004', 'France', '04.78.32.54.86', '04.78.32.54.87'),
('VINET', 'Vins et alcools Chevalier', 'Paul Henriot', 'Chef comptable', '59 rue de lAbbaye', 'Reims', NULL, '51100', 'France', '03.26.47.15.10', '03.26.47.15.11'),
('WANDK', 'Die Wandernde Kuh', 'Rita Müller', 'Représentant(e)', 'Adenauerallee 900', 'Stuttgart', NULL, '70563', 'Allemagne', '0711-020361', '0711-035428'),
('WARTH', 'Wartian Herkku', 'Pirkko Koskitalo', 'Chef comptable', 'Torikatu 38', 'Oulu', NULL, '90110', 'Finlande', '981-443655', '981-443655'),
('WELLI', 'Wellington Importadora', 'Paula Parente', 'Chef des ventes', 'Rua do Mercado, 12', 'Resende', 'SP', '08737-363', 'Brésil', '(14) 555-8122', NULL),
('WHITC', 'White Clover Markets', 'Karl Jablonski', 'Propriétaire', '305 - 14th Ave. S.\r\nSuite 3B', 'Seattle', 'WA', '98128', 'États-Unis', '(206) 555-4112', '(206) 555-4115'),
('WILMK', 'Wilman Kala', 'Matti Karttunen', 'Assistant du marketing', 'Keskuskatu 45', 'Helsinki', NULL, '21240', 'Finlande', '90-224 8858', '90-224 8858'),
('WOLZA', 'Wolski  Zajazd', 'Zbyszek Piestrzeniewicz', 'Propriétaire', 'ul. Filtrowa 68', 'Warszawa', NULL, '01-012', 'Pologne', '(26) 642-7012', '(26) 642-7012'),
('GIE', NULL, NULL, NULL, NULL, 'Draguignan', NULL, NULL, 'France', NULL, NULL);


INSERT INTO commandes (pk_commande, fk_client, NumEmploye, DateCommande, LivrerAvant, DateEnvoi, NumMessager, Port, Destinataire) VALUES
(1, 'VINET', 5, '2017-07-04 00:00:00', '2017-08-01 00:00:00', '2017-07-16', 3, 161.9, 'Vins et alcools Chevalier'),
(2, 'TOMSP', 6, '2017-07-05 00:00:00', '2017-08-16 00:00:00', '2017-07-10', 1, 58.05, 'Toms Spezialitäten'),
(3, 'HANAR', 4, '2017-07-08 00:00:00', '2017-08-05 00:00:00', '2017-07-12', 2, 329.15, 'Hanari Carnes'),
(4, 'VICTE', 3, '2017-07-08 00:00:00', '2017-08-05 00:00:00', '2017-07-15', 1, 206.7, 'Victuailles en stock'),
(5, 'SUPRD', 4, '2017-07-09 00:00:00', '2017-08-06 00:00:00', '2017-07-11', 2, 256.5, 'Suprêmes délices'),
(6, 'HANAR', 3, '2017-07-10 00:00:00', '2017-07-24 00:00:00', '2017-07-16', 2, 290.85, 'Hanari Carnes'),
(7, 'CHOPS', 5, '2017-07-11 00:00:00', '2017-08-08 00:00:00', '2017-07-23', 2, 114.9, 'Chop-suey Chinese'),
(8, 'RICSU', 9, '2017-07-12 00:00:00', '2017-08-09 00:00:00', '2017-07-15', 3, 741.65, 'Richter Supermarkt'),
(9, 'WELLI', 3, '2017-07-15 00:00:00', '2017-08-12 00:00:00', '2017-07-17', 2, 69.85, 'Wellington Importadora'),
(10, 'HILAA', 4, '2017-07-16 00:00:00', '2017-08-13 00:00:00', '2017-07-22', 3, 409.55, 'HILARIÓN-Abastos'),
(11, 'ERNSH', 1, '2017-07-17 00:00:00', '2017-08-14 00:00:00', '2017-07-23', 1, 702.55, 'Ernst Handel'),
(12, 'CENTC', 4, '2017-07-18 00:00:00', '2017-08-15 00:00:00', '2017-07-25', 3, 16.25, 'Centro comercial Moctezuma'),
(13, 'OTTIK', 4, '2017-07-19 00:00:00', '2017-08-16 00:00:00', '2017-07-29', 1, 275.45, 'Ottilies Käseladen'),
(14, 'QUEDE', 4, '2017-07-19 00:00:00', '2017-08-16 00:00:00', '2017-07-30', 2, 15.25, 'Que Delícia'),
(15, 'RATTC', 8, '2017-07-22 00:00:00', '2017-08-19 00:00:00', '2017-07-25', 3, 241.45, 'Rattlesnake Canyon Grocery'),
(16, 'ERNSH', 9, '2017-07-23 00:00:00', '2017-08-20 00:00:00', '2017-07-31', 3, 730.3, 'Ernst Handel'),
(17, 'FOLKO', 6, '2017-07-24 00:00:00', '2017-08-21 00:00:00', '2017-08-23', 3, 18.35, 'Folk och fä HB'),
(18, 'BLONP', 2, '2017-07-25 00:00:00', '2017-08-22 00:00:00', '2017-08-12', 1, 276.4, 'Blondel père et fils'),
(19, 'WARTH', 3, '2017-07-26 00:00:00', '2017-09-06 00:00:00', '2017-07-31', 3, 128.65, 'Wartian Herkku'),
(20, 'FRANK', 4, '2017-07-29 00:00:00', '2017-08-26 00:00:00', '2017-08-06', 1, 1042.9, 'Frankenversand'),
(21, 'GROSR', 8, '2017-07-30 00:00:00', '2017-08-27 00:00:00', '2017-08-02', 3, 331.45, 'GROSELLA-Restaurante'),
(22, 'WHITC', 5, '2017-07-31 00:00:00', '2017-08-14 00:00:00', '2017-08-09', 1, 22.8, 'White Clover Markets'),
(23, 'WARTH', 1, '2017-08-01 00:00:00', '2017-08-29 00:00:00', '2017-08-02', 1, 682.7, 'Wartian Herkku'),
(24, 'SPLIR', 6, '2017-08-01 00:00:00', '2017-08-29 00:00:00', '2017-08-30', 2, 22.7, 'Split Rail Beer & Ale'),
(25, 'RATTC', 6, '2017-08-02 00:00:00', '2017-08-30 00:00:00', '2017-08-06', 2, 490.15, 'Rattlesnake Canyon Grocery'),
(26, 'QUICK', 3, '2017-08-05 00:00:00', '2017-09-02 00:00:00', '2017-08-12', 3, 380.35, 'QUICK-Stop'),
(27, 'VINET', 6, '2017-08-06 00:00:00', '2017-09-03 00:00:00', '2017-08-16', 1, 30.05, 'Vins et alcools Chevalier'),
(28, 'MAGAA', 1, '2017-08-07 00:00:00', '2017-09-04 00:00:00', '2017-08-09', 1, 134.65, 'Magazzini Alimentari Riuniti'),
(29, 'TORTU', 8, '2017-08-08 00:00:00', '2017-08-22 00:00:00', '2017-08-14', 3, 69.2, 'Tortuga Restaurante'),
(30, 'MORGK', 2, '2017-08-09 00:00:00', '2017-09-06 00:00:00', '2017-08-13', 3, 628.85, 'Morgenstern Gesundkost'),
(31, 'BERGS', 8, '2017-08-12 00:00:00', '2017-09-09 00:00:00', '2017-08-16', 2, 463.45, 'Berglunds snabbköp'),
(32, 'LEHMS', 8, '2017-08-13 00:00:00', '2017-09-10 00:00:00', '2017-08-16', 2, 129.15, 'Lehmanns Marktstand'),
(33, 'BERGS', 2, '2017-08-14 00:00:00', '2017-09-11 00:00:00', '2017-09-12', 1, 44.9, 'Berglunds snabbköp'),
(34, 'ROMEY', 4, '2017-08-14 00:00:00', '2017-08-28 00:00:00', '2017-08-21', 1, 14.7, 'Romero y tomillo'),
(35, 'ROMEY', 4, '2017-08-15 00:00:00', '2017-09-12 00:00:00', '2017-08-21', 1, 63.45, 'Romero y tomillo'),
(36, 'LILAS', 3, '2017-08-16 00:00:00', '2017-09-13 00:00:00', '2017-08-23', 3, 424.05, 'LILA-Supermercado'),
(37, 'LEHMS', 4, '2017-08-19 00:00:00', '2017-09-16 00:00:00', '2017-08-27', 1, 382.8, 'Lehmanns Marktstand'),
(38, 'QUICK', 1, '2017-08-20 00:00:00', '2017-09-17 00:00:00', '2017-08-26', 2, 384.15, 'QUICK-Stop'),
(39, 'QUICK', 8, '2017-08-21 00:00:00', '2017-09-18 00:00:00', '2017-08-30', 3, 1146.2, 'QUICK-Stop'),
(40, 'RICAR', 8, '2017-08-22 00:00:00', '2017-09-19 00:00:00', '2017-08-28', 3, 63.8, 'Ricardo Adocicados'),
(41, 'REGGC', 4, '2017-08-23 00:00:00', '2017-09-20 00:00:00', '2017-09-03', 1, 37.25, 'Reggiani Caseifici'),
(42, 'BSBEV', 7, '2017-08-26 00:00:00', '2017-09-23 00:00:00', '2017-08-28', 3, 113.85, 'Bs Beverages'),
(43, 'COMMI', 8, '2017-08-27 00:00:00', '2017-09-24 00:00:00', '2017-09-03', 1, 398.5, 'Comércio Mineiro'),
(44, 'QUEDE', 6, '2017-08-27 00:00:00', '2017-09-24 00:00:00', '2017-09-04', 2, 32, 'Que Delícia'),
(45, 'TRADH', 1, '2017-08-28 00:00:00', '2017-09-25 00:00:00', '2017-09-02', 2, 6.75, 'Tradição Hipermercados'),
(46, 'TORTU', 1, '2017-08-29 00:00:00', '2017-09-26 00:00:00', '2017-09-11', 3, 105.9, 'Tortuga Restaurante'),
(47, 'RATTC', 4, '2017-08-30 00:00:00', '2017-09-27 00:00:00', '2017-09-05', 2, 736.3, 'Rattlesnake Canyon Grocery'),
(48, 'VINET', 2, '2017-09-02 00:00:00', '2017-09-30 00:00:00', '2017-09-10', 2, 5.75, 'Vins et alcools Chevalier'),
(49, 'LILAS', 6, '2017-09-03 00:00:00', '2017-10-01 00:00:00', '2017-09-11', 1, 0.6, 'LILA-Supermercado'),
(50, 'BLONP', 5, '2017-09-04 00:00:00', '2017-10-16 00:00:00', '2017-09-10', 2, 28.7, 'Blondel père et fils'),
(51, 'HUNGO', 6, '2017-09-05 00:00:00', '2017-10-03 00:00:00', '2017-09-11', 2, 841.1, 'Hungry Owl All-Night Grocers'),
(52, 'RICAR', 4, '2017-09-06 00:00:00', '2017-10-04 00:00:00', '2017-09-13', 2, 148.8, 'Ricardo Adocicados'),
(53, 'MAGAA', 2, '2017-09-09 00:00:00', '2017-10-07 00:00:00', '2017-09-18', 2, 88.4, 'Magazzini Alimentari Riuniti'),
(54, 'WANDK', 8, '2017-09-09 00:00:00', '2017-10-07 00:00:00', '2017-09-17', 2, 225.4, 'Die Wandernde Kuh'),
(55, 'SUPRD', 4, '2017-09-10 00:00:00', '2017-10-08 00:00:00', '2017-10-09', 2, 31.35, 'Suprêmes délices'),
(56, 'GODOS', 7, '2017-09-11 00:00:00', '2017-10-09 00:00:00', '2017-09-18', 2, 539.15, 'Godos Cocina Típica'),
(57, 'TORTU', 1, '2017-09-12 00:00:00', '2017-10-10 00:00:00', '2017-09-17', 2, 318.95, 'Tortuga Restaurante'),
(58, 'OLDWO', 8, '2017-09-13 00:00:00', '2017-10-11 00:00:00', '2017-10-09', 3, 1288.1, 'Old World Delicatessen'),
(59, 'ROMEY', 1, '2017-09-16 00:00:00', '2017-10-14 00:00:00', '2017-09-23', 3, 37.8, 'Romero y tomillo'),
(60, 'LONEP', 2, '2017-09-17 00:00:00', '2017-10-15 00:00:00', '2017-09-25', 2, 2.8, 'Lonesome Pine Restaurant'),
(61, 'ANATR', 7, '2017-09-18 00:00:00', '2017-10-16 00:00:00', '2017-09-24', 3, 8.05, 'Ana Trujillo Emparedados y helados'),
(62, 'HUNGO', 3, '2017-09-19 00:00:00', '2017-10-17 00:00:00', '2017-10-23', 1, 236.5, 'Hungry Owl All-Night Grocers'),
(63, 'THEBI', 8, '2017-09-20 00:00:00', '2017-10-18 00:00:00', '2017-09-27', 2, 87.6, 'The Big Cheese'),
(64, 'DUMON', 1, '2017-09-20 00:00:00', '2017-10-04 00:00:00', '2017-09-26', 3, 123.45, 'Du monde entier'),
(65, 'WANDK', 2, '2017-09-23 00:00:00', '2017-10-21 00:00:00', '2017-10-03', 2, 201.3, 'Die Wandernde Kuh'),
(66, 'QUICK', 2, '2017-09-24 00:00:00', '2017-10-22 00:00:00', '2017-10-04', 2, 9.8, 'QUICK-Stop'),
(67, 'RATTC', 1, '2017-09-25 00:00:00', '2017-10-23 00:00:00', '2017-10-04', 2, 370.8, 'Rattlesnake Canyon Grocery'),
(68, 'ISLAT', 4, '2017-09-26 00:00:00', '2017-10-24 00:00:00', '2017-10-03', 2, 208.8, 'Island Trading'),
(69, 'RATTC', 1, '2017-09-27 00:00:00', '2017-10-25 00:00:00', '2017-10-08', 3, 750.75, 'Rattlesnake Canyon Grocery'),
(70, 'LONEP', 6, '2017-09-30 00:00:00', '2017-10-28 00:00:00', '2017-10-10', 1, 63.45, 'Lonesome Pine Restaurant'),
(71, 'ISLAT', 8, '2017-10-01 00:00:00', '2017-10-29 00:00:00', '2017-10-04', 2, 23.65, 'Island Trading'),
(72, 'TORTU', 7, '2017-10-02 00:00:00', '2017-10-30 00:00:00', '2017-10-11', 3, 322.5, 'Tortuga Restaurante'),
(73, 'WARTH', 5, '2017-10-03 00:00:00', '2017-10-17 00:00:00', '2017-10-18', 3, 172.85, 'Wartian Herkku'),
(74, 'ISLAT', 3, '2017-10-03 00:00:00', '2017-10-31 00:00:00', '2017-10-11', 2, 17.15, 'Island Trading'),
(75, 'PERIC', 7, '2017-10-04 00:00:00', '2017-11-01 00:00:00', '2017-10-23', 3, 2, 'Pericles Comidas clásicas'),
(76, 'KOENE', 4, '2017-10-07 00:00:00', '2017-11-04 00:00:00', '2017-10-14', 1, 24.4, 'Königlich Essen'),
(77, 'SAVEA', 9, '2017-10-08 00:00:00', '2017-11-05 00:00:00', '2017-10-10', 1, 1071.35, 'Save-a-lot Markets'),
(78, 'KOENE', 1, '2017-10-09 00:00:00', '2017-10-23 00:00:00', '2017-10-14', 3, 324.3, 'Königlich Essen'),
(79, 'BOLID', 4, '2017-10-10 00:00:00', '2017-11-07 00:00:00', '2017-10-14', 2, 389.6, 'Bólido Comidas preparadas'),
(80, 'FOLKO', 2, '2017-10-11 00:00:00', '2017-11-08 00:00:00', '2017-10-14', 1, 316.8, 'Folk och fä HB'),
(81, 'FURIB', 4, '2017-10-14 00:00:00', '2017-11-11 00:00:00', '2017-10-17', 3, 435.15, 'Furia Bacalhau e Frutos do Mar'),
(82, 'SPLIR', 4, '2017-10-15 00:00:00', '2017-11-26 00:00:00', '2017-10-23', 2, 958.35, 'Split Rail Beer & Ale'),
(83, 'LILAS', 3, '2017-10-16 00:00:00', '2017-11-13 00:00:00', '2017-10-28', 1, 63.75, 'LILA-Supermercado'),
(84, 'BONAP', 9, '2017-10-16 00:00:00', '2017-11-27 00:00:00', '2017-10-21', 1, 50.95, 'Bon app'),
(85, 'MEREP', 3, '2017-10-17 00:00:00', '2017-11-28 00:00:00', '2017-10-21', 2, 264.2, 'Mère Paillarde'),
(86, 'WARTH', 5, '2017-10-18 00:00:00', '2017-11-15 00:00:00', '2017-10-25', 3, 2.95, 'Wartian Herkku'),
(87, 'VICTE', 8, '2017-10-21 00:00:00', '2017-11-18 00:00:00', '2017-10-28', 2, 42.8, 'Victuailles en stock'),
(88, 'HUNGO', 7, '2017-10-22 00:00:00', '2017-11-19 00:00:00', '2017-10-24', 2, 210.55, 'Hungry Owl All-Night Grocers'),
(89, 'PRINI', 7, '2017-10-23 00:00:00', '2017-11-20 00:00:00', '2017-10-25', 2, 77.55, 'Princesa Isabel Vinhos'),
(90, 'FRANK', 4, '2017-10-24 00:00:00', '2017-11-21 00:00:00', '2017-10-29', 3, 541.3, 'Frankenversand'),
(91, 'OLDWO', 4, '2017-10-25 00:00:00', '2017-11-22 00:00:00', '2017-10-29', 3, 421.05, 'Old World Delicatessen'),
(92, 'MEREP', 2, '2017-10-28 00:00:00', '2017-11-25 00:00:00', '2017-11-04', 2, 78.3, 'Mère Paillarde'),
(93, 'BONAP', 1, '2017-10-29 00:00:00', '2017-11-26 00:00:00', '2017-11-08', 3, 831.55, 'Bon app'),
(94, 'SIMOB', 7, '2017-10-29 00:00:00', '2017-11-26 00:00:00', '2017-11-05', 3, 133.9, 'Simons bistro'),
(95, 'FRANK', 4, '2017-10-30 00:00:00', '2017-11-13 00:00:00', '2017-11-04', 2, 274.15, 'Frankenversand'),
(96, 'LEHMS', 4, '2017-10-31 00:00:00', '2017-11-28 00:00:00', '2017-11-06', 1, 551.85, 'Lehmanns Marktstand'),
(97, 'WHITC', 4, '2017-11-01 00:00:00', '2017-11-29 00:00:00', '2017-11-05', 2, 116.45, 'White Clover Markets'),
(98, 'QUICK', 2, '2017-11-04 00:00:00', '2017-12-02 00:00:00', '2017-11-11', 2, 1245.3, 'QUICK-Stop'),
(99, 'RATTC', 3, '2017-11-05 00:00:00', '2017-12-17 00:00:00', '2017-11-08', 3, 710.4, 'Rattlesnake Canyon Grocery'),
(100, 'FAMIA', 4, '2017-11-06 00:00:00', '2017-12-04 00:00:00', '2017-11-08', 3, 15.5, 'Familia Arquibaldo'),
(101, 'WANDK', 4, '2017-11-07 00:00:00', '2017-12-05 00:00:00', '2017-11-15', 2, 3.9, 'Die Wandernde Kuh'),
(102, 'SPLIR', 7, '2017-11-08 00:00:00', '2017-12-06 00:00:00', '2017-11-15', 1, 43.15, 'Split Rail Beer & Ale'),
(103, 'LAMAI', 6, '2017-11-11 00:00:00', '2017-12-09 00:00:00', '2017-12-03', 2, 320.95, 'La maison dAsie'),
(104, 'ERNSH', 1, '2017-11-11 00:00:00', '2017-12-09 00:00:00', '2017-11-20', 1, 811.65, 'Ernst Handel'),
(105, 'FURIB', 3, '2017-11-12 00:00:00', '2017-11-26 00:00:00', '2017-11-18', 3, 6.5, 'Furia Bacalhau e Frutos do Mar'),
(106, 'PICCO', 7, '2017-11-13 00:00:00', '2017-12-11 00:00:00', '2017-11-25', 3, 1803.15, 'Piccolo und mehr'),
(107, 'PERIC', 8, '2017-11-14 00:00:00', '2017-12-12 00:00:00', '2017-11-20', 3, 269, 'Pericles Comidas clásicas'),
(108, 'AROUT', 6, '2017-11-15 00:00:00', '2017-12-13 00:00:00', '2017-11-20', 1, 209.75, 'Around the Horn'),
(109, 'WANDK', 6, '2017-11-18 00:00:00', '2017-12-16 00:00:00', '2017-11-27', 2, 183.55, 'Die Wandernde Kuh'),
(110, 'LILAS', 1, '2017-11-19 00:00:00', '2017-12-17 00:00:00', '2017-12-02', 3, 174.4, 'LILA-Supermercado'),
(111, 'LAMAI', 5, '2017-11-20 00:00:00', '2017-12-18 00:00:00', '2017-11-27', 1, 98.2, 'La maison dAsie'),
(112, 'SEVES', 5, '2017-11-21 00:00:00', '2017-12-19 00:00:00', '2017-11-26', 3, 1442.15, 'Seven Seas Imports'),
(113, 'BLONP', 4, '2017-11-22 00:00:00', '2017-12-20 00:00:00', '2017-12-02', 3, 658.5, 'Blondel père et fils'),
(114, 'QUICK', 1, '2017-11-22 00:00:00', '2017-12-20 00:00:00', '2017-12-03', 2, 915.85, 'QUICK-Stop'),
(115, 'BONAP', 3, '2017-11-25 00:00:00', '2017-12-23 00:00:00', '2017-11-28', 1, 480.2, 'Bon app'),
(116, 'DRACD', 4, '2017-11-26 00:00:00', '2017-12-24 00:00:00', '2017-12-04', 3, 152.7, 'Drachenblut Delikatessen'),
(117, 'EASTC', 1, '2017-11-26 00:00:00', '2018-01-07 00:00:00', '2017-12-04', 1, 359.85, 'Eastern Connection'),
(118, 'ANTON', 3, '2017-11-27 00:00:00', '2017-12-25 00:00:00', '2017-12-02', 2, 110, 'Antonio Moreno Taquería'),
(119, 'GALED', 8, '2017-11-28 00:00:00', '2018-01-09 00:00:00', '2017-12-30', 2, 50.7, 'Galería del gastronómo'),
(120, 'VAFFE', 7, '2017-11-28 00:00:00', '2017-12-26 00:00:00', '2017-12-02', 3, 67.75, 'Vaffeljernet'),
(121, 'ERNSH', 2, '2017-11-29 00:00:00', '2017-12-27 00:00:00', '2017-12-02', 2, 509.75, 'Ernst Handel'),
(122, 'SPLIR', 8, '2017-12-02 00:00:00', '2017-12-30 00:00:00', '2017-12-09', 2, 978.4, 'Split Rail Beer & Ale'),
(123, 'CHOPS', 6, '2017-12-03 00:00:00', '2017-12-31 00:00:00', '2017-12-27', 2, 5.85, 'Chop-suey Chinese'),
(124, 'LAMAI', 1, '2017-12-03 00:00:00', '2017-12-31 00:00:00', '2017-12-24', 1, 2.25, 'La maison dAsie'),
(125, 'QUEEN', 5, '2017-12-04 00:00:00', '2018-01-01 00:00:00', '2017-12-09', 2, 4453.9, 'Queen Cozinha'),
(126, 'HUNGO', 4, '2017-12-05 00:00:00', '2018-01-02 00:00:00', '2017-12-11', 3, 620.6, 'Hungry Owl All-Night Grocers'),
(127, 'WOLZA', 1, '2017-12-05 00:00:00', '2018-01-02 00:00:00', '2017-12-09', 3, 19.7, 'Wolski Zajazd'),
(128, 'HUNGC', 3, '2017-12-06 00:00:00', '2018-01-03 00:00:00', '2017-12-09', 2, 100.6, 'Hungry Coyote Import Store'),
(129, 'MEREP', 1, '2017-12-09 00:00:00', '2018-01-06 00:00:00', '2017-12-13', 2, 101.95, 'Mère Paillarde'),
(130, 'SEVES', 1, '2017-12-09 00:00:00', '2018-01-06 00:00:00', '2017-12-13', 3, 111.05, 'Seven Seas Imports'),
(131, 'FOLKO', 5, '2017-12-10 00:00:00', '2018-01-07 00:00:00', '2017-12-19', 3, 27.2, 'Folk och fä HB'),
(132, 'QUEDE', 2, '2017-12-11 00:00:00', '2018-01-08 00:00:00', '2017-12-13', 1, 225.15, 'Que Delícia'),
(133, 'HUNGO', 8, '2017-12-12 00:00:00', '2018-01-09 00:00:00', '2018-01-16', 3, 175.15, 'Hungry Owl All-Night Grocers'),
(134, 'LILAS', 3, '2017-12-12 00:00:00', '2018-01-09 00:00:00', '2017-12-13', 3, 39.95, 'LILA-Supermercado'),
(135, 'ERNSH', 4, '2017-12-13 00:00:00', '2018-01-10 00:00:00', '2017-12-16', 1, 473.85, 'Ernst Handel'),
(136, 'AROUT', 8, '2017-12-16 00:00:00', '2018-01-13 00:00:00', '2017-12-18', 3, 171.2, 'Around the Horn'),
(137, 'BERGS', 3, '2017-12-16 00:00:00', '2018-01-13 00:00:00', '2017-12-20', 3, 843.2, 'Berglunds snabbköp'),
(138, 'SPLIR', 1, '2017-12-17 00:00:00', '2018-01-14 00:00:00', '2017-12-23', 2, 154.8, 'Split Rail Beer & Ale'),
(139, 'FAMIA', 9, '2017-12-18 00:00:00', '2018-01-01 00:00:00', '2017-12-25', 3, 69.95, 'Familia Arquibaldo'),
(140, 'SANTG', 1, '2017-12-18 00:00:00', '2018-01-15 00:00:00', '2017-12-20', 2, 468.15, 'Santé Gourmet'),
(141, 'SEVES', 2, '2017-12-19 00:00:00', '2018-01-16 00:00:00', '2017-12-20', 1, 174.3, 'Seven Seas Imports'),
(142, 'BOTTM', 4, '2017-12-20 00:00:00', '2018-01-17 00:00:00', '2017-12-24', 2, 237.1, 'Bottom-Dollar Markets'),
(143, 'ERNSH', 6, '2017-12-23 00:00:00', '2018-01-20 00:00:00', '2017-12-26', 1, 631.9, 'Ernst Handel'),
(144, 'DRACD', 3, '2017-12-23 00:00:00', '2018-01-20 00:00:00', '2017-12-31', 3, 27.25, 'Drachenblut Delikatessen'),
(145, 'PICCO', 2, '2017-12-24 00:00:00', '2018-01-21 00:00:00', '2018-01-01', 3, 612.3, 'Piccolo und mehr'),
(146, 'SAVEA', 1, '2017-12-25 00:00:00', '2018-01-22 00:00:00', '2018-01-03', 3, 632.8, 'Save-a-lot Markets'),
(147, 'HUNGC', 1, '2017-12-25 00:00:00', '2018-01-22 00:00:00', '2018-01-03', 3, 151.7, 'Hungry Coyote Import Store'),
(148, 'HILAA', 6, '2017-12-26 00:00:00', '2018-01-23 00:00:00', '2018-01-03', 1, 922.05, 'HILARIÓN-Abastos'),
(149, 'FRANK', 1, '2017-12-27 00:00:00', '2018-01-10 00:00:00', '2018-01-06', 3, 676.75, 'Frankenversand'),
(150, 'PRINI', 5, '2017-12-27 00:00:00', '2018-01-24 00:00:00', '2018-01-02', 1, 301.3, 'Princesa Isabel Vinhos'),
(151, 'SAVEA', 2, '2017-12-30 00:00:00', '2018-01-27 00:00:00', '2018-01-09', 3, 445.8, 'Save-a-lot Markets'),
(152, 'VAFFE', 8, '2017-12-31 00:00:00', '2018-01-14 00:00:00', '2018-01-08', 3, 136.8, 'Vaffeljernet'),
(153, 'EASTC', 1, '2018-01-01 00:00:00', '2018-01-29 00:00:00', '2018-01-16', 3, 419.65, 'Eastern Connection'),
(154, 'RATTC', 1, '2018-01-01 00:00:00', '2018-01-29 00:00:00', '2018-01-10', 1, 62.55, 'Rattlesnake Canyon Grocery'),
(155, 'ERNSH', 8, '2018-01-02 00:00:00', '2018-02-13 00:00:00', '2018-01-10', 2, 339.4, 'Ernst Handel'),
(156, 'ERNSH', 4, '2018-01-03 00:00:00', '2018-01-31 00:00:00', '2018-01-09', 3, 368.95, 'Ernst Handel'),
(157, 'MAGAA', 2, '2018-01-03 00:00:00', '2018-01-31 00:00:00', '2018-01-08', 1, 779.85, 'Magazzini Alimentari Riuniti'),
(158, 'LINOD', 1, '2018-01-06 00:00:00', '2018-02-03 00:00:00', '2018-01-22', 1, 174.1, 'LINO-Delicateses'),
(159, 'QUEEN', 7, '2018-01-07 00:00:00', '2018-02-18 00:00:00', '2018-01-13', 1, 540.2, 'Queen Cozinha'),
(160, 'OTTIK', 2, '2018-01-07 00:00:00', '2018-02-04 00:00:00', '2018-01-30', 2, 457.4, 'Ottilies Käseladen'),
(161, 'FOLIG', 8, '2018-01-08 00:00:00', '2018-02-05 00:00:00', '2018-01-14', 1, 56.3, 'Folies gourmandes'),
(162, 'OCEAN', 3, '2018-01-09 00:00:00', '2018-02-06 00:00:00', '2018-01-14', 1, 149.15, 'Océano Atlántico Ltda.'),
(163, 'BOTTM', 3, '2018-01-10 00:00:00', '2018-02-07 00:00:00', '2018-01-15', 3, 12, 'Bottom-Dollar Markets'),
(164, 'BOTTM', 9, '2018-01-10 00:00:00', '2018-02-07 00:00:00', '2018-01-21', 3, 118.25, 'Bottom-Dollar Markets'),
(165, 'WARTH', 8, '2018-01-13 00:00:00', '2018-02-10 00:00:00', '2018-01-15', 2, 18.85, 'Wartian Herkku'),
(166, 'LAMAI', 3, '2018-01-14 00:00:00', '2018-02-11 00:00:00', '2018-01-16', 2, 478.3, 'La maison dAsie'),
(168, 'HUNGC', 3, '2018-01-15 00:00:00', '2018-02-12 00:00:00', '2018-01-24', 1, 1, 'Hungry Coyote Import Store'),
(169, 'WARTH', 8, '2018-01-16 00:00:00', '2018-02-13 00:00:00', '2018-01-27', 3, 113.6, 'Wartian Herkku'),
(170, 'SIMOB', 4, '2018-01-16 00:00:00', '2018-02-13 00:00:00', '2018-01-28', 3, 351.45, 'Simons bistro'),
(171, 'QUICK', 4, '2018-01-17 00:00:00', '2018-02-14 00:00:00', '2018-01-24', 1, 87.75, 'QUICK-Stop'),
(172, 'RICSU', 4, '2018-01-20 00:00:00', '2018-02-17 00:00:00', '2018-01-30', 2, 686.75, 'Richter Supermarkt'),
(173, 'WELLI', 3, '2018-01-21 00:00:00', '2018-02-18 00:00:00', '2018-01-27', 1, 220.6, 'Wellington Importadora'),
(174, 'QUEDE', 8, '2018-01-21 00:00:00', '2018-03-04 00:00:00', '2018-01-27', 1, 496.15, 'Que Delícia'),
(175, 'FRANS', 2, '2018-01-22 00:00:00', '2018-02-19 00:00:00', '2018-01-31', 1, 15.1, 'Franchi S.p.A.'),
(176, 'GOURL', 6, '2018-01-23 00:00:00', '2018-02-06 00:00:00', '2018-02-24', 3, 122.5, 'Gourmet Lanchonetes'),
(177, 'MEREP', 7, '2018-01-23 00:00:00', '2018-02-20 00:00:00', '2018-01-27', 2, 1853.05, 'Mère Paillarde'),
(178, 'LAMAI', 6, '2018-01-24 00:00:00', '2018-02-21 00:00:00', '2018-02-14', 2, 39.65, 'La maison dAsie'),
(179, 'GALED', 4, '2018-01-27 00:00:00', '2018-02-24 00:00:00', '2018-02-06', 1, 93.45, 'Galería del gastronómo'),
(180, 'PICCO', 4, '2018-01-27 00:00:00', '2018-02-24 00:00:00', '2018-03-03', 2, 156.45, 'Piccolo und mehr'),
(181, 'REGGC', 7, '2018-01-28 00:00:00', '2018-02-25 00:00:00', '2018-02-04', 1, 55.45, 'Reggiani Caseifici'),
(182, 'HUNGO', 3, '2018-01-29 00:00:00', '2018-03-12 00:00:00', '2018-02-07', 2, 283.15, 'Hungry Owl All-Night Grocers'),
(183, 'ERNSH', 4, '2018-01-30 00:00:00', '2018-02-13 00:00:00', '2018-02-03', 1, 2293.9, 'Ernst Handel'),
(184, 'BOTTM', 4, '2018-01-30 00:00:00', '2018-02-13 00:00:00', '2018-02-07', 2, 220.85, 'Bottom-Dollar Markets'),
(185, 'SPLIR', 3, '2018-01-31 00:00:00', '2018-02-14 00:00:00', '2018-02-07', 2, 21.7, 'Split Rail Beer & Ale'),
(186, 'PRINI', 3, '2018-02-03 00:00:00', '2018-03-03 00:00:00', '2018-03-04', 3, 369.15, 'Princesa Isabel Vinhos'),
(187, 'FOLKO', 3, '2018-02-03 00:00:00', '2018-03-03 00:00:00', '2018-02-13', 2, 89.6, 'Folk och fä HB'),
(188, 'CONSH', 8, '2018-02-04 00:00:00', '2018-03-18 00:00:00', '2018-02-07', 2, 46.05, 'Consolidated Holdings'),
(189, 'BLONP', 3, '2018-02-05 00:00:00', '2018-03-05 00:00:00', '2018-02-11', 2, 783.3, 'Blondel père et fils'),
(190, 'WARTH', 8, '2018-02-05 00:00:00', '2018-03-05 00:00:00', '2018-02-12', 1, 99.85, 'Wartian Herkku'),
(191, 'TOMSP', 3, '2018-02-06 00:00:00', '2018-03-06 00:00:00', '2018-02-14', 2, 41.2, 'Toms Spezialitäten'),
(192, 'MEREP', 6, '2018-02-07 00:00:00', '2018-03-07 00:00:00', '2018-02-10', 3, 20.35, 'Mère Paillarde'),
(193, 'SAVEA', 4, '2018-02-10 00:00:00', '2018-03-10 00:00:00', '2018-02-28', 2, 432.65, 'Save-a-lot Markets'),
(194, 'OLDWO', 3, '2018-02-10 00:00:00', '2018-03-24 00:00:00', '2018-03-14', 2, 365.1, 'Old World Delicatessen'),
(195, 'ERNSH', 3, '2018-02-11 00:00:00', '2018-03-11 00:00:00', '2018-02-18', 2, 239.7, 'Ernst Handel'),
(196, 'REGGC', 8, '2018-02-12 00:00:00', '2018-03-12 00:00:00', '2018-02-14', 1, 69.75, 'Reggiani Caseifici'),
(197, 'BERGS', 3, '2018-02-12 00:00:00', '2018-03-12 00:00:00', '2018-02-21', 3, 17.5, 'Berglunds snabbköp'),
(198, 'BERGS', 3, '2018-02-13 00:00:00', '2018-03-13 00:00:00', '2018-02-20', 1, 46.5, 'Berglunds snabbköp'),
(199, 'TOMSP', 6, '2018-02-14 00:00:00', '2018-03-14 00:00:00', '2018-02-19', 1, 73.4, 'Toms Spezialitäten'),
(200, 'RICAR', 4, '2018-02-14 00:00:00', '2018-03-14 00:00:00', '2018-03-07', 2, 343.3, 'Ricardo Adocicados'),
(201, 'RANCH', 4, '2018-02-17 00:00:00', '2018-03-17 00:00:00', '2018-02-24', 2, 194.1, 'Rancho grande'),
(202, 'BLONP', 3, '2018-02-18 00:00:00', '2018-03-18 00:00:00', '2018-02-27', 2, 266.5, 'Blondel père et fils'),
(203, 'VICTE', 8, '2018-02-19 00:00:00', '2018-03-19 00:00:00', '2018-03-11', 2, 36.15, 'Victuailles en stock'),
(204, 'QUICK', 4, '2018-02-19 00:00:00', '2018-03-05 00:00:00', '2018-03-12', 3, 945.45, 'QUICK-Stop'),
(205, 'SAVEA', 8, '2018-02-20 00:00:00', '2018-03-20 00:00:00', '2018-02-26', 1, 701.3, 'Save-a-lot Markets'),
(206, 'AROUT', 1, '2018-02-21 00:00:00', '2018-03-21 00:00:00', '2018-02-26', 2, 126.8, 'Around the Horn'),
(207, 'LAMAI', 4, '2018-02-21 00:00:00', '2018-03-21 00:00:00', '2018-02-25', 3, 13.7, 'La maison dAsie'),
(208, 'WARTH', 8, '2018-02-24 00:00:00', '2018-04-07 00:00:00', '2018-03-03', 2, 902.25, 'Wartian Herkku'),
(209, 'KOENE', 8, '2018-02-25 00:00:00', '2018-04-08 00:00:00', '2018-02-28', 2, 40.6, 'Königlich Essen'),
(210, 'KOENE', 2, '2018-02-25 00:00:00', '2018-03-25 00:00:00', '2018-03-03', 1, 57.85, 'Königlich Essen'),
(211, 'SUPRD', 7, '2018-02-26 00:00:00', '2018-03-26 00:00:00', '2018-03-04', 3, 735.3, 'Suprêmes délices'),
(212, 'VICTE', 4, '2018-02-27 00:00:00', '2018-03-27 00:00:00', '2018-02-28', 2, 125.45, 'Victuailles en stock'),
(213, 'FOLKO', 8, '2018-02-28 00:00:00', '2018-03-28 00:00:00', '2018-03-03', 1, 81.35, 'Folk och fä HB'),
(214, 'LILAS', 1, '2018-02-28 00:00:00', '2018-03-28 00:00:00', '2018-03-05', 3, 743.05, 'LILA-Supermercado'),
(215, 'CONSH', 2, '2018-03-03 00:00:00', '2018-03-31 00:00:00', '2018-03-18', 1, 30.85, 'Consolidated Holdings'),
(216, 'SUPRD', 5, '2018-03-04 00:00:00', '2018-04-01 00:00:00', '2018-03-06', 3, 73.9, 'Suprêmes délices'),
(217, 'FURIB', 4, '2018-03-04 00:00:00', '2018-04-01 00:00:00', '2018-03-14', 2, 445, 'Furia Bacalhau e Frutos do Mar'),
(218, 'VAFFE', 1, '2018-03-05 00:00:00', '2018-04-02 00:00:00', '2018-03-14', 3, 725.2, 'Vaffeljernet'),
(219, 'COMMI', 4, '2018-03-06 00:00:00', '2018-04-03 00:00:00', '2018-03-13', 1, 59.65, 'Comércio Mineiro'),
(220, 'MAGAA', 8, '2018-03-06 00:00:00', '2018-04-03 00:00:00', '2018-03-11', 2, 24.65, 'Magazzini Alimentari Riuniti'),
(221, 'KOENE', 3, '2018-03-07 00:00:00', '2018-04-04 00:00:00', '2018-03-12', 3, 220.6, 'Königlich Essen'),
(222, 'WHITC', 1, '2018-03-10 00:00:00', '2018-04-07 00:00:00', '2018-03-14', 1, 300.9, 'White Clover Markets'),
(223, 'BONAP', 4, '2018-03-11 00:00:00', '2018-04-08 00:00:00', '2018-03-14', 2, 322.8, 'Bon app'),
(224, 'BSBEV', 2, '2018-03-11 00:00:00', '2018-04-08 00:00:00', '2018-03-18', 3, 227.95, 'Bs Beverages'),
(225, 'SEVES', 8, '2018-03-12 00:00:00', '2018-04-09 00:00:00', '2018-03-19', 1, 21, 'Seven Seas Imports'),
(226, 'ISLAT', 1, '2018-03-13 00:00:00', '2018-03-27 00:00:00', '2018-03-21', 3, 81.85, 'Island Trading'),
(227, 'PERIC', 5, '2018-03-13 00:00:00', '2018-04-10 00:00:00', '2018-03-21', 2, 417.45, 'Pericles Comidas clásicas'),
(228, 'SUPRD', 9, '2018-03-14 00:00:00', '2018-04-11 00:00:00', '2018-04-04', 1, 342.6, 'Suprêmes délices'),
(229, 'HILAA', 8, '2018-03-17 00:00:00', '2018-04-14 00:00:00', '2018-03-24', 3, 22.05, 'HILARIÓN-Abastos'),
(230, 'PRINI', 5, '2018-03-17 00:00:00', '2018-04-14 00:00:00', '2018-03-25', 2, 65.1, 'Princesa Isabel Vinhos'),
(231, 'VICTE', 2, '2018-03-18 00:00:00', '2018-04-01 00:00:00', '2018-03-26', 3, 24.05, 'Victuailles en stock'),
(232, 'RATTC', 3, '2018-03-19 00:00:00', '2018-04-16 00:00:00', '2018-03-21', 3, 3544.75, 'Rattlesnake Canyon Grocery'),
(233, 'FOLIG', 6, '2018-03-20 00:00:00', '2018-04-17 00:00:00', '2018-03-24', 2, 6.75, 'Folies gourmandes'),
(234, 'RICAR', 8, '2018-03-20 00:00:00', '2018-04-17 00:00:00', '2018-03-25', 2, 321.65, 'Ricardo Adocicados'),
(235, 'LAZYK', 1, '2018-03-21 00:00:00', '2018-04-18 00:00:00', '2018-04-10', 3, 37.4, 'Lazy K Kountry Store'),
(236, 'WHITC', 7, '2018-03-24 00:00:00', '2018-04-21 00:00:00', '2018-04-25', 2, 76.4, 'White Clover Markets'),
(237, 'BSBEV', 3, '2018-03-24 00:00:00', '2018-04-21 00:00:00', '2018-04-01', 3, 34.4, 'Bs Beverages'),
(238, 'LINOD', 4, '2018-03-25 00:00:00', '2018-04-08 00:00:00', '2018-03-31', 2, 322.25, 'LINO-Delicateses'),
(239, 'HILAA', 1, '2018-03-26 00:00:00', '2018-04-23 00:00:00', '2018-04-02', 2, 152.65, 'HILARIÓN-Abastos'),
(240, 'QUEEN', 2, '2018-03-26 00:00:00', '2018-04-23 00:00:00', '2018-03-28', 2, 355.35, 'Queen Cozinha'),
(241, 'FRANK', 8, '2018-03-27 00:00:00', '2018-04-24 00:00:00', '2018-04-02', 2, 24.65, 'Frankenversand'),
(242, 'PICCO', 6, '2018-03-28 00:00:00', '2018-04-25 00:00:00', '2018-04-09', 2, 26.45, 'Piccolo und mehr'),
(243, 'HILAA', 7, '2018-03-31 00:00:00', '2018-04-28 00:00:00', '2018-04-03', 2, 1050.95, 'HILARIÓN-Abastos'),
(244, 'FURIB', 8, '2018-03-31 00:00:00', '2018-04-28 00:00:00', '2018-04-08', 3, 84.8, 'Furia Bacalhau e Frutos do Mar'),
(245, 'BOTTM', 3, '2018-04-01 00:00:00', '2018-04-29 00:00:00', '2018-04-11', 1, 314.45, 'Bottom-Dollar Markets'),
(246, 'LAMAI', 4, '2018-04-02 00:00:00', '2018-04-30 00:00:00', '2018-04-10', 3, 53.2, 'La maison dAsie'),
(247, 'COMMI', 4, '2018-04-02 00:00:00', '2018-04-30 00:00:00', '2018-04-09', 2, 329.95, 'Comércio Mineiro'),
(248, 'LAUGB', 3, '2018-04-03 00:00:00', '2018-05-01 00:00:00', '2018-04-11', 3, 23.25, 'Laughing Bacchus Wine Cellars'),
(249, 'TRADH', 7, '2018-04-04 00:00:00', '2018-05-02 00:00:00', '2018-04-07', 2, 233.85, 'Tradição Hipermercados'),
(250, 'LEHMS', 7, '2018-04-04 00:00:00', '2018-05-02 00:00:00', '2018-04-07', 1, 181.05, 'Lehmanns Marktstand'),
(251, 'HILAA', 8, '2018-04-07 00:00:00', '2018-05-05 00:00:00', '2018-04-11', 2, 148.75, 'HILARIÓN-Abastos'),
(252, 'LILAS', 4, '2018-04-08 00:00:00', '2018-05-06 00:00:00', '2018-04-16', 2, 510.1, 'LILA-Supermercado'),
(253, 'LAMAI', 6, '2018-04-09 00:00:00', '2018-05-07 00:00:00', '2018-04-17', 1, 213.4, 'La maison dAsie'),
(254, 'BLAUS', 9, '2018-04-09 00:00:00', '2018-05-07 00:00:00', '2018-04-16', 3, 44.25, 'Blauer See Delikatessen'),
(255, 'PERIC', 2, '2018-04-10 00:00:00', '2018-05-08 00:00:00', '2018-04-29', 1, 346.6, 'Pericles Comidas clásicas'),
(256, 'HUNGO', 6, '2018-04-11 00:00:00', '2018-05-09 00:00:00', '2018-04-16', 2, 83.7, 'Hungry Owl All-Night Grocers'),
(257, 'WHITC', 4, '2018-04-11 00:00:00', '2018-05-09 00:00:00', '2018-04-18', 3, 295.65, 'White Clover Markets'),
(258, 'MEREP', 3, '2018-04-14 00:00:00', '2018-05-12 00:00:00', '2018-04-21', 3, 35.65, 'Mère Paillarde'),
(259, 'KOENE', 9, '2018-04-15 00:00:00', '2018-05-13 00:00:00', '2018-05-02', 2, 105.95, 'Königlich Essen'),
(260, 'ANTON', 7, '2018-04-15 00:00:00', '2018-05-13 00:00:00', '2018-04-22', 1, 237.25, 'Antonio Moreno Taquería'),
(261, 'OTTIK', 1, '2018-04-16 00:00:00', '2018-05-14 00:00:00', '2018-05-13', 2, 24.95, 'Ottilies Käseladen'),
(262, 'BLAUS', 4, '2018-04-17 00:00:00', '2018-05-15 00:00:00', '2018-04-29', 1, 0.75, 'Blauer See Delikatessen'),
(263, 'SAVEA', 6, '2018-04-18 00:00:00', '2018-05-16 00:00:00', '2018-04-28', 3, 1838.15, 'Save-a-lot Markets'),
(264, 'BONAP', 4, '2018-04-18 00:00:00', '2018-05-16 00:00:00', '2018-04-21', 3, 1753.2, 'Bon app'),
(265, 'FAMIA', 7, '2018-04-21 00:00:00', '2018-05-19 00:00:00', '2018-04-24', 2, 17.65, 'Familia Arquibaldo'),
(266, 'WANDK', 7, '2018-04-22 00:00:00', '2018-06-03 00:00:00', '2018-04-28', 1, 528.25, 'Die Wandernde Kuh'),
(267, 'ERNSH', 3, '2018-04-22 00:00:00', '2018-05-20 00:00:00', '2018-05-16', 2, 3949.75, 'Ernst Handel'),
(268, 'QUICK', 2, '2018-04-23 00:00:00', '2018-05-07 00:00:00', '2018-05-23', 1, 1022.35, 'QUICK-Stop'),
(269, 'HUNGO', 2, '2018-04-24 00:00:00', '2018-05-22 00:00:00', '2018-05-01', 3, 313.9, 'Hungry Owl All-Night Grocers'),
(270, 'NORTS', 3, '2018-04-24 00:00:00', '2018-05-22 00:00:00', '2018-04-29', 3, 160.35, 'North/South'),
(271, 'TORTU', 4, '2018-04-25 00:00:00', '2018-05-09 00:00:00', '2018-05-05', 2, 1090.75, 'Tortuga Restaurante'),
(272, 'CHOPS', 6, '2018-04-28 00:00:00', '2018-05-26 00:00:00', '2018-05-01', 3, 458.8, 'Chop-suey Chinese'),
(273, 'SANTG', 7, '2018-04-29 00:00:00', '2018-05-27 00:00:00', '2018-05-01', 1, 66.85, 'Santé Gourmet'),
(274, 'CACTU', 8, '2018-04-29 00:00:00', '2018-05-27 00:00:00', '2018-05-02', 2, 86.1, 'Cactus Comidas para llevar'),
(275, 'LEHMS', 4, '2018-04-30 00:00:00', '2018-05-28 00:00:00', '2018-05-06', 1, 226.65, 'Lehmanns Marktstand'),
(276, 'SEVES', 7, '2018-05-01 00:00:00', '2018-05-29 00:00:00', '2018-05-30', 2, 388.15, 'Seven Seas Imports'),
(277, 'BERGS', 1, '2018-05-01 00:00:00', '2018-05-29 00:00:00', '2018-05-07', 2, 1223.95, 'Berglunds snabbköp'),
(278, 'BONAP', 1, '2018-05-02 00:00:00', '2018-05-30 00:00:00', '2018-05-23', 2, 55.3, 'Bon app'),
(279, 'WARTH', 4, '2018-05-05 00:00:00', '2018-06-02 00:00:00', '2018-05-15', 2, 292.95, 'Wartian Herkku'),
(280, 'QUICK', 7, '2018-05-05 00:00:00', '2018-06-02 00:00:00', '2018-05-07', 1, 209.5, 'QUICK-Stop'),
(281, 'GREAL', 6, '2018-05-06 00:00:00', '2018-05-20 00:00:00', '2018-05-09', 2, 16.75, 'Great Lakes Food Market'),
(282, 'MAISD', 5, '2018-05-07 00:00:00', '2018-06-04 00:00:00', '2018-05-09', 2, 333.45, 'Maison Dewey'),
(283, 'PICCO', 3, '2018-05-08 00:00:00', '2018-06-05 00:00:00', '2018-05-12', 2, 1696.1, 'Piccolo und mehr'),
(284, 'OCEAN', 7, '2018-05-08 00:00:00', '2018-06-05 00:00:00', '2018-05-19', 1, 40.6, 'Océano Atlántico Ltda.'),
(285, 'EASTC', 7, '2018-05-09 00:00:00', '2018-06-06 00:00:00', '2018-05-12', 3, 372.3, 'Eastern Connection'),
(286, 'FOLKO', 8, '2018-05-12 00:00:00', '2018-06-09 00:00:00', '2018-05-22', 1, 940.2, 'Folk och fä HB'),
(287, 'LEHMS', 8, '2018-05-12 00:00:00', '2018-06-09 00:00:00', '2018-05-14', 2, 139.7, 'Lehmanns Marktstand'),
(288, 'ANTON', 4, '2018-05-13 00:00:00', '2018-06-10 00:00:00', '2018-05-21', 1, 78.2, 'Antonio Moreno Taquería'),
(289, 'LEHMS', 3, '2018-05-14 00:00:00', '2018-06-11 00:00:00', '2018-06-06', 2, 294.4, 'Lehmanns Marktstand'),
(290, 'RICSU', 1, '2018-05-14 00:00:00', '2018-05-28 00:00:00', '2018-05-19', 1, 394.25, 'Richter Supermarkt'),
(291, 'BSBEV', 9, '2018-05-15 00:00:00', '2018-06-12 00:00:00', '2018-05-16', 3, 24.35, 'Bs Beverages'),
(292, 'BSBEV', 6, '2018-05-16 00:00:00', '2018-06-13 00:00:00', '2018-05-23', 3, 61.8, 'Bs Beverages'),
(293, 'QUICK', 3, '2018-05-19 00:00:00', '2018-06-16 00:00:00', '2018-06-13', 3, 5038.2, 'QUICK-Stop'),
(294, 'HANAR', 2, '2018-05-19 00:00:00', '2018-06-16 00:00:00', '2018-05-29', 1, 343.25, 'Hanari Carnes'),
(295, 'KOENE', 1, '2018-05-20 00:00:00', '2018-06-17 00:00:00', '2018-05-26', 3, 54.75, 'Königlich Essen'),
(296, 'LILAS', 8, '2018-05-21 00:00:00', '2018-06-18 00:00:00', '2018-05-23', 2, 240.85, 'LILA-Supermercado'),
(297, 'LONEP', 4, '2018-05-21 00:00:00', '2018-06-18 00:00:00', '2018-05-30', 1, 124.55, 'Lonesome Pine Restaurant'),
(298, 'LAZYK', 8, '2018-05-22 00:00:00', '2018-06-19 00:00:00', '2018-06-26', 2, 59.6, 'Lazy K Kountry Store'),
(299, 'VICTE', 1, '2018-05-23 00:00:00', '2018-06-20 00:00:00', '2018-05-27', 3, 973.6, 'Victuailles en stock'),
(300, 'SEVES', 3, '2018-05-23 00:00:00', '2018-06-20 00:00:00', '2018-06-02', 2, 892.15, 'Seven Seas Imports'),
(301, 'TOMSP', 3, '2018-05-26 00:00:00', '2018-06-23 00:00:00', '2018-06-02', 2, 7.15, 'Toms Spezialitäten'),
(302, 'QUICK', 5, '2018-05-27 00:00:00', '2018-06-10 00:00:00', '2018-05-30', 1, 856.2, 'QUICK-Stop'),
(303, 'GODOS', 7, '2018-05-28 00:00:00', '2018-06-25 00:00:00', '2018-06-06', 3, 21.6, 'Godos Cocina Típica'),
(304, 'FURIB', 4, '2018-05-28 00:00:00', '2018-07-09 00:00:00', '2018-06-06', 3, 364.75, 'Furia Bacalhau e Frutos do Mar'),
(305, 'HILAA', 2, '2018-05-29 00:00:00', '2018-06-26 00:00:00', '2018-06-05', 1, 416.1, 'HILARIÓN-Abastos'),
(306, 'WARTH', 2, '2018-05-30 00:00:00', '2018-06-27 00:00:00', '2018-06-03', 2, 747.45, 'Wartian Herkku'),
(307, 'OTTIK', 4, '2018-05-30 00:00:00', '2018-06-27 00:00:00', '2018-06-05', 3, 604.85, 'Ottilies Käseladen'),
(308, 'SAVEA', 6, '2018-06-02 00:00:00', '2018-06-30 00:00:00', '2018-06-04', 3, 1262.45, 'Save-a-lot Markets'),
(309, 'SIMOB', 2, '2018-06-03 00:00:00', '2018-07-15 00:00:00', '2018-06-13', 1, 49, 'Simons bistro'),
(310, 'LEHMS', 9, '2018-06-03 00:00:00', '2018-06-17 00:00:00', '2018-06-06', 2, 483.6, 'Lehmanns Marktstand'),
(311, 'AROUT', 1, '2018-06-04 00:00:00', '2018-07-02 00:00:00', '2018-06-10', 2, 364.85, 'Around the Horn'),
(312, 'BLONP', 6, '2018-06-05 00:00:00', '2018-07-03 00:00:00', '2018-06-13', 1, 40.25, 'Blondel père et fils'),
(313, 'FRANK', 8, '2018-06-06 00:00:00', '2018-07-04 00:00:00', '2018-06-09', 1, 183.25, 'Frankenversand'),
(314, 'FOLKO', 2, '2018-06-06 00:00:00', '2018-07-04 00:00:00', '2018-06-09', 2, 1211.05, 'Folk och fä HB'),
(315, 'REGGC', 1, '2018-06-09 00:00:00', '2018-07-07 00:00:00', '2018-06-12', 1, 114.75, 'Reggiani Caseifici'),
(316, 'RICAR', 2, '2018-06-10 00:00:00', '2018-07-22 00:00:00', '2018-06-24', 2, 302.15, 'Ricardo Adocicados'),
(317, 'RATTC', 4, '2018-06-10 00:00:00', '2018-07-08 00:00:00', '2018-06-16', 3, 68.75, 'Rattlesnake Canyon Grocery'),
(318, 'MEREP', 8, '2018-06-11 00:00:00', '2018-07-09 00:00:00', '2018-06-18', 2, 35.75, 'Mère Paillarde'),
(319, 'BLONP', 9, '2018-06-12 00:00:00', '2018-07-10 00:00:00', '2018-06-18', 1, 442, 'Blondel père et fils'),
(320, 'HUNGO', 1, '2018-06-12 00:00:00', '2018-07-10 00:00:00', '2018-06-17', 1, 169.85, 'Hungry Owl All-Night Grocers'),
(321, 'GALED', 3, '2018-06-13 00:00:00', '2018-07-11 00:00:00', '2018-07-09', 3, 32.7, 'Galería del gastronómo'),
(322, 'RATTC', 5, '2018-06-16 00:00:00', '2018-07-14 00:00:00', '2018-07-11', 1, 294.9, 'Rattlesnake Canyon Grocery'),
(323, 'MEREP', 3, '2018-06-17 00:00:00', '2018-07-15 00:00:00', '2018-06-19', 3, 944.95, 'Mère Paillarde'),
(324, 'ERNSH', 8, '2018-06-17 00:00:00', '2018-07-29 00:00:00', '2018-07-04', 3, 130.3, 'Ernst Handel'),
(325, 'BERGS', 3, '2018-06-18 00:00:00', '2018-07-16 00:00:00', '2018-06-25', 2, 582.15, 'Berglunds snabbköp'),
(326, 'ANTON', 7, '2018-06-19 00:00:00', '2018-07-17 00:00:00', '2018-06-20', 3, 424.2, 'Antonio Moreno Taquería'),
(327, 'TRAIH', 4, '2018-06-19 00:00:00', '2018-07-17 00:00:00', '2018-06-30', 2, 188, 'Trails Head Gourmet Provisioners'),
(328, 'MORGK', 5, '2018-06-20 00:00:00', '2018-07-04 00:00:00', '2018-06-30', 1, 636.7, 'Morgenstern Gesundkost'),
(329, 'TORTU', 3, '2018-06-23 00:00:00', '2018-07-07 00:00:00', '2018-06-30', 3, 92.8, 'Tortuga Restaurante'),
(330, 'TRAIH', 9, '2018-06-23 00:00:00', '2018-08-04 00:00:00', '2018-06-30', 2, 127.05, 'Trails Head Gourmet Provisioners'),
(331, 'BSBEV', 4, '2018-06-24 00:00:00', '2018-07-22 00:00:00', '2018-07-25', 3, 148, 'Bs Beverages'),
(332, 'LETSS', 1, '2018-06-25 00:00:00', '2018-07-23 00:00:00', '2018-07-04', 2, 68.65, 'Lets Stop N Shop'),
(333, 'OTTIK', 4, '2018-06-26 00:00:00', '2018-07-24 00:00:00', '2018-07-01', 3, 379.45, 'Ottilies Käseladen'),
(334, 'FAMIA', 3, '2018-06-26 00:00:00', '2018-07-24 00:00:00', '2018-07-02', 1, 15.05, 'Familia Arquibaldo'),
(335, 'BLAUS', 3, '2018-06-27 00:00:00', '2018-07-25 00:00:00', '2018-07-14', 2, 138.55, 'Blauer See Delikatessen'),
(336, 'WARTH', 2, '2018-06-30 00:00:00', '2018-07-28 00:00:00', '2018-07-04', 2, 36.4, 'Wartian Herkku'),
(337, 'BLONP', 4, '2018-06-30 00:00:00', '2018-07-28 00:00:00', '2018-07-04', 1, 295.7, 'Blondel père et fils'),
(338, 'WELLI', 7, '2018-07-01 00:00:00', '2018-07-29 00:00:00', '2018-07-10', 1, 67.05, 'Wellington Importadora'),
(339, 'REGGC', 9, '2018-07-02 00:00:00', '2018-07-30 00:00:00', '2018-07-09', 1, 2.4, 'Reggiani Caseifici'),
(340, 'QUEDE', 1, '2018-07-02 00:00:00', '2018-07-30 00:00:00', '2018-07-09', 1, 312.6, 'Que Delícia'),
(341, 'QUICK', 2, '2018-07-03 00:00:00', '2018-07-31 00:00:00', '2018-07-10', 3, 973.35, 'QUICK-Stop'),
(342, 'GREAL', 8, '2018-07-04 00:00:00', '2018-08-01 00:00:00', '2018-07-14', 2, 22.1, 'Great Lakes Food Market'),
(343, 'MEREP', 4, '2018-07-07 00:00:00', '2018-08-04 00:00:00', '2018-07-14', 3, 223.85, 'Mère Paillarde'),
(344, 'VAFFE', 1, '2018-07-07 00:00:00', '2018-07-21 00:00:00', '2018-07-16', 1, 279.6, 'Vaffeljernet'),
(345, 'LEHMS', 3, '2018-07-08 00:00:00', '2018-08-05 00:00:00', '2018-07-16', 1, 160.5, 'Lehmanns Marktstand');


INSERT INTO commandes (pk_commande, fk_client, NumEmploye, DateCommande, LivrerAvant, DateEnvoi, NumMessager, Port, Destinataire) VALUES
(346, 'LEHMS', 7, '2018-07-09 00:00:00', '2018-08-06 00:00:00', '2018-08-13', 2, 871, 'Lehmanns Marktstand'),
(347, 'OLDWO', 3, '2018-07-09 00:00:00', '2018-08-06 00:00:00', '2018-07-16', 2, 26.2, 'Old World Delicatessen'),
(348, 'ERNSH', 2, '2018-07-10 00:00:00', '2018-08-07 00:00:00', '2018-07-14', 1, 483.9, 'Ernst Handel'),
(349, 'WHITC', 8, '2018-07-11 00:00:00', '2018-08-08 00:00:00', '2018-08-12', 1, 81.7, 'White Clover Markets'),
(350, 'PICCO', 7, '2018-07-11 00:00:00', '2018-08-08 00:00:00', '2018-07-18', 3, 175.6, 'Piccolo und mehr'),
(351, 'RATTC', 1, '2018-07-14 00:00:00', '2018-08-11 00:00:00', '2018-07-18', 3, 222.1, 'Rattlesnake Canyon Grocery'),
(352, 'BSBEV', 6, '2018-07-15 00:00:00', '2018-08-26 00:00:00', '2018-07-21', 3, 149.9, 'Bs Beverages'),
(353, 'HUNGC', 4, '2018-07-16 00:00:00', '2018-08-13 00:00:00', '2018-07-21', 1, 225.65, 'Hungry Coyote Import Store'),
(354, 'HILAA', 7, '2018-07-16 00:00:00', '2018-08-27 00:00:00', '2018-07-22', 1, 291.5, 'HILARIÓN-Abastos'),
(355, 'VAFFE', 8, '2018-07-17 00:00:00', '2018-08-14 00:00:00', '2018-07-22', 2, 14.6, 'Vaffeljernet'),
(356, 'SAVEA', 8, '2018-07-18 00:00:00', '2018-08-15 00:00:00', '2018-08-08', 2, 243.85, 'Save-a-lot Markets'),
(357, 'FURIB', 1, '2018-07-18 00:00:00', '2018-08-15 00:00:00', '2018-07-29', 1, 37.3, 'Furia Bacalhau e Frutos do Mar'),
(358, 'MEREP', 1, '2018-07-21 00:00:00', '2018-08-18 00:00:00', '2018-07-29', 2, 1895.65, 'Mère Paillarde'),
(359, 'TRADH', 4, '2018-07-22 00:00:00', '2018-08-19 00:00:00', '2018-07-31', 3, 397, 'Tradição Hipermercados'),
(360, 'SAVEA', 5, '2018-07-22 00:00:00', '2018-08-19 00:00:00', '2018-07-25', 1, 1001.2, 'Save-a-lot Markets'),
(361, 'TOMSP', 4, '2018-07-23 00:00:00', '2018-08-20 00:00:00', '2018-08-01', 2, 138.95, 'Toms Spezialitäten'),
(362, 'DUMON', 7, '2018-07-24 00:00:00', '2018-08-21 00:00:00', '2018-07-30', 2, 9.25, 'Du monde entier'),
(363, 'LAMAI', 8, '2018-07-25 00:00:00', '2018-08-22 00:00:00', '2018-08-06', 1, 133.9, 'La maison dAsie'),
(364, 'WOLZA', 6, '2018-07-25 00:00:00', '2018-08-22 00:00:00', '2018-08-01', 2, 403.25, 'Wolski Zajazd'),
(365, 'SAVEA', 1, '2018-07-28 00:00:00', '2018-08-25 00:00:00', '2018-08-01', 2, 2720.4, 'Save-a-lot Markets'),
(366, 'HILAA', 4, '2018-07-29 00:00:00', '2018-08-26 00:00:00', '2018-08-01', 2, 40.55, 'HILARIÓN-Abastos'),
(367, 'BLAUS', 8, '2018-07-29 00:00:00', '2018-08-26 00:00:00', '2018-08-01', 3, 9.65, 'Blauer See Delikatessen'),
(368, 'WILMK', 2, '2018-07-30 00:00:00', '2018-08-27 00:00:00', '2018-08-06', 3, 3.75, 'Wilman Kala'),
(369, 'GREAL', 1, '2018-07-31 00:00:00', '2018-08-28 00:00:00', '2018-08-05', 2, 582.65, 'Great Lakes Food Market'),
(370, 'GREAL', 4, '2018-07-31 00:00:00', '2018-08-28 00:00:00', '2018-08-04', 2, 92.65, 'Great Lakes Food Market'),
(371, 'MEREP', 1, '2018-08-01 00:00:00', '2018-09-12 00:00:00', '2018-08-08', 1, 773.4, 'Mère Paillarde'),
(372, 'MEREP', 3, '2018-08-04 00:00:00', '2018-09-01 00:00:00', '2018-08-07', 3, 455.25, 'Mère Paillarde'),
(373, 'LAUGB', 2, '2018-08-05 00:00:00', '2018-09-02 00:00:00', '2018-08-14', 3, 4.7, 'Laughing Bacchus Wine Cellars'),
(374, 'ISLAT', 4, '2018-08-05 00:00:00', '2018-09-02 00:00:00', '2018-08-11', 2, 118.65, 'Island Trading'),
(375, 'RICAR', 4, '2018-08-06 00:00:00', '2018-09-03 00:00:00', '2018-08-11', 3, 254.85, 'Ricardo Adocicados'),
(376, 'FRANK', 8, '2018-08-07 00:00:00', '2018-09-04 00:00:00', '2018-08-12', 2, 485.9, 'Frankenversand'),
(377, 'THECR', 4, '2018-08-07 00:00:00', '2018-09-04 00:00:00', '2018-08-19', 2, 474, 'The Cracker Box'),
(378, 'ANATR', 3, '2018-08-08 00:00:00', '2018-09-05 00:00:00', '2018-08-14', 1, 219.5, 'Ana Trujillo Emparedados y helados'),
(379, 'BERGS', 1, '2018-08-11 00:00:00', '2018-09-08 00:00:00', '2018-08-20', 2, 693.45, 'Berglunds snabbköp'),
(380, 'SAVEA', 8, '2018-08-11 00:00:00', '2018-09-22 00:00:00', '2018-08-21', 3, 537.3, 'Save-a-lot Markets'),
(381, 'BLONP', 4, '2018-08-12 00:00:00', '2018-09-09 00:00:00', '2018-08-20', 3, 151.8, 'Blondel père et fils'),
(382, 'GODOS', 4, '2018-08-12 00:00:00', '2018-09-09 00:00:00', '2018-08-20', 3, 427.3, 'Godos Cocina Típica'),
(383, 'KOENE', 1, '2018-08-13 00:00:00', '2018-09-10 00:00:00', '2018-08-19', 2, 161.75, 'Königlich Essen'),
(384, 'LAMAI', 8, '2018-08-14 00:00:00', '2018-09-11 00:00:00', '2018-08-15', 1, 4.35, 'La maison dAsie'),
(385, 'WANDK', 8, '2018-08-14 00:00:00', '2018-09-11 00:00:00', '2018-08-19', 1, 206.9, 'Die Wandernde Kuh'),
(386, 'ERNSH', 7, '2018-08-15 00:00:00', '2018-09-12 00:00:00', '2018-08-18', 3, 2389.5, 'Ernst Handel'),
(387, 'FOLIG', 4, '2018-08-15 00:00:00', '2018-09-12 00:00:00', '2018-08-21', 3, 2436.9, 'Folies gourmandes'),
(388, 'MAGAA', 8, '2018-08-18 00:00:00', '2018-09-15 00:00:00', '2018-08-21', 3, 237.3, 'Magazzini Alimentari Riuniti'),
(389, 'WARTH', 4, '2018-08-19 00:00:00', '2018-09-16 00:00:00', '2018-08-26', 1, 5.75, 'Wartian Herkku'),
(390, 'QUEEN', 6, '2018-08-19 00:00:00', '2018-09-16 00:00:00', '2018-08-26', 1, 1006.45, 'Queen Cozinha'),
(391, 'LINOD', 3, '2018-08-20 00:00:00', '2018-09-17 00:00:00', '2018-09-01', 1, 792.2, 'LINO-Delicateses'),
(392, 'SANTG', 7, '2018-08-20 00:00:00', '2018-09-17 00:00:00', '2018-08-27', 3, 193.2, 'Santé Gourmet'),
(393, 'WANDK', 4, '2018-08-21 00:00:00', '2018-09-18 00:00:00', '2018-08-28', 1, 117.75, 'Die Wandernde Kuh'),
(394, 'HILAA', 4, '2018-08-22 00:00:00', '2018-09-19 00:00:00', '2018-08-26', 2, 898.05, 'HILARIÓN-Abastos'),
(395, 'SIMOB', 7, '2018-08-22 00:00:00', '2018-09-19 00:00:00', '2018-09-05', 3, 209.45, 'Simons bistro'),
(396, 'AROUT', 6, '2018-08-25 00:00:00', '2018-09-22 00:00:00', '2018-09-02', 1, 147.3, 'Around the Horn'),
(397, 'WELLI', 3, '2018-08-25 00:00:00', '2018-09-22 00:00:00', '2018-09-01', 2, 0.7, 'Wellington Importadora'),
(398, 'HANAR', 4, '2018-08-26 00:00:00', '2018-09-23 00:00:00', '2018-09-02', 1, 62.05, 'Hanari Carnes'),
(399, 'HUNGO', 9, '2018-08-27 00:00:00', '2018-10-08 00:00:00', '2018-09-03', 3, 711.65, 'Hungry Owl All-Night Grocers'),
(400, 'QUEDE', 4, '2018-08-27 00:00:00', '2018-09-10 00:00:00', '2018-09-03', 2, 227.7, 'Que Delícia'),
(401, 'RICAR', 5, '2018-08-28 00:00:00', '2018-10-09 00:00:00', '2018-09-09', 2, 71.25, 'Ricardo Adocicados'),
(402, 'MAISD', 5, '2018-08-28 00:00:00', '2018-09-25 00:00:00', '2018-08-29', 3, 31, 'Maison Dewey'),
(403, 'FAMIA', 5, '2018-08-29 00:00:00', '2018-09-26 00:00:00', '2018-09-03', 3, 884.05, 'Familia Arquibaldo'),
(404, 'WANDK', 8, '2018-09-01 00:00:00', '2018-09-29 00:00:00', '2018-09-11', 2, 103, 'Die Wandernde Kuh'),
(405, 'GOURL', 4, '2018-09-01 00:00:00', '2018-09-29 00:00:00', '2018-09-08', 2, 35.7, 'Gourmet Lanchonetes'),
(406, 'FRANK', 1, '2018-09-02 00:00:00', '2018-09-30 00:00:00', '2018-09-19', 1, 466.25, 'Frankenversand'),
(407, 'BERGS', 5, '2018-09-02 00:00:00', '2018-09-30 00:00:00', '2018-09-11', 1, 276.3, 'Berglunds snabbköp'),
(408, 'REGGC', 1, '2018-09-03 00:00:00', '2018-10-01 00:00:00', '2018-09-11', 2, 22.05, 'Reggiani Caseifici'),
(409, 'GREAL', 6, '2018-09-04 00:00:00', '2018-10-02 00:00:00', '2018-09-10', 1, 285.75, 'Great Lakes Food Market'),
(410, 'SAVEA', 2, '2018-09-04 00:00:00', '2018-10-02 00:00:00', '2018-09-15', 2, 1763.45, 'Save-a-lot Markets'),
(411, 'QUICK', 4, '2018-09-05 00:00:00', '2018-10-03 00:00:00', '2018-09-08', 1, 1820.75, 'QUICK-Stop'),
(412, 'QUEEN', 7, '2018-09-05 00:00:00', '2018-10-03 00:00:00', '2018-09-10', 2, 529.05, 'Queen Cozinha'),
(413, 'HUNGC', 8, '2018-09-08 00:00:00', '2018-10-06 00:00:00', '2018-10-15', 1, 556.45, 'Hungry Coyote Import Store'),
(414, 'HUNGO', 7, '2018-09-09 00:00:00', '2018-10-07 00:00:00', '2018-09-15', 3, 87.75, 'Hungry Owl All-Night Grocers'),
(416, 'BONAP', 2, '2018-09-10 00:00:00', '2018-09-24 00:00:00', '2018-10-03', 2, 565.75, 'Bon app'),
(417, 'FURIB', 1, '2018-09-10 00:00:00', '2018-10-08 00:00:00', '2018-09-19', 3, 6.35, 'Furia Bacalhau e Frutos do Mar'),
(418, 'LONEP', 1, '2018-09-11 00:00:00', '2018-10-09 00:00:00', '2018-09-17', 2, 131.55, 'Lonesome Pine Restaurant'),
(419, 'RICSU', 7, '2018-09-12 00:00:00', '2018-10-10 00:00:00', '2018-09-22', 2, 1162.1, 'Richter Supermarkt'),
(420, 'ERNSH', 7, '2018-09-12 00:00:00', '2018-10-10 00:00:00', '2018-09-19', 1, 390.45, 'Ernst Handel'),
(421, 'WANDK', 1, '2018-09-15 00:00:00', '2018-10-13 00:00:00', '2018-09-23', 2, 236.1, 'Die Wandernde Kuh'),
(422, 'SIMOB', 2, '2018-09-15 00:00:00', '2018-10-13 00:00:00', '2018-09-22', 1, 121.95, 'Simons bistro'),
(423, 'FRANK', 4, '2018-09-16 00:00:00', '2018-10-14 00:00:00', '2018-09-18', 1, 1017.4, 'Frankenversand'),
(424, 'FRANR', 1, '2018-09-17 00:00:00', '2018-10-15 00:00:00', '2018-09-24', 1, 151.7, 'France restauration'),
(425, 'BERGS', 9, '2018-09-17 00:00:00', '2018-10-01 00:00:00', '2018-09-26', 2, 478.75, 'Berglunds snabbköp'),
(426, 'WILMK', 2, '2018-09-18 00:00:00', '2018-10-16 00:00:00', '2018-09-19', 1, 113.8, 'Wilman Kala'),
(427, 'ISLAT', 4, '2018-09-18 00:00:00', '2018-10-16 00:00:00', '2018-09-30', 2, 4.5, 'Island Trading'),
(428, 'FRANK', 5, '2018-09-19 00:00:00', '2018-10-17 00:00:00', '2018-09-23', 2, 159.25, 'Frankenversand'),
(429, 'TORTU', 2, '2018-09-22 00:00:00', '2018-10-20 00:00:00', '2018-09-29', 2, 10.05, 'Tortuga Restaurante'),
(430, 'ANTON', 1, '2018-09-22 00:00:00', '2018-10-20 00:00:00', '2018-09-26', 3, 20.15, 'Antonio Moreno Taquería'),
(431, 'SAVEA', 7, '2018-09-23 00:00:00', '2018-10-21 00:00:00', '2018-10-16', 3, 1944.9, 'Save-a-lot Markets'),
(432, 'BLONP', 8, '2018-09-23 00:00:00', '2018-10-21 00:00:00', '2018-09-30', 3, 139.7, 'Blondel père et fils'),
(433, 'OLDWO', 1, '2018-09-24 00:00:00', '2018-10-22 00:00:00', '2018-09-26', 1, 133.05, 'Old World Delicatessen'),
(434, 'GREAL', 3, '2018-09-25 00:00:00', '2018-10-23 00:00:00', '2018-09-30', 3, 380.65, 'Great Lakes Food Market'),
(435, 'ANTON', 3, '2018-09-25 00:00:00', '2018-10-23 00:00:00', '2018-10-01', 2, 180.65, 'Antonio Moreno Taquería'),
(436, 'DUMON', 2, '2018-09-26 00:00:00', '2018-10-24 00:00:00', '2018-10-01', 1, 22, 'Du monde entier'),
(437, 'OTTIK', 3, '2018-09-26 00:00:00', '2018-10-24 00:00:00', '2018-09-30', 1, 728.15, 'Ottilies Käseladen'),
(438, 'GOURL', 4, '2018-09-29 00:00:00', '2018-10-13 00:00:00', '2018-10-03', 2, 168.75, 'Gourmet Lanchonetes'),
(439, 'PICCO', 2, '2018-09-30 00:00:00', '2018-10-28 00:00:00', '2018-10-08', 1, 482.5, 'Piccolo und mehr'),
(440, 'HUNGO', 9, '2018-09-30 00:00:00', '2018-10-28 00:00:00', '2018-10-30', 2, 1482.15, 'Hungry Owl All-Night Grocers'),
(441, 'VAFFE', 4, '2018-10-01 00:00:00', '2018-10-15 00:00:00', '2018-10-07', 2, 1495.45, 'Vaffeljernet'),
(442, 'BERGS', 1, '2018-10-01 00:00:00', '2018-10-29 00:00:00', '2018-10-07', 2, 67.1, 'Berglunds snabbköp'),
(443, 'HANAR', 1, '2018-10-02 00:00:00', '2018-10-30 00:00:00', '2018-10-03', 1, 79, 'Hanari Carnes'),
(444, 'QUICK', 2, '2018-10-03 00:00:00', '2018-11-14 00:00:00', '2018-10-22', 2, 4050.25, 'QUICK-Stop'),
(445, 'BSBEV', 4, '2018-10-03 00:00:00', '2018-10-31 00:00:00', '2018-10-13', 2, 305.1, 'Bs Beverages'),
(446, 'WHITC', 3, '2018-10-06 00:00:00', '2018-10-20 00:00:00', '2018-10-10', 3, 696.7, 'White Clover Markets'),
(447, 'QUICK', 8, '2018-10-06 00:00:00', '2018-11-03 00:00:00', '2018-10-09', 3, 1991.8, 'QUICK-Stop'),
(448, 'WILMK', 7, '2018-10-07 00:00:00', '2018-11-18 00:00:00', '2018-10-14', 1, 83.6, 'Wilman Kala'),
(449, 'WHITC', 8, '2018-10-08 00:00:00', '2018-11-19 00:00:00', '2018-10-14', 3, 512.75, 'White Clover Markets'),
(450, 'LINOD', 3, '2018-10-08 00:00:00', '2018-11-05 00:00:00', '2018-10-14', 1, 227.6, 'LINO-Delicateses'),
(451, 'ERNSH', 4, '2018-10-09 00:00:00', '2018-11-06 00:00:00', '2018-10-17', 1, 1362.35, 'Ernst Handel'),
(452, 'MORGK', 3, '2018-10-09 00:00:00', '2018-11-06 00:00:00', '2018-10-13', 3, 2.9, 'Morgenstern Gesundkost'),
(453, 'SAVEA', 3, '2018-10-10 00:00:00', '2018-11-07 00:00:00', '2018-10-16', 1, 325.5, 'Save-a-lot Markets'),
(454, 'HUNGO', 6, '2018-10-13 00:00:00', '2018-10-27 00:00:00', '2018-10-15', 3, 1101.55, 'Hungry Owl All-Night Grocers'),
(455, 'ALFKI', 4, '2018-10-13 00:00:00', '2018-11-24 00:00:00', '2018-10-21', 1, 119.7, 'Alfreds Futterkiste'),
(456, 'FOLKO', 6, '2018-10-14 00:00:00', '2018-11-11 00:00:00', '2018-10-20', 2, 761.5, 'Folk och fä HB'),
(457, 'QUEEN', 6, '2018-10-14 00:00:00', '2018-11-11 00:00:00', '2018-11-07', 1, 23.9, 'Queen Cozinha'),
(458, 'HILAA', 9, '2018-10-15 00:00:00', '2018-11-12 00:00:00', '2018-11-18', 2, 17.6, 'HILARIÓN-Abastos'),
(459, 'OLDWO', 8, '2018-10-16 00:00:00', '2018-11-13 00:00:00', '2018-10-21', 3, 678.15, 'Old World Delicatessen'),
(460, 'AROUT', 4, '2018-10-16 00:00:00', '2018-10-30 00:00:00', '2018-10-23', 3, 108.7, 'Around the Horn'),
(461, 'THEBI', 6, '2018-10-17 00:00:00', '2018-11-28 00:00:00', '2018-11-05', 2, 14.8, 'The Big Cheese'),
(462, 'GOURL', 1, '2018-10-17 00:00:00', '2018-11-14 00:00:00', '2018-11-20', 3, 1054, 'Gourmet Lanchonetes'),
(463, 'FRANS', 1, '2018-10-20 00:00:00', '2018-11-17 00:00:00', '2018-10-23', 1, 24.9, 'Franchi S.p.A.'),
(464, 'SAVEA', 5, '2018-10-21 00:00:00', '2018-12-02 00:00:00', '2018-10-29', 2, 262.05, 'Save-a-lot Markets'),
(465, 'HUNGO', 3, '2018-10-21 00:00:00', '2018-11-18 00:00:00', '2018-10-31', 1, 449.65, 'Hungry Owl All-Night Grocers'),
(466, 'SAVEA', 1, '2018-10-22 00:00:00', '2018-11-19 00:00:00', '2018-10-24', 1, 835.25, 'Save-a-lot Markets'),
(467, 'SAVEA', 5, '2018-10-22 00:00:00', '2018-11-19 00:00:00', '2018-10-27', 3, 122.45, 'Save-a-lot Markets'),
(468, 'BONAP', 3, '2018-10-23 00:00:00', '2018-11-06 00:00:00', '2018-10-29', 1, 316, 'Bon app'),
(469, 'RANCH', 4, '2018-10-24 00:00:00', '2018-11-21 00:00:00', '2018-10-27', 2, 112.85, 'Rancho grande'),
(470, 'FRANK', 1, '2018-10-24 00:00:00', '2018-11-21 00:00:00', '2018-10-29', 2, 296.25, 'Frankenversand'),
(471, 'KOENE', 1, '2018-10-27 00:00:00', '2018-11-24 00:00:00', '2018-10-29', 3, 854.4, 'Königlich Essen'),
(472, 'LETSS', 8, '2018-10-27 00:00:00', '2018-11-24 00:00:00', '2018-11-05', 2, 257.2, 'Lets Stop N Shop'),
(473, 'QUEDE', 8, '2018-10-28 00:00:00', '2018-11-11 00:00:00', '2018-11-05', 2, 47.65, 'Que Delícia'),
(474, 'QUICK', 5, '2018-10-29 00:00:00', '2018-11-26 00:00:00', '2018-10-31', 3, 244.6, 'QUICK-Stop'),
(475, 'SAVEA', 8, '2018-10-29 00:00:00', '2018-12-10 00:00:00', '2018-11-04', 1, 372.9, 'Save-a-lot Markets'),
(476, 'WHITC', 3, '2018-10-30 00:00:00', '2018-11-27 00:00:00', '2018-11-25', 1, 108.6, 'White Clover Markets'),
(477, 'MEREP', 8, '2018-10-30 00:00:00', '2018-12-11 00:00:00', '2018-11-05', 2, 288.75, 'Mère Paillarde'),
(478, 'FAMIA', 4, '2018-10-31 00:00:00', '2018-11-28 00:00:00', '2018-11-05', 3, 54.15, 'Familia Arquibaldo'),
(479, 'EASTC', 4, '2018-11-03 00:00:00', '2018-11-17 00:00:00', '2018-12-05', 1, 82.8, 'Eastern Connection'),
(480, 'REGGC', 2, '2018-11-03 00:00:00', '2018-12-01 00:00:00', '2018-12-05', 1, 449.5, 'Reggiani Caseifici'),
(481, 'QUEEN', 4, '2018-11-04 00:00:00', '2018-12-02 00:00:00', '2018-11-11', 2, 291.65, 'Queen Cozinha'),
(482, 'LINOD', 8, '2018-11-04 00:00:00', '2018-12-16 00:00:00', '2018-11-14', 3, 705.3, 'LINO-Delicateses'),
(483, 'BONAP', 5, '2018-11-05 00:00:00', '2018-12-03 00:00:00', '2018-11-14', 1, 100.6, 'Bon app'),
(484, 'CHOPS', 7, '2018-11-06 00:00:00', '2018-12-04 00:00:00', '2018-11-14', 1, 483.25, 'Chop-suey Chinese'),
(485, 'BONAP', 3, '2018-11-06 00:00:00', '2018-12-04 00:00:00', '2018-11-07', 1, 84.85, 'Bon app'),
(486, 'BERGS', 1, '2018-11-07 00:00:00', '2018-12-05 00:00:00', '2018-11-10', 3, 550.55, 'Berglunds snabbköp'),
(487, 'GOURL', 2, '2018-11-07 00:00:00', '2018-12-05 00:00:00', '2018-11-12', 3, 8.15, 'Gourmet Lanchonetes'),
(488, 'LETSS', 6, '2018-11-10 00:00:00', '2018-12-08 00:00:00', '2018-11-21', 2, 229.85, 'Lets Stop N Shop'),
(489, 'HUNGO', 9, '2018-11-11 00:00:00', '2018-12-09 00:00:00', '2018-11-21', 2, 220.5, 'Hungry Owl All-Night Grocers'),
(490, 'VINET', 2, '2018-11-11 00:00:00', '2018-12-09 00:00:00', '2018-11-18', 2, 38.95, 'Vins et alcools Chevalier'),
(491, 'SPECD', 2, '2018-11-12 00:00:00', '2018-12-10 00:00:00', '2018-11-18', 1, 14.55, 'Spécialités du monde'),
(492, 'VINET', 3, '2018-11-12 00:00:00', '2018-12-10 00:00:00', '2018-11-17', 3, 55.4, 'Vins et alcools Chevalier'),
(493, 'WHITC', 4, '2018-11-13 00:00:00', '2018-12-11 00:00:00', '2018-11-25', 2, 409.4, 'White Clover Markets'),
(494, 'AROUT', 4, '2018-11-14 00:00:00', '2018-11-28 00:00:00', '2018-11-18', 3, 54.8, 'Around the Horn'),
(495, 'BOTTM', 3, '2018-11-14 00:00:00', '2018-12-12 00:00:00', '2018-11-18', 3, 1218.65, 'Bottom-Dollar Markets'),
(496, 'AROUT', 1, '2018-11-17 00:00:00', '2018-12-15 00:00:00', '2018-11-21', 2, 118.6, 'Around the Horn'),
(497, 'VAFFE', 6, '2018-11-17 00:00:00', '2018-12-15 00:00:00', '2018-11-24', 1, 345.95, 'Vaffeljernet'),
(498, 'QUICK', 9, '2018-11-18 00:00:00', '2018-12-16 00:00:00', '2018-11-27', 1, 17.6, 'QUICK-Stop'),
(499, 'CHOPS', 1, '2018-11-19 00:00:00', '2018-12-17 00:00:00', '2018-11-21', 3, 157.15, 'Chop-suey Chinese'),
(500, 'PICCO', 6, '2018-11-19 00:00:00', '2018-12-17 00:00:00', '2018-11-26', 1, 586.65, 'Piccolo und mehr'),
(501, 'SAVEA', 3, '2018-11-20 00:00:00', '2018-12-18 00:00:00', '2018-11-28', 1, 1162.75, 'Save-a-lot Markets'),
(502, 'ISLAT', 4, '2018-11-20 00:00:00', '2018-12-18 00:00:00', '2018-12-19', 2, 307.65, 'Island Trading'),
(503, 'WARTH', 9, '2018-11-21 00:00:00', '2018-12-19 00:00:00', '2018-11-24', 1, 396.5, 'Wartian Herkku'),
(504, 'RICSU', 3, '2018-11-24 00:00:00', '2018-12-22 00:00:00', '2018-12-03', 3, 653.95, 'Richter Supermarkt'),
(505, 'NORTS', 2, '2018-11-24 00:00:00', '2018-12-22 00:00:00', '2018-11-28', 3, 6.95, 'North/South'),
(506, 'FRANS', 3, '2018-11-25 00:00:00', '2018-12-23 00:00:00', '2018-11-27', 1, 38.5, 'Franchi S.p.A.'),
(507, 'MAGAA', 6, '2018-11-25 00:00:00', '2018-12-23 00:00:00', '2018-11-27', 3, 11.9, 'Magazzini Alimentari Riuniti'),
(508, 'BONAP', 4, '2018-11-26 00:00:00', '2018-12-24 00:00:00', '2018-11-28', 2, 83.55, 'Bon app'),
(509, 'SPLIR', 8, '2018-11-27 00:00:00', '2018-12-25 00:00:00', '2018-12-02', 2, 366.05, 'Split Rail Beer & Ale'),
(510, 'SAVEA', 6, '2018-11-27 00:00:00', '2018-12-25 00:00:00', '2018-12-15', 1, 40.95, 'Save-a-lot Markets'),
(511, 'RICSU', 3, '2018-11-28 00:00:00', '2018-12-26 00:00:00', '2018-12-04', 3, 690.85, 'Richter Supermarkt'),
(512, 'ANATR', 3, '2018-11-28 00:00:00', '2018-12-26 00:00:00', '2018-12-12', 3, 59.95, 'Ana Trujillo Emparedados y helados'),
(513, 'MAISD', 4, '2018-12-01 00:00:00', '2018-12-29 00:00:00', '2018-12-10', 1, 778.2, 'Maison Dewey'),
(514, 'RATTC', 5, '2018-12-02 00:00:00', '2018-12-30 00:00:00', '2018-12-08', 2, 93.3, 'Rattlesnake Canyon Grocery'),
(515, 'FOLKO', 3, '2018-12-02 00:00:00', '2018-12-30 00:00:00', '2018-12-09', 1, 1643.7, 'Folk och fä HB'),
(516, 'FOLIG', 3, '2018-12-03 00:00:00', '2018-12-31 00:00:00', '2018-12-08', 3, 186.75, 'Folies gourmandes'),
(517, 'ERNSH', 6, '2018-12-03 00:00:00', '2018-12-31 00:00:00', '2018-12-08', 3, 727.25, 'Ernst Handel'),
(518, 'QUICK', 3, '2018-12-04 00:00:00', '2016-01-01 00:00:00', '2018-12-09', 3, 213.7, 'QUICK-Stop'),
(519, 'OTTIK', 4, '2018-12-05 00:00:00', '2016-01-02 00:00:00', '2018-12-09', 1, 787.75, 'Ottilies Käseladen'),
(520, 'SUPRD', 4, '2018-12-05 00:00:00', '2016-01-02 00:00:00', '2018-12-15', 3, 7.95, 'Suprêmes délices'),
(521, 'AROUT', 3, '2018-12-08 00:00:00', '2016-01-05 00:00:00', '2018-12-15', 2, 731.6, 'Around the Horn'),
(522, 'VAFFE', 3, '2018-12-08 00:00:00', '2016-01-05 00:00:00', '2018-12-12', 1, 325.3, 'Vaffeljernet'),
(523, 'HANAR', 8, '2018-12-09 00:00:00', '2016-01-06 00:00:00', '2018-12-17', 3, 26.6, 'Hanari Carnes'),
(524, 'ERNSH', 9, '2018-12-10 00:00:00', '2016-01-07 00:00:00', '2016-01-02', 2, 55.95, 'Ernst Handel'),
(525, 'LEHMS', 3, '2018-12-10 00:00:00', '2016-01-07 00:00:00', '2018-12-19', 2, 456.4, 'Lehmanns Marktstand'),
(526, 'ERNSH', 1, '2018-12-11 00:00:00', '2016-01-08 00:00:00', '2018-12-16', 3, 482.15, 'Ernst Handel'),
(527, 'FOLKO', 4, '2018-12-11 00:00:00', '2018-12-25 00:00:00', '2018-12-12', 1, 241, 'Folk och fä HB'),
(528, 'THECR', 7, '2018-12-12 00:00:00', '2016-01-09 00:00:00', '2018-12-26', 1, 101.25, 'The Cracker Box'),
(529, 'ERNSH', 1, '2018-12-15 00:00:00', '2016-01-12 00:00:00', '2018-12-18', 3, 1757.65, 'Ernst Handel'),
(530, 'GOURL', 7, '2018-12-15 00:00:00', '2018-12-29 00:00:00', '2016-01-21', 2, 15.05, 'Gourmet Lanchonetes'),
(531, 'BERGS', 3, '2018-12-16 00:00:00', '2016-01-13 00:00:00', '2018-12-24', 1, 33.95, 'Berglunds snabbköp'),
(532, 'MORGK', 3, '2018-12-16 00:00:00', '2016-01-13 00:00:00', '2016-01-14', 2, 290.65, 'Morgenstern Gesundkost'),
(533, 'LILAS', 2, '2018-12-16 00:00:00', '2018-12-30 00:00:00', '2018-12-25', 1, 210.65, 'LILA-Supermercado'),
(534, 'WARTH', 2, '2018-12-17 00:00:00', '2016-01-14 00:00:00', '2018-12-19', 3, 365.8, 'Wartian Herkku'),
(535, 'CACTU', 9, '2018-12-17 00:00:00', '2016-01-14 00:00:00', '2018-12-22', 3, 5.5, 'Cactus Comidas para llevar'),
(536, 'HANAR', 4, '2018-12-18 00:00:00', '2016-01-15 00:00:00', '2018-12-19', 2, 624.9, 'Hanari Carnes'),
(537, 'MAGAA', 4, '2018-12-18 00:00:00', '2016-01-15 00:00:00', '2018-12-22', 3, 350.45, 'Magazzini Alimentari Riuniti'),
(538, 'GROSR', 1, '2018-12-18 00:00:00', '2016-01-15 00:00:00', '2018-12-24', 3, 7.55, 'GROSELLA-Restaurante'),
(539, 'QUEEN', 8, '2018-12-19 00:00:00', '2016-01-16 00:00:00', '2018-12-23', 1, 554.35, 'Queen Cozinha'),
(540, 'LAMAI', 2, '2018-12-19 00:00:00', '2016-01-02 00:00:00', '2018-12-26', 1, 1249.65, 'La maison dAsie'),
(541, 'QUICK', 1, '2018-12-22 00:00:00', '2016-01-19 00:00:00', '2016-01-19', 2, 213.5, 'QUICK-Stop'),
(542, 'FOLIG', 1, '2018-12-22 00:00:00', '2016-01-19 00:00:00', '2018-12-31', 2, 503, 'Folies gourmandes'),
(543, 'GOURL', 6, '2018-12-22 00:00:00', '2016-01-19 00:00:00', '2018-12-26', 1, 141.15, 'Gourmet Lanchonetes'),
(544, 'FRANK', 6, '2018-12-23 00:00:00', '2016-01-20 00:00:00', '2016-01-01', 2, 84.25, 'Frankenversand'),
(545, 'WOLZA', 1, '2018-12-23 00:00:00', '2016-01-20 00:00:00', '2018-12-31', 3, 118.95, 'Wolski Zajazd'),
(546, 'AROUT', 3, '2018-12-24 00:00:00', '2016-01-21 00:00:00', '2016-01-08', 3, 22.6, 'Around the Horn'),
(547, 'QUEDE', 6, '2018-12-24 00:00:00', '2016-01-21 00:00:00', '2016-01-02', 1, 107.45, 'Que Delícia'),
(548, 'ERNSH', 8, '2018-12-24 00:00:00', '2016-01-21 00:00:00', '2016-01-20', 2, 633.3, 'Ernst Handel'),
(549, 'HILAA', 3, '2018-12-25 00:00:00', '2016-01-22 00:00:00', '2016-01-14', 1, 132.6, 'HILARIÓN-Abastos'),
(550, 'DRACD', 7, '2018-12-25 00:00:00', '2016-01-22 00:00:00', '2016-01-05', 2, 166.75, 'Drachenblut Delikatessen'),
(551, 'ISLAT', 2, '2018-12-26 00:00:00', '2016-01-23 00:00:00', '2016-01-05', 1, 11.65, 'Island Trading'),
(552, 'KOENE', 9, '2018-12-26 00:00:00', '2016-02-06 00:00:00', '2016-01-05', 3, 153.8, 'Königlich Essen'),
(553, 'SEVES', 1, '2018-12-26 00:00:00', '2016-01-23 00:00:00', '2016-01-05', 3, 687.2, 'Seven Seas Imports'),
(554, 'BOLID', 4, '2018-12-29 00:00:00', '2016-01-26 00:00:00', '2018-12-31', 2, 485.45, 'Bólido Comidas preparadas'),
(555, 'SIMOB', 4, '2018-12-29 00:00:00', '2016-01-26 00:00:00', '2016-01-02', 2, 1286.3, 'Simons bistro'),
(556, 'WELLI', 4, '2018-12-30 00:00:00', '2016-01-27 00:00:00', '2016-01-06', 1, 276.15, 'Wellington Importadora'),
(557, 'SEVES', 6, '2018-12-30 00:00:00', '2016-01-27 00:00:00', '2016-01-07', 2, 136.65, 'Seven Seas Imports'),
(558, 'THEBI', 2, '2018-12-30 00:00:00', '2016-01-27 00:00:00', '2016-01-09', 3, 1186.7, 'The Big Cheese'),
(559, 'VICTE', 3, '2018-12-31 00:00:00', '2016-01-28 00:00:00', '2016-01-05', 2, 110.55, 'Victuailles en stock'),
(560, 'FRANS', 4, '2018-12-31 00:00:00', '2016-01-28 00:00:00', '2016-01-30', 1, 6.8, 'Franchi S.p.A.'),
(561, 'OLDWO', 2, '2016-01-01 00:00:00', '2016-01-29 00:00:00', '2016-01-09', 3, 227.65, 'Old World Delicatessen'),
(562, 'WELLI', 7, '2016-01-01 00:00:00', '2016-01-29 00:00:00', '2016-01-07', 1, 24.35, 'Wellington Importadora'),
(563, 'LAUGB', 2, '2016-01-01 00:00:00', '2016-01-29 00:00:00', '2016-01-07', 3, 21.65, 'Laughing Bacchus Wine Cellars'),
(564, 'LINOD', 8, '2016-01-02 00:00:00', '2016-01-30 00:00:00', '2016-01-08', 1, 156.1, 'LINO-Delicateses'),
(565, 'REGGC', 5, '2016-01-02 00:00:00', '2016-01-30 00:00:00', '2016-01-12', 1, 298.9, 'Reggiani Caseifici'),
(566, 'RICAR', 1, '2016-01-05 00:00:00', '2016-02-02 00:00:00', '2016-01-09', 1, 236.9, 'Ricardo Adocicados'),
(567, 'VICTE', 3, '2016-01-05 00:00:00', '2016-02-02 00:00:00', '2016-01-14', 3, 654.7, 'Victuailles en stock'),
(568, 'SAVEA', 2, '2016-01-05 00:00:00', '2016-02-02 00:00:00', '2016-01-14', 3, 73.1, 'Save-a-lot Markets'),
(569, 'GREAL', 4, '2016-01-06 00:00:00', '2016-02-03 00:00:00', '2016-02-04', 2, 3598.9, 'Great Lakes Food Market'),
(570, 'KOENE', 3, '2016-01-06 00:00:00', '2016-01-20 00:00:00', '2016-01-13', 2, 1530.35, 'Königlich Essen'),
(571, 'MAGAA', 7, '2016-01-07 00:00:00', '2016-02-04 00:00:00', '2016-01-12', 3, 327.4, 'Magazzini Alimentari Riuniti'),
(572, 'CACTU', 2, '2016-01-07 00:00:00', '2016-02-04 00:00:00', '2016-01-16', 3, 98.8, 'Cactus Comidas para llevar'),
(573, 'RATTC', 3, '2016-01-07 00:00:00', '2016-02-04 00:00:00', '2016-01-13', 2, 187.6, 'Rattlesnake Canyon Grocery'),
(574, 'SPLIR', 1, '2016-01-08 00:00:00', '2016-02-05 00:00:00', '2016-01-15', 1, 183.4, 'Split Rail Beer & Ale'),
(575, 'TRAIH', 6, '2016-01-08 00:00:00', '2016-02-05 00:00:00', '2016-01-16', 3, 35, 'Trails Head Gourmet Provisioners'),
(576, 'LILAS', 5, '2016-01-09 00:00:00', '2016-02-06 00:00:00', '2016-01-13', 2, 819.85, 'LILA-Supermercado'),
(577, 'FOLKO', 8, '2016-01-09 00:00:00', '2016-02-06 00:00:00', '2016-01-30', 1, 6.15, 'Folk och fä HB'),
(578, 'DRACD', 1, '2016-01-09 00:00:00', '2016-02-06 00:00:00', '2016-01-14', 1, 396.25, 'Drachenblut Delikatessen'),
(579, 'BLONP', 6, '2016-01-12 00:00:00', '2016-02-09 00:00:00', '2016-02-06', 1, 35.45, 'Blondel père et fils'),
(580, 'BONAP', 1, '2016-01-12 00:00:00', '2016-01-26 00:00:00', '2016-02-06', 2, 317.7, 'Bon app'),
(581, 'RANCH', 9, '2016-01-13 00:00:00', '2016-01-27 00:00:00', '2016-02-04', 1, 454.25, 'Rancho grande'),
(582, 'ISLAT', 9, '2016-01-13 00:00:00', '2016-02-10 00:00:00', '2016-01-23', 1, 773.6, 'Island Trading'),
(583, 'TRADH', 4, '2016-01-13 00:00:00', '2016-02-24 00:00:00', '2016-01-21', 2, 409.15, 'Tradição Hipermercados'),
(584, 'SANTG', 3, '2016-01-14 00:00:00', '2016-02-11 00:00:00', '2016-01-23', 2, 360.95, 'Santé Gourmet'),
(585, 'LAMAI', 2, '2016-01-14 00:00:00', '2016-02-11 00:00:00', '2016-01-19', 2, 216.3, 'La maison dAsie'),
(586, 'OTTIK', 6, '2016-01-15 00:00:00', '2016-02-12 00:00:00', '2016-01-23', 2, 357.45, 'Ottilies Käseladen'),
(587, 'TRADH', 1, '2016-01-15 00:00:00', '2016-02-12 00:00:00', '2016-01-19', 3, 148.9, 'Tradição Hipermercados'),
(588, 'ALFKI', 1, '2016-01-15 00:00:00', '2016-02-12 00:00:00', '2016-01-21', 3, 347.65, 'Alfreds Futterkiste'),
(589, 'ERNSH', 7, '2016-01-16 00:00:00', '2016-02-13 00:00:00', '2016-01-21', 1, 2059.4, 'Ernst Handel'),
(590, 'BERGS', 9, '2016-01-16 00:00:00', '2016-02-13 00:00:00', '2016-01-23', 3, 66.6, 'Berglunds snabbköp'),
(591, 'LINOD', 3, '2016-01-19 00:00:00', '2016-02-16 00:00:00', '2016-01-23', 3, 296.4, 'LINO-Delicateses'),
(592, 'TRADH', 3, '2016-01-19 00:00:00', '2016-02-16 00:00:00', '2016-01-22', 3, 177.15, 'Tradição Hipermercados'),
(593, 'LINOD', 4, '2016-01-19 00:00:00', '2016-03-02 00:00:00', '2016-02-16', 2, 13.55, 'LINO-Delicateses'),
(594, 'SUPRD', 5, '2016-01-20 00:00:00', '2016-02-17 00:00:00', '2016-01-29', 2, 2121.5, 'Suprêmes délices'),
(595, 'TORTU', 1, '2016-01-20 00:00:00', '2016-02-17 00:00:00', '2016-01-29', 3, 272.1, 'Tortuga Restaurante'),
(596, 'VICTE', 4, '2016-01-21 00:00:00', '2016-02-18 00:00:00', '2016-01-26', 2, 46.3, 'Victuailles en stock'),
(597, 'PICCO', 8, '2016-01-21 00:00:00', '2016-02-18 00:00:00', '2016-01-26', 2, 126.1, 'Piccolo und mehr'),
(598, 'QUICK', 8, '2016-01-21 00:00:00', '2016-02-04 00:00:00', '2016-01-30', 1, 1064.9, 'QUICK-Stop'),
(599, 'SUPRD', 2, '2016-01-22 00:00:00', '2016-03-05 00:00:00', '2016-01-23', 3, 282.3, 'Suprêmes délices'),
(600, 'SAVEA', 4, '2016-01-22 00:00:00', '2016-02-05 00:00:00', '2016-02-10', 3, 2437.85, 'Save-a-lot Markets'),
(601, 'CONSH', 7, '2016-01-23 00:00:00', '2016-02-20 00:00:00', '2016-01-29', 2, 191.2, 'Consolidated Holdings'),
(602, 'KOENE', 9, '2016-01-23 00:00:00', '2016-02-20 00:00:00', '2016-01-30', 2, 2.8, 'Königlich Essen'),
(603, 'VICTE', 1, '2016-01-23 00:00:00', '2016-03-06 00:00:00', '2016-01-30', 1, 245.95, 'Victuailles en stock'),
(604, 'RICAR', 5, '2016-01-26 00:00:00', '2016-02-23 00:00:00', '2016-02-02', 1, 802.75, 'Ricardo Adocicados'),
(605, 'RATTC', 8, '2016-01-26 00:00:00', '2016-02-09 00:00:00', '2016-01-30', 1, 870.25, 'Rattlesnake Canyon Grocery'),
(606, 'BLAUS', 9, '2016-01-27 00:00:00', '2016-02-24 00:00:00', '2016-02-03', 2, 269.15, 'Blauer See Delikatessen'),
(607, 'ERNSH', 3, '2016-01-27 00:00:00', '2016-02-24 00:00:00', '2016-02-05', 2, 501.1, 'Ernst Handel'),
(608, 'OLDWO', 3, '2016-01-27 00:00:00', '2016-02-24 00:00:00', '2016-02-04', 1, 854.85, 'Old World Delicatessen'),
(609, 'ANTON', 3, '2016-01-28 00:00:00', '2016-02-25 00:00:00', '2016-02-10', 2, 292.15, 'Antonio Moreno Taquería'),
(610, 'BERGS', 8, '2016-01-28 00:00:00', '2016-02-25 00:00:00', '2016-02-06', 2, 944.25, 'Berglunds snabbköp'),
(611, 'LACOR', 2, '2016-01-29 00:00:00', '2016-02-26 00:00:00', '2016-02-03', 1, 262.55, 'La corne dabondance'),
(612, 'FRANK', 1, '2016-01-29 00:00:00', '2016-02-26 00:00:00', '2016-02-02', 2, 380.5, 'Frankenversand'),
(613, 'FRANR', 3, '2016-01-29 00:00:00', '2016-02-26 00:00:00', '2016-02-04', 3, 96.3, 'France restauration'),
(614, 'WHITC', 4, '2016-01-30 00:00:00', '2016-02-27 00:00:00', '2016-02-17', 2, 74.65, 'White Clover Markets'),
(615, 'LEHMS', 8, '2016-01-30 00:00:00', '2016-03-13 00:00:00', '2016-02-02', 2, 266.15, 'Lehmanns Marktstand'),
(616, 'HILAA', 4, '2016-02-02 00:00:00', '2016-03-02 00:00:00', '2016-02-17', 2, 151.3, 'HILARIÓN-Abastos'),
(617, 'AROUT', 4, '2016-02-02 00:00:00', '2016-03-02 00:00:00', '2016-02-09', 2, 15.2, 'Around the Horn'),
(618, 'QUICK', 2, '2016-02-02 00:00:00', '2016-02-16 00:00:00', '2016-02-12', 1, 1740.7, 'QUICK-Stop'),
(619, 'BERGS', 5, '2016-02-03 00:00:00', '2016-03-03 00:00:00', '2016-02-12', 1, 545.55, 'Berglunds snabbköp'),
(620, 'LONEP', 6, '2016-02-03 00:00:00', '2016-03-17 00:00:00', '2016-02-11', 1, 9.65, 'Lonesome Pine Restaurant'),
(621, 'QUEEN', 7, '2016-02-04 00:00:00', '2016-03-04 00:00:00', '2016-02-23', 2, 956.35, 'Queen Cozinha'),
(622, 'SEVES', 5, '2016-02-04 00:00:00', '2016-03-04 00:00:00', '2016-02-09', 1, 716.4, 'Seven Seas Imports'),
(623, 'WOLZA', 5, '2016-02-04 00:00:00', '2016-03-04 00:00:00', '2016-02-13', 3, 60.2, 'Wolski Zajazd'),
(624, 'BONAP', 9, '2016-02-05 00:00:00', '2016-03-05 00:00:00', '2016-02-10', 2, 561.35, 'Bon app'),
(625, 'GODOS', 5, '2016-02-05 00:00:00', '2016-03-05 00:00:00', '2016-02-09', 2, 876.6, 'Godos Cocina Típica'),
(626, 'WILMK', 4, '2016-02-06 00:00:00', '2016-03-06 00:00:00', '2016-02-09', 1, 4.1, 'Wilman Kala'),
(627, 'GODOS', 5, '2016-02-06 00:00:00', '2016-03-06 00:00:00', '2016-02-11', 2, 97.9, 'Godos Cocina Típica'),
(628, 'BERGS', 4, '2016-02-06 00:00:00', '2016-03-06 00:00:00', '2016-03-03', 2, 161.85, 'Berglunds snabbköp'),
(629, 'BONAP', 7, '2016-02-09 00:00:00', '2016-03-09 00:00:00', '2016-02-12', 3, 302.1, 'Bon app'),
(630, 'RICAR', 1, '2016-02-09 00:00:00', '2016-03-09 00:00:00', '2016-02-19', 1, 190.3, 'Ricardo Adocicados'),
(631, 'QUICK', 4, '2016-02-10 00:00:00', '2016-03-10 00:00:00', '2016-02-12', 1, 233.45, 'QUICK-Stop'),
(632, 'WILMK', 3, '2016-02-10 00:00:00', '2016-03-10 00:00:00', '2016-02-12', 3, 42.5, 'Wilman Kala'),
(633, 'FOLKO', 7, '2016-02-10 00:00:00', '2016-03-24 00:00:00', '2016-02-18', 1, 440.05, 'Folk och fä HB'),
(634, 'CACTU', 4, '2016-02-11 00:00:00', '2016-03-11 00:00:00', '2016-02-18', 1, 14.2, 'Cactus Comidas para llevar'),
(635, 'SAVEA', 4, '2016-02-11 00:00:00', '2016-03-11 00:00:00', '2016-02-20', 3, 115.5, 'Save-a-lot Markets'),
(637, 'LETSS', 4, '2016-02-12 00:00:00', '2016-03-12 00:00:00', '2016-02-13', 2, 454.85, 'Lets Stop N Shop'),
(638, 'SUPRD', 6, '2016-02-12 00:00:00', '2016-03-12 00:00:00', '2016-02-18', 3, 28.2, 'Suprêmes délices'),
(639, 'HANAR', 1, '2016-02-13 00:00:00', '2016-03-13 00:00:00', '2016-03-02', 1, 24.95, 'Hanari Carnes'),
(640, 'GALED', 8, '2016-02-13 00:00:00', '2016-03-13 00:00:00', '2016-02-16', 3, 6.25, 'Galería del gastronómo'),
(641, 'GODOS', 1, '2016-02-16 00:00:00', '2016-03-16 00:00:00', '2016-02-23', 2, 259.35, 'Godos Cocina Típica'),
(642, 'RATTC', 9, '2016-02-16 00:00:00', '2016-03-16 00:00:00', '2016-02-23', 3, 1403.05, 'Rattlesnake Canyon Grocery'),
(643, 'DUMON', 7, '2016-02-16 00:00:00', '2016-03-16 00:00:00', '2016-02-18', 1, 163.8, 'Du monde entier'),
(644, 'LEHMS', 7, '2016-02-17 00:00:00', '2016-03-17 00:00:00', '2016-02-19', 2, 101.85, 'Lehmanns Marktstand'),
(645, 'MAISD', 4, '2016-02-17 00:00:00', '2016-03-17 00:00:00', '2016-02-19', 2, 601.35, 'Maison Dewey'),
(646, 'KOENE', 9, '2016-02-18 00:00:00', '2016-03-18 00:00:00', '2016-02-20', 2, 388.9, 'Königlich Essen'),
(647, 'SAVEA', 1, '2016-02-18 00:00:00', '2016-03-18 00:00:00', '2016-02-20', 1, 580.65, 'Save-a-lot Markets'),
(648, 'ERNSH', 3, '2016-02-18 00:00:00', '2016-03-18 00:00:00', '2016-02-23', 1, 813.75, 'Ernst Handel'),
(649, 'MAISD', 7, '2016-02-19 00:00:00', '2016-03-19 00:00:00', '2016-02-27', 3, 162.25, 'Maison Dewey'),
(650, 'HUNGO', 3, '2016-02-19 00:00:00', '2016-03-19 00:00:00', '2016-02-25', 2, 3017.7, 'Hungry Owl All-Night Grocers'),
(651, 'OCEAN', 4, '2016-02-20 00:00:00', '2016-03-20 00:00:00', '2016-03-06', 2, 6.35, 'Océano Atlántico Ltda.'),
(652, 'LILAS', 5, '2016-02-20 00:00:00', '2016-03-20 00:00:00', '2016-02-26', 3, 6.05, 'LILA-Supermercado'),
(653, 'WELLI', 1, '2016-02-20 00:00:00', '2016-03-20 00:00:00', '2016-03-04', 2, 8.3, 'Wellington Importadora'),
(654, 'HILAA', 4, '2016-02-23 00:00:00', '2016-03-23 00:00:00', '2016-02-26', 1, 310.45, 'HILARIÓN-Abastos'),
(655, 'FOLKO', 1, '2016-02-23 00:00:00', '2016-03-23 00:00:00', '2016-03-03', 1, 220.75, 'Folk och fä HB'),
(656, 'HANAR', 3, '2016-02-24 00:00:00', '2016-03-24 00:00:00', '2016-03-04', 3, 183.55, 'Hanari Carnes'),
(657, 'WHITC', 3, '2016-02-24 00:00:00', '2016-03-24 00:00:00', '2016-02-27', 3, 814.75, 'White Clover Markets'),
(658, 'WELLI', 9, '2016-02-24 00:00:00', '2016-03-24 00:00:00', '2016-03-06', 2, 68.6, 'Wellington Importadora'),
(659, 'WOLZA', 4, '2016-02-25 00:00:00', '2016-03-11 00:00:00', '2016-03-03', 3, 131.45, 'Wolski Zajazd'),
(660, 'SPECD', 6, '2016-02-25 00:00:00', '2016-03-25 00:00:00', '2016-02-27', 3, 45.95, 'Spécialités du monde'),
(661, 'REGGC', 4, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-06', 2, 164.8, 'Reggiani Caseifici'),
(662, 'SANTG', 1, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-10', 2, 265.25, 'Santé Gourmet'),
(663, 'WILMK', 1, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-04', 3, 190.55, 'Wilman Kala'),
(664, 'GODOS', 3, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-05', 1, 190.95, 'Godos Cocina Típica'),
(665, 'HUNGO', 2, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-18', 2, 2904.55, 'Hungry Owl All-Night Grocers'),
(666, 'QUEEN', 4, '2016-02-26 00:00:00', '2016-03-26 00:00:00', '2016-03-04', 1, 165.25, 'Queen Cozinha'),
(667, 'QUEEN', 6, '2016-02-27 00:00:00', '2016-03-27 00:00:00', '2016-03-02', 1, 105.95, 'Queen Cozinha'),
(668, 'TORTU', 2, '2016-02-27 00:00:00', '2016-03-27 00:00:00', '2016-03-02', 2, 17.55, 'Tortuga Restaurante'),
(669, 'RANCH', 1, '2016-02-27 00:00:00', '2016-03-27 00:00:00', '2016-03-09', 2, 318.85, 'Rancho grande'),
(670, 'ROMEY', 4, '2016-03-02 00:00:00', '2016-03-30 00:00:00', '2016-03-11', 2, 41.45, 'Romero y tomillo'),
(671, 'BOTTM', 3, '2016-03-02 00:00:00', '2016-03-30 00:00:00', '2016-03-11', 3, 244.15, 'Bottom-Dollar Markets'),
(672, 'LINOD', 2, '2016-03-02 00:00:00', '2016-03-30 00:00:00', '2016-03-04', 2, 99, 'LINO-Delicateses'),
(673, 'AROUT', 4, '2016-03-03 00:00:00', '2016-03-31 00:00:00', '2016-03-09', 2, 148.05, 'Around the Horn'),
(674, 'VAFFE', 1, '2016-03-03 00:00:00', '2016-04-14 00:00:00', '2016-03-09', 1, 882.4, 'Vaffeljernet'),
(675, 'HANAR', 5, '2016-03-03 00:00:00', '2016-03-31 00:00:00', '2016-03-05', 3, 313.7, 'Hanari Carnes'),
(676, 'LAMAI', 7, '2016-03-03 00:00:00', '2016-04-14 00:00:00', '2016-03-13', 3, 341.3, 'La maison dAsie'),
(677, 'BERGS', 3, '2016-03-04 00:00:00', '2016-04-01 00:00:00', '2016-04-08', 2, 757.6, 'Berglunds snabbköp'),
(678, 'HANAR', 3, '2016-03-04 00:00:00', '2016-04-01 00:00:00', '2016-03-13', 1, 11.35, 'Hanari Carnes'),
(679, 'ANATR', 4, '2016-03-04 00:00:00', '2016-04-01 00:00:00', '2016-03-11', 3, 199.6, 'Ana Trujillo Emparedados y helados'),
(680, 'LACOR', 4, '2016-03-05 00:00:00', '2016-04-02 00:00:00', '2016-04-08', 1, 98.95, 'La corne dabondance'),
(681, 'GALED', 1, '2016-03-05 00:00:00', '2016-04-02 00:00:00', '2016-03-18', 1, 6.8, 'Galería del gastronómo'),
(682, 'FRANK', 6, '2016-03-05 00:00:00', '2016-04-02 00:00:00', '2016-03-12', 1, 169.65, 'Frankenversand'),
(683, 'SUPRD', 4, '2016-03-06 00:00:00', '2016-04-17 00:00:00', '2016-03-18', 3, 77.75, 'Suprêmes délices'),
(684, 'RICSU', 4, '2016-03-06 00:00:00', '2016-03-20 00:00:00', '2016-03-19', 2, 68, 'Richter Supermarkt'),
(685, 'BONAP', 8, '2016-03-06 00:00:00', '2016-04-03 00:00:00', '2016-03-24', 1, 673.2, 'Bon app'),
(686, 'ISLAT', 6, '2016-03-06 00:00:00', '2016-04-03 00:00:00', '2016-03-16', 3, 270.75, 'Island Trading'),
(687, 'LEHMS', 3, '2016-03-09 00:00:00', '2016-04-06 00:00:00', '2016-03-12', 3, 160.05, 'Lehmanns Marktstand'),
(688, 'WELLI', 4, '2016-03-09 00:00:00', '2016-04-06 00:00:00', '2016-03-18', 3, 237.95, 'Wellington Importadora'),
(689, 'GREAL', 3, '2016-03-09 00:00:00', '2016-04-06 00:00:00', '2016-03-18', 2, 168.4, 'Great Lakes Food Market'),
(690, 'CACTU', 7, '2016-03-10 00:00:00', '2016-03-24 00:00:00', '2016-03-13', 3, 157.55, 'Cactus Comidas para llevar'),
(691, 'QUICK', 3, '2016-03-10 00:00:00', '2016-04-07 00:00:00', '2016-03-16', 2, 159.45, 'QUICK-Stop'),
(692, 'MAGAA', 2, '2016-03-10 00:00:00', '2016-04-07 00:00:00', '2016-03-13', 2, 381.65, 'Magazzini Alimentari Riuniti'),
(693, 'BONAP', 8, '2016-03-11 00:00:00', '2016-04-08 00:00:00', '2016-03-23', 3, 98.85, 'Bon app'),
(694, 'SAVEA', 7, '2016-03-11 00:00:00', '2016-04-08 00:00:00', '2016-03-20', 2, 2004.05, 'Save-a-lot Markets'),
(695, 'REGGC', 9, '2016-03-11 00:00:00', '2016-04-08 00:00:00', '2016-03-18', 3, 89.75, 'Reggiani Caseifici'),
(696, 'BSBEV', 4, '2016-03-11 00:00:00', '2016-04-08 00:00:00', '2016-03-19', 2, 10.85, 'Bs Beverages'),
(697, 'BOTTM', 6, '2016-03-12 00:00:00', '2016-03-26 00:00:00', '2016-03-13', 3, 264.6, 'Bottom-Dollar Markets'),
(698, 'MORGK', 4, '2016-03-12 00:00:00', '2016-04-09 00:00:00', '2016-03-18', 1, 51.1, 'Morgenstern Gesundkost'),
(699, 'VAFFE', 1, '2016-03-12 00:00:00', '2016-04-09 00:00:00', '2016-03-19', 2, 136, 'Vaffeljernet'),
(700, 'BSBEV', 3, '2016-03-13 00:00:00', '2016-04-10 00:00:00', '2016-03-16', 2, 16.3, 'Bs Beverages'),
(701, 'GODOS', 3, '2016-03-13 00:00:00', '2016-04-10 00:00:00', '2016-03-19', 3, 116.95, 'Godos Cocina Típica'),
(702, 'BOTTM', 2, '2016-03-13 00:00:00', '2016-04-10 00:00:00', '2016-03-17', 3, 372.2, 'Bottom-Dollar Markets'),
(703, 'MAGAA', 1, '2016-03-16 00:00:00', '2016-04-13 00:00:00', '2016-03-23', 2, 12.5, 'Magazzini Alimentari Riuniti'),
(704, 'RICSU', 9, '2016-03-16 00:00:00', '2016-04-27 00:00:00', '2016-04-07', 2, 154.25, 'Richter Supermarkt'),
(705, 'ALFKI', 1, '2016-03-16 00:00:00', '2016-04-27 00:00:00', '2016-03-24', 1, 202.1, 'Alfreds Futterkiste'),
(706, 'AROUT', 9, '2016-03-16 00:00:00', '2016-03-30 00:00:00', '2016-03-25', 2, 118.6, 'Around the Horn'),
(707, 'LINOD', 5, '2016-03-17 00:00:00', '2016-04-28 00:00:00', '2016-03-20', 1, 139.55, 'LINO-Delicateses'),
(708, 'FOLKO', 8, '2016-03-17 00:00:00', '2016-04-14 00:00:00', '2016-03-20', 2, 16.3, 'Folk och fä HB'),
(709, 'BLAUS', 6, '2016-03-17 00:00:00', '2016-04-28 00:00:00', '2016-03-20', 2, 223.25, 'Blauer See Delikatessen'),
(710, 'HILAA', 8, '2016-03-18 00:00:00', '2016-04-15 00:00:00', '2016-03-27', 3, 526.8, 'HILARIÓN-Abastos'),
(711, 'OCEAN', 7, '2016-03-18 00:00:00', '2016-04-15 00:00:00', '2016-03-27', 2, 247.8, 'Océano Atlántico Ltda.'),
(712, 'GOURL', 6, '2016-03-18 00:00:00', '2016-04-29 00:00:00', '2016-03-23', 2, 24.9, 'Gourmet Lanchonetes'),
(713, 'HILAA', 3, '2016-03-19 00:00:00', '2016-04-02 00:00:00', '2016-04-08', 1, 10.4, 'HILARIÓN-Abastos'),
(714, 'QUEEN', 8, '2016-03-19 00:00:00', '2016-04-16 00:00:00', '2016-03-30', 1, 522.35, 'Queen Cozinha'),
(715, 'QUICK', 8, '2016-03-19 00:00:00', '2016-04-16 00:00:00', '2016-03-23', 2, 1378.95, 'QUICK-Stop'),
(716, 'FURIB', 9, '2016-03-19 00:00:00', '2016-04-16 00:00:00', '2016-03-26', 3, 13.5, 'Furia Bacalhau e Frutos do Mar'),
(717, 'SPECD', 3, '2016-03-20 00:00:00', '2016-04-17 00:00:00', '2016-03-24', 2, 436.9, 'Spécialités du monde'),
(718, 'OLDWO', 6, '2016-03-20 00:00:00', '2016-04-17 00:00:00', '2016-03-30', 3, 721.9, 'Old World Delicatessen'),
(719, 'CHOPS', 4, '2016-03-20 00:00:00', '2016-04-17 00:00:00', '2016-04-08', 1, 135.95, 'Chop-suey Chinese'),
(720, 'TOMSP', 2, '2016-03-23 00:00:00', '2016-04-20 00:00:00', '2016-04-02', 2, 311.1, 'Toms Spezialitäten'),
(721, 'ERNSH', 1, '2016-03-23 00:00:00', '2016-04-20 00:00:00', '2016-04-01', 3, 373, 'Ernst Handel'),
(722, 'COMMI', 1, '2016-03-23 00:00:00', '2016-04-20 00:00:00', '2016-03-30', 2, 1.05, 'Comércio Mineiro'),
(723, 'BOLID', 9, '2016-03-24 00:00:00', '2016-04-07 00:00:00', '2016-04-24', 1, 80.8, 'Bólido Comidas preparadas'),
(724, 'FRANR', 2, '2016-03-24 00:00:00', '2016-04-21 00:00:00', '2016-04-02', 2, 609.1, 'France restauration'),
(725, 'LACOR', 4, '2016-03-24 00:00:00', '2016-04-21 00:00:00', '2016-03-26', 2, 0.1, 'La corne dabondance'),
(726, 'LACOR', 6, '2016-03-24 00:00:00', '2016-04-21 00:00:00', '2016-03-27', 2, 75.85, 'La corne dabondance'),
(727, 'SPLIR', 3, '2016-03-25 00:00:00', '2016-04-08 00:00:00', '2016-04-03', 3, 64.8, 'Split Rail Beer & Ale'),
(728, 'BOTTM', 1, '2016-03-25 00:00:00', '2016-04-22 00:00:00', '2016-03-27', 3, 161.35, 'Bottom-Dollar Markets'),
(729, 'HILAA', 1, '2016-03-25 00:00:00', '2016-05-06 00:00:00', '2016-04-03', 1, 189.85, 'HILARIÓN-Abastos'),
(730, 'FOLKO', 8, '2016-03-26 00:00:00', '2016-04-23 00:00:00', '2016-04-10', 3, 1042.5, 'Folk och fä HB'),
(731, 'MAISD', 9, '2016-03-26 00:00:00', '2016-04-23 00:00:00', '2016-04-23', 2, 164.1, 'Maison Dewey'),
(732, 'ERNSH', 8, '2016-03-26 00:00:00', '2016-04-23 00:00:00', '2016-03-31', 2, 1765.35, 'Ernst Handel'),
(733, 'FOLKO', 4, '2016-03-27 00:00:00', '2016-05-08 00:00:00', '2016-04-17', 1, 6.3, 'Folk och fä HB'),
(734, 'HANAR', 1, '2016-03-27 00:00:00', '2016-04-24 00:00:00', '2016-04-02', 2, 966.85, 'Hanari Carnes'),
(735, 'BOTTM', 2, '2016-03-27 00:00:00', '2016-04-24 00:00:00', '2016-04-08', 1, 70.05, 'Bottom-Dollar Markets'),
(736, 'SAVEA', 2, '2016-03-27 00:00:00', '2016-04-24 00:00:00', '2016-04-06', 2, 3287.7, 'Save-a-lot Markets'),
(737, 'SAVEA', 1, '2016-03-30 00:00:00', '2016-04-27 00:00:00', '2016-04-03', 3, 1056.1, 'Save-a-lot Markets'),
(738, 'HUNGO', 2, '2016-03-30 00:00:00', '2016-04-27 00:00:00', '2016-04-02', 1, 457.55, 'Hungry Owl All-Night Grocers'),
(739, 'OCEAN', 8, '2016-03-30 00:00:00', '2016-04-27 00:00:00', '2016-04-21', 2, 1089.3, 'Océano Atlántico Ltda.'),
(740, 'EASTC', 8, '2016-03-31 00:00:00', '2016-04-28 00:00:00', '2016-04-06', 1, 927.4, 'Eastern Connection'),
(741, 'RATTC', 3, '2016-03-31 00:00:00', '2016-04-28 00:00:00', '2016-04-10', 2, 305.7, 'Rattlesnake Canyon Grocery'),
(742, 'QUEDE', 2, '2016-03-31 00:00:00', '2016-04-28 00:00:00', '2016-04-02', 1, 173.8, 'Que Delícia'),
(743, 'ERNSH', 2, '2016-04-01 00:00:00', '2016-05-13 00:00:00', '2016-04-07', 3, 588.05, 'Ernst Handel'),
(744, 'QUICK', 1, '2016-04-01 00:00:00', '2016-04-29 00:00:00', '2016-04-07', 1, 192.55, 'QUICK-Stop'),
(745, 'THEBI', 1, '2016-04-01 00:00:00', '2016-04-29 00:00:00', '2016-04-03', 3, 21.35, 'The Big Cheese'),
(746, 'FOLKO', 7, '2016-04-01 00:00:00', '2016-04-29 00:00:00', '2016-04-10', 3, 44.05, 'Folk och fä HB'),
(747, 'VAFFE', 2, '2016-04-02 00:00:00', '2016-04-16 00:00:00', '2016-04-09', 3, 327.65, 'Vaffeljernet'),
(748, 'PERIC', 1, '2016-04-02 00:00:00', '2016-04-30 00:00:00', '2016-04-06', 3, 230, 'Pericles Comidas clásicas'),
(749, 'QUICK', 4, '2016-04-02 00:00:00', '2016-04-30 00:00:00', '2016-04-10', 2, 5.6, 'QUICK-Stop'),
(750, 'LILAS', 8, '2016-04-03 00:00:00', '2016-05-15 00:00:00', '2016-04-13', 2, 369.55, 'LILA-Supermercado'),
(751, 'WOLZA', 8, '2016-04-03 00:00:00', '2016-04-17 00:00:00', '2016-04-17', 2, 101.55, 'Wolski Zajazd'),
(752, 'OTTIK', 6, '2016-04-03 00:00:00', '2016-05-01 00:00:00', '2016-04-10', 2, 481.75, 'Ottilies Käseladen'),
(753, 'RATTC', 2, '2016-04-06 00:00:00', '2016-05-04 00:00:00', '2016-04-14', 3, 275.6, 'Rattlesnake Canyon Grocery'),
(754, 'FOLKO', 2, '2016-04-06 00:00:00', '2016-05-04 00:00:00', '2016-04-14', 2, 986.5, 'Folk och fä HB'),
(755, 'SAVEA', 4, '2016-04-06 00:00:00', '2016-05-04 00:00:00', '2016-04-16', 1, 705.8, 'Save-a-lot Markets'),
(756, 'THECR', 3, '2016-04-06 00:00:00', '2016-05-04 00:00:00', '2016-04-08', 3, 74.55, 'The Cracker Box'),
(757, 'MAISD', 3, '2016-04-07 00:00:00', '2016-05-05 00:00:00', '2016-04-20', 1, 224.2, 'Maison Dewey'),
(758, 'WILMK', 2, '2016-04-07 00:00:00', '2016-05-05 00:00:00', '2016-04-10', 1, 3.75, 'Wilman Kala'),
(759, 'GREAL', 3, '2016-04-07 00:00:00', '2016-05-05 00:00:00', '2016-04-15', 2, 125.95, 'Great Lakes Food Market'),
(760, 'PRINI', 8, '2016-04-08 00:00:00', '2016-05-06 00:00:00', '2016-04-13', 2, 1011.2, 'Princesa Isabel Vinhos'),
(761, 'ERNSH', 7, '2016-04-08 00:00:00', '2016-05-06 00:00:00', '2022-04-04', 3, 397.3, 'Ernst Handel'),
(762, 'GODOS', 2, '2016-04-08 00:00:00', '2016-05-06 00:00:00', '2016-04-10', 1, 295.55, 'Godos Cocina Típica'),
(763, 'REGGC', 2, '2016-04-09 00:00:00', '2016-05-07 00:00:00', '2016-04-21', 2, 143.55, 'Reggiani Caseifici'),
(764, 'ALFKI', 3, '2016-04-09 00:00:00', '2016-05-07 00:00:00', '2016-04-13', 1, 6.05, 'Alfreds Futterkiste'),
(765, 'FRANK', 1, '2016-04-09 00:00:00', '2016-04-23 00:00:00', '2016-04-17', 3, 1214.75, 'Frankenversand'),
(766, 'ROMEY', 2, '2016-04-09 00:00:00', '2016-05-07 00:00:00', '2016-04-10', 1, 164.95, 'Romero y tomillo'),
(767, 'LINOD', 2, '2016-04-10 00:00:00', '2016-05-08 00:00:00', '2016-04-15', 3, 118, 'LINO-Delicateses'),
(768, 'SANTG', 2, '2016-04-10 00:00:00', '2016-04-24 00:00:00', '2016-04-20', 2, 23.1, 'Santé Gourmet'),
(769, 'AROUT', 9, '2016-04-10 00:00:00', '2016-05-08 00:00:00', '2016-04-13', 2, 169, 'Around the Horn'),
(770, 'ERNSH', 9, '2016-04-13 00:00:00', '2016-05-11 00:00:00', '2016-04-20', 2, 3771.3, 'Ernst Handel'),
(771, 'LONEP', 4, '2016-04-13 00:00:00', '2016-05-11 00:00:00', '2016-04-16', 2, 58.25, 'Lonesome Pine Restaurant'),
(772, 'RANCH', 6, '2016-04-13 00:00:00', '2016-05-11 00:00:00', '2022-04-04', 3, 15.85, 'Rancho grande'),
(773, 'OTTIK', 2, '2016-04-14 00:00:00', '2016-05-12 00:00:00', '2016-04-16', 2, 216.5, 'Ottilies Käseladen'),
(774, 'QUICK', 3, '2016-04-14 00:00:00', '2016-05-12 00:00:00', '2016-04-21', 1, 1485.9, 'QUICK-Stop'),
(775, 'HANAR', 9, '2016-04-14 00:00:00', '2016-05-12 00:00:00', '2016-05-04', 2, 31.35, 'Hanari Carnes'),
(776, 'BSBEV', 1, '2016-04-14 00:00:00', '2016-04-28 00:00:00', '2016-04-24', 2, 619.15, 'Bs Beverages'),
(777, 'EASTC', 4, '2016-04-15 00:00:00', '2016-05-13 00:00:00', '2016-04-20', 1, 371.8, 'Eastern Connection'),
(778, 'WARTH', 6, '2016-04-15 00:00:00', '2016-05-13 00:00:00', '2016-04-24', 3, 145.85, 'Wartian Herkku'),
(779, 'FRANS', 4, '2016-04-15 00:00:00', '2016-05-13 00:00:00', '2016-04-28', 1, 235.45, 'Franchi S.p.A.'),
(780, 'BOTTM', 1, '2016-04-16 00:00:00', '2016-05-14 00:00:00', '2016-04-20', 1, 262.6, 'Bottom-Dollar Markets'),
(781, 'KOENE', 2, '2016-04-16 00:00:00', '2016-05-14 00:00:00', '2016-04-22', 1, 147.95, 'Königlich Essen'),
(782, 'CHOPS', 4, '2016-04-16 00:00:00', '2016-05-14 00:00:00', '2016-04-27', 1, 239.2, 'Chop-suey Chinese'),
(783, 'SAVEA', 7, '2016-04-17 00:00:00', '2016-05-15 00:00:00', '2016-04-27', 2, 4153.75, 'Save-a-lot Markets'),
(784, 'SAVEA', 6, '2016-04-17 00:00:00', '2016-05-15 00:00:00', '2016-04-24', 2, 1136.1, 'Save-a-lot Markets'),
(785, 'WHITC', 2, '2016-04-17 00:00:00', '2016-05-15 00:00:00', '2016-04-23', 3, 3030.95, 'White Clover Markets'),
(786, 'RICSU', 7, '2016-04-17 00:00:00', '2016-05-15 00:00:00', '2016-04-23', 3, 423.7, 'Richter Supermarkt'),
(787, 'OLDWO', 8, '2016-04-20 00:00:00', '2016-06-01 00:00:00', '2016-04-27', 1, 201.6, 'Old World Delicatessen'),
(788, 'SUPRD', 2, '2016-04-20 00:00:00', '2016-05-18 00:00:00', '2016-04-24', 2, 0.85, 'Suprêmes délices'),
(789, 'DRACD', 8, '2016-04-20 00:00:00', '2016-05-18 00:00:00', '2016-04-22', 3, 747.35, 'Drachenblut Delikatessen'),
(790, 'GODOS', 7, '2016-04-21 00:00:00', '2016-05-19 00:00:00', '2016-04-27', 1, 16, 'Godos Cocina Típica'),
(791, 'SUPRD', 1, '2016-04-21 00:00:00', '2016-05-19 00:00:00', '2016-04-30', 2, 147.95, 'Suprêmes délices'),
(792, 'LINOD', 1, '2016-04-21 00:00:00', '2016-05-19 00:00:00', '2022-04-04', 2, 325, 'LINO-Delicateses'),
(793, 'GREAL', 4, '2016-04-22 00:00:00', '2016-05-20 00:00:00', '2022-04-04', 3, 94.2, 'Great Lakes Food Market'),
(794, 'CHOPS', 3, '2016-04-22 00:00:00', '2016-05-20 00:00:00', '2016-04-28', 2, 241.1, 'Chop-suey Chinese'),
(795, 'COMMI', 2, '2016-04-22 00:00:00', '2016-05-06 00:00:00', '2016-05-01', 1, 149.95, 'Comércio Mineiro'),
(796, 'SPECD', 5, '2016-04-22 00:00:00', '2016-05-20 00:00:00', '2016-04-29', 2, 44, 'Spécialités du monde'),
(797, 'WOLZA', 4, '2016-04-23 00:00:00', '2016-05-21 00:00:00', '2016-05-01', 1, 43.6, 'Wolski Zajazd'),
(798, 'BOTTM', 6, '2016-04-23 00:00:00', '2016-05-21 00:00:00', '2022-04-04', 2, 352.9, 'Bottom-Dollar Markets'),
(799, 'WANDK', 8, '2016-04-23 00:00:00', '2016-05-21 00:00:00', '2016-04-24', 2, 358.2, 'Die Wandernde Kuh'),
(800, 'EASTC', 7, '2016-04-24 00:00:00', '2016-05-22 00:00:00', '2016-05-01', 3, 233.1, 'Eastern Connection'),
(801, 'BOTTM', 7, '2016-04-24 00:00:00', '2016-05-22 00:00:00', '2016-04-30', 3, 120.6, 'Bottom-Dollar Markets'),
(802, 'GOURL', 3, '2016-04-24 00:00:00', '2016-05-22 00:00:00', '2016-05-04', 1, 41.7, 'Gourmet Lanchonetes'),
(803, 'FOLKO', 8, '2016-04-27 00:00:00', '2016-05-25 00:00:00', '2016-05-05', 2, 297.05, 'Folk och fä HB'),
(804, 'LAMAI', 7, '2016-04-27 00:00:00', '2016-05-25 00:00:00', '2022-04-04', 3, 13.95, 'La maison dAsie'),
(805, 'HANAR', 3, '2016-04-27 00:00:00', '2016-05-25 00:00:00', '2016-05-01', 1, 336.3, 'Hanari Carnes'),
(806, 'PICCO', 2, '2016-04-27 00:00:00', '2016-05-25 00:00:00', '2016-04-29', 2, 265.25, 'Piccolo und mehr'),
(807, 'CACTU', 8, '2016-04-28 00:00:00', '2016-05-26 00:00:00', '2022-04-04', 1, 1.65, 'Cactus Comidas para llevar'),
(808, 'HILAA', 7, '2016-04-28 00:00:00', '2016-05-26 00:00:00', '2016-05-05', 2, 604.6, 'HILARIÓN-Abastos'),
(809, 'EASTC', 8, '2016-04-28 00:00:00', '2016-05-12 00:00:00', '2016-05-01', 2, 1394.8, 'Eastern Connection'),
(810, 'NORTS', 3, '2016-04-29 00:00:00', '2016-05-27 00:00:00', '2016-05-01', 3, 20.65, 'North/South'),
(811, 'BLAUS', 9, '2016-04-29 00:00:00', '2016-05-27 00:00:00', '2022-04-04', 3, 155.7, 'Blauer See Delikatessen'),
(812, 'RICAR', 2, '2016-04-29 00:00:00', '2016-06-10 00:00:00', '2022-04-04', 2, 429, 'Ricardo Adocicados'),
(813, 'FRANS', 2, '2016-04-30 00:00:00', '2016-05-28 00:00:00', '2016-05-04', 2, 54.9, 'Franchi S.p.A.'),
(814, 'GREAL', 4, '2016-04-30 00:00:00', '2016-06-11 00:00:00', '2022-04-04', 3, 70.05, 'Great Lakes Food Market'),
(815, 'REGGC', 4, '2016-04-30 00:00:00', '2016-05-28 00:00:00', '2022-04-04', 2, 149.65, 'Reggiani Caseifici'),
(816, 'HUNGO', 3, '2016-04-30 00:00:00', '2016-05-28 00:00:00', '2016-05-06', 2, 408.65, 'Hungry Owl All-Night Grocers'),
(817, 'SAVEA', 1, '2016-05-01 00:00:00', '2016-05-29 00:00:00', '2016-05-04', 1, 150.45, 'Save-a-lot Markets'),
(818, 'LILAS', 8, '2016-05-01 00:00:00', '2016-05-29 00:00:00', '2022-04-04', 1, 64.55, 'LILA-Supermercado'),
(819, 'WHITC', 7, '2016-05-01 00:00:00', '2016-05-29 00:00:00', '2016-05-04', 2, 223.6, 'White Clover Markets'),
(820, 'DRACD', 1, '2016-05-04 00:00:00', '2016-05-18 00:00:00', '2016-05-06', 2, 39.9, 'Drachenblut Delikatessen'),
(821, 'QUEEN', 8, '2016-05-04 00:00:00', '2016-06-01 00:00:00', '2022-04-04', 2, 408.75, 'Queen Cozinha'),
(822, 'TORTU', 1, '2016-05-04 00:00:00', '2016-06-01 00:00:00', '2016-05-06', 2, 78.35, 'Tortuga Restaurante'),
(823, 'LEHMS', 2, '2016-05-05 00:00:00', '2016-06-02 00:00:00', '2022-04-04', 1, 680, 'Lehmanns Marktstand'),
(824, 'LILAS', 1, '2016-05-05 00:00:00', '2016-06-02 00:00:00', '2022-04-04', 1, 4.65, 'LILA-Supermercado'),
(825, 'ERNSH', 4, '2016-05-05 00:00:00', '2016-06-02 00:00:00', '2022-04-04', 2, 1293.2, 'Ernst Handel'),
(826, 'PERIC', 2, '2016-05-05 00:00:00', '2016-06-02 00:00:00', '2022-04-04', 2, 124.75, 'Pericles Comidas clásicas'),
(827, 'SIMOB', 7, '2016-05-06 00:00:00', '2016-06-03 00:00:00', '2022-04-04', 2, 92.2, 'Simons bistro'),
(828, 'RICSU', 8, '2016-05-06 00:00:00', '2016-06-03 00:00:00', '2022-04-04', 2, 30.95, 'Richter Supermarkt'),
(829, 'BONAP', 4, '2016-05-06 00:00:00', '2016-06-03 00:00:00', '2022-04-04', 2, 191.4, 'Bon app'),
(830, 'RATTC', 1, '2016-05-06 00:00:00', '2016-06-03 00:00:00', '2022-04-04', 2, 42.65, 'Rattlesnake Canyon Grocery');
