IN
The IN command allows you to specify multiple values in a WHERE clause.
The IN operator is a shorthand for multiple OR conditions.
The following SQL selects all customers that are located in "Germany", "France" and "UK":
SELECT contactnumeber FROM Customers
WHERE Country IN (SELECT Country FROM Suppliers);
select * from orders limit 4;
select * from customers limit 4;
------------------
Warning: C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe: ignoring option '--no-beep' due to invalid value ''
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.6.51-log MySQL Community Server (GPL)
Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use vlrtraining;
Database changed
mysql> show tables;
+-----------------------+
| Tables_in_vlrtraining |
+-----------------------+
| categories |
| customers |
| employees |
| order details |
| orders |
| products |
| shippers |
| suppliers |
+-----------------------+
8 rows in set (0.00 sec)
mysql> select * from orders limit 4;
+---------+------------+------------+---------------------+---------------------+---------------------+---------+---------+---------------------------+--------------------+----------------+------------+----------------+-------------+
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+---------+---------------------------+--------------------+----------------+------------+----------------+-------------+
| 10248 | VINET | 5 | 1994-08-04 00:00:00 | 1994-09-01 00:00:00 | 1994-08-16 00:00:00 | 3 | 32.3800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10249 | TOMSP | 6 | 1994-08-05 00:00:00 | 1994-09-16 00:00:00 | 1994-08-10 00:00:00 | 1 | 11.6100 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10250 | HANAR | 4 | 1994-08-08 00:00:00 | 1994-09-05 00:00:00 | 1994-08-12 00:00:00 | 2 | 65.8300 | Hanari Carnes | Rua do Paço, 67 | Rio de Janeiro | RJ | 05454-876 | Brazil |
| 10251 | VICTE | 3 | 1994-08-08 00:00:00 | 1994-09-05 00:00:00 | 1994-08-15 00:00:00 | 1 | 41.3400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+---------+---------------------------+--------------------+----------------+------------+----------------+-------------+
4 rows in set (0.00 sec)
mysql> select * from orders where shipcountry="france";
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
| 10248 | VINET | 5 | 1994-08-04 00:00:00 | 1994-09-01 00:00:00 | 1994-08-16 00:00:00 | 3 | 32.3800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10251 | VICTE | 3 | 1994-08-08 00:00:00 | 1994-09-05 00:00:00 | 1994-08-15 00:00:00 | 1 | 41.3400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10265 | BLONP | 2 | 1994-08-25 00:00:00 | 1994-09-22 00:00:00 | 1994-09-12 00:00:00 | 1 | 55.2800 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10274 | VINET | 6 | 1994-09-06 00:00:00 | 1994-10-04 00:00:00 | 1994-09-16 00:00:00 | 1 | 6.0100 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10295 | VINET | 2 | 1994-10-03 00:00:00 | 1994-10-31 00:00:00 | 1994-10-11 00:00:00 | 2 | 1.1500 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10297 | BLONP | 5 | 1994-10-05 00:00:00 | 1994-11-16 00:00:00 | 1994-10-11 00:00:00 | 2 | 5.7400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10311 | DUMON | 1 | 1994-10-21 00:00:00 | 1994-11-04 00:00:00 | 1994-10-27 00:00:00 | 3 | 24.6900 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10331 | BONAP | 9 | 1994-11-16 00:00:00 | 1994-12-28 00:00:00 | 1994-11-21 00:00:00 | 1 | 10.1900 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10334 | VICTE | 8 | 1994-11-21 00:00:00 | 1994-12-19 00:00:00 | 1994-11-28 00:00:00 | 2 | 8.5600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10340 | BONAP | 1 | 1994-11-29 00:00:00 | 1994-12-27 00:00:00 | 1994-12-09 00:00:00 | 3 | 166.3100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10350 | LAMAI | 6 | 1994-12-12 00:00:00 | 1995-01-09 00:00:00 | 1995-01-03 00:00:00 | 2 | 64.1900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10358 | LAMAI | 5 | 1994-12-21 00:00:00 | 1995-01-18 00:00:00 | 1994-12-28 00:00:00 | 1 | 19.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10360 | BLONP | 4 | 1994-12-23 00:00:00 | 1995-01-20 00:00:00 | 1995-01-02 00:00:00 | 3 | 131.7000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10362 | BONAP | 3 | 1994-12-26 00:00:00 | 1995-01-23 00:00:00 | 1994-12-29 00:00:00 | 1 | 96.0400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10371 | LAMAI | 1 | 1995-01-03 00:00:00 | 1995-01-31 00:00:00 | 1995-01-24 00:00:00 | 1 | 0.4500 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10408 | FOLIG | 8 | 1995-02-08 00:00:00 | 1995-03-08 00:00:00 | 1995-02-14 00:00:00 | 1 | 11.2600 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10413 | LAMAI | 3 | 1995-02-14 00:00:00 | 1995-03-14 00:00:00 | 1995-02-16 00:00:00 | 2 | 95.6600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10425 | LAMAI | 6 | 1995-02-24 00:00:00 | 1995-03-24 00:00:00 | 1995-03-17 00:00:00 | 2 | 7.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10436 | BLONP | 3 | 1995-03-08 00:00:00 | 1995-04-05 00:00:00 | 1995-03-14 00:00:00 | 2 | 156.6600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10449 | BLONP | 3 | 1995-03-21 00:00:00 | 1995-04-18 00:00:00 | 1995-03-30 00:00:00 | 2 | 53.3000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10450 | VICTE | 8 | 1995-03-22 00:00:00 | 1995-04-19 00:00:00 | 1995-04-11 00:00:00 | 2 | 7.2300 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10454 | LAMAI | 4 | 1995-03-24 00:00:00 | 1995-04-21 00:00:00 | 1995-03-28 00:00:00 | 3 | 2.7400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10459 | VICTE | 4 | 1995-03-30 00:00:00 | 1995-04-27 00:00:00 | 1995-03-31 00:00:00 | 2 | 25.0900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10470 | BONAP | 4 | 1995-04-11 00:00:00 | 1995-05-09 00:00:00 | 1995-04-14 00:00:00 | 2 | 64.5600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10478 | VICTE | 2 | 1995-04-18 00:00:00 | 1995-05-02 00:00:00 | 1995-04-26 00:00:00 | 3 | 4.8100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10480 | FOLIG | 6 | 1995-04-20 00:00:00 | 1995-05-18 00:00:00 | 1995-04-24 00:00:00 | 2 | 1.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10493 | LAMAI | 4 | 1995-05-03 00:00:00 | 1995-05-31 00:00:00 | 1995-05-11 00:00:00 | 3 | 10.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10500 | LAMAI | 6 | 1995-05-10 00:00:00 | 1995-06-07 00:00:00 | 1995-05-18 00:00:00 | 1 | 42.6800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10511 | BONAP | 4 | 1995-05-19 00:00:00 | 1995-06-16 00:00:00 | 1995-05-22 00:00:00 | 3 | 350.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10525 | BONAP | 1 | 1995-06-02 00:00:00 | 1995-06-30 00:00:00 | 1995-06-23 00:00:00 | 2 | 11.0600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10546 | VICTE | 1 | 1995-06-23 00:00:00 | 1995-07-21 00:00:00 | 1995-06-27 00:00:00 | 3 | 194.7200 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10559 | BLONP | 6 | 1995-07-06 00:00:00 | 1995-08-03 00:00:00 | 1995-07-14 00:00:00 | 1 | 8.0500 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10566 | BLONP | 9 | 1995-07-13 00:00:00 | 1995-08-10 00:00:00 | 1995-07-19 00:00:00 | 1 | 88.4000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10584 | BLONP | 4 | 1995-07-31 00:00:00 | 1995-08-28 00:00:00 | 1995-08-04 00:00:00 | 1 | 59.1400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10609 | DUMON | 7 | 1995-08-24 00:00:00 | 1995-09-21 00:00:00 | 1995-08-30 00:00:00 | 2 | 1.8500 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10610 | LAMAI | 8 | 1995-08-25 00:00:00 | 1995-09-22 00:00:00 | 1995-09-06 00:00:00 | 1 | 26.7800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10628 | BLONP | 4 | 1995-09-12 00:00:00 | 1995-10-10 00:00:00 | 1995-09-20 00:00:00 | 3 | 30.3600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10631 | LAMAI | 8 | 1995-09-14 00:00:00 | 1995-10-12 00:00:00 | 1995-09-15 00:00:00 | 1 | 0.8700 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10634 | FOLIG | 4 | 1995-09-15 00:00:00 | 1995-10-13 00:00:00 | 1995-09-21 00:00:00 | 3 | 487.3800 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10663 | BONAP | 2 | 1995-10-11 00:00:00 | 1995-10-25 00:00:00 | 1995-11-03 00:00:00 | 2 | 113.1500 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10671 | FRANR | 1 | 1995-10-18 00:00:00 | 1995-11-15 00:00:00 | 1995-10-25 00:00:00 | 1 | 30.3400 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10679 | BLONP | 8 | 1995-10-24 00:00:00 | 1995-11-21 00:00:00 | 1995-10-31 00:00:00 | 3 | 27.9400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10683 | DUMON | 2 | 1995-10-27 00:00:00 | 1995-11-24 00:00:00 | 1995-11-01 00:00:00 | 1 | 4.4000 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10715 | BONAP | 3 | 1995-11-23 00:00:00 | 1995-12-07 00:00:00 | 1995-11-29 00:00:00 | 1 | 63.2000 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10730 | BONAP | 5 | 1995-12-06 00:00:00 | 1996-01-03 00:00:00 | 1995-12-15 00:00:00 | 1 | 20.1200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10732 | BONAP | 3 | 1995-12-07 00:00:00 | 1996-01-04 00:00:00 | 1995-12-08 00:00:00 | 1 | 16.9700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10737 | VINET | 2 | 1995-12-12 00:00:00 | 1996-01-09 00:00:00 | 1995-12-19 00:00:00 | 2 | 7.7900 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10738 | SPECD | 2 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-19 00:00:00 | 1 | 2.9100 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10739 | VINET | 3 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-18 00:00:00 | 3 | 11.0800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10755 | BONAP | 4 | 1995-12-27 00:00:00 | 1996-01-24 00:00:00 | 1995-12-29 00:00:00 | 2 | 16.7100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10763 | FOLIG | 3 | 1996-01-03 00:00:00 | 1996-01-31 00:00:00 | 1996-01-08 00:00:00 | 3 | 37.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10787 | LAMAI | 2 | 1996-01-19 00:00:00 | 1996-02-02 00:00:00 | 1996-01-26 00:00:00 | 1 | 249.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10789 | FOLIG | 1 | 1996-01-22 00:00:00 | 1996-02-19 00:00:00 | 1996-01-31 00:00:00 | 2 | 100.6000 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10806 | VICTE | 3 | 1996-01-31 00:00:00 | 1996-02-28 00:00:00 | 1996-02-05 00:00:00 | 2 | 22.1100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10814 | VICTE | 3 | 1996-02-05 00:00:00 | 1996-03-04 00:00:00 | 1996-02-14 00:00:00 | 3 | 130.9400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10826 | BLONP | 6 | 1996-02-12 00:00:00 | 1996-03-11 00:00:00 | 1996-03-08 00:00:00 | 1 | 7.0900 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10827 | BONAP | 1 | 1996-02-12 00:00:00 | 1996-02-26 00:00:00 | 1996-03-08 00:00:00 | 2 | 63.5400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10832 | LAMAI | 2 | 1996-02-14 00:00:00 | 1996-03-13 00:00:00 | 1996-02-19 00:00:00 | 2 | 43.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10843 | VICTE | 4 | 1996-02-21 00:00:00 | 1996-03-20 00:00:00 | 1996-02-26 00:00:00 | 2 | 9.2600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10850 | VICTE | 1 | 1996-02-23 00:00:00 | 1996-04-05 00:00:00 | 1996-03-01 00:00:00 | 1 | 49.1900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10858 | LACOR | 2 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-05 00:00:00 | 1 | 52.5100 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10860 | FRANR | 3 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-06 00:00:00 | 3 | 19.2600 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10871 | BONAP | 9 | 1996-03-07 00:00:00 | 1996-04-04 00:00:00 | 1996-03-12 00:00:00 | 2 | 112.2700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10876 | BONAP | 7 | 1996-03-11 00:00:00 | 1996-04-08 00:00:00 | 1996-03-14 00:00:00 | 3 | 60.4200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10890 | DUMON | 7 | 1996-03-18 00:00:00 | 1996-04-15 00:00:00 | 1996-03-20 00:00:00 | 1 | 32.7600 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10907 | SPECD | 6 | 1996-03-27 00:00:00 | 1996-04-24 00:00:00 | 1996-03-29 00:00:00 | 3 | 9.1900 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10923 | LAMAI | 7 | 1996-04-02 00:00:00 | 1996-05-14 00:00:00 | 1996-04-12 00:00:00 | 3 | 68.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10927 | LACOR | 4 | 1996-04-04 00:00:00 | 1996-05-02 00:00:00 | 1996-05-08 00:00:00 | 1 | 19.7900 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10932 | BONAP | 8 | 1996-04-05 00:00:00 | 1996-05-03 00:00:00 | 1996-04-23 00:00:00 | 1 | 134.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10940 | BONAP | 8 | 1996-04-10 00:00:00 | 1996-05-08 00:00:00 | 1996-04-22 00:00:00 | 3 | 19.7700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10964 | SPECD | 3 | 1996-04-19 00:00:00 | 1996-05-17 00:00:00 | 1996-04-23 00:00:00 | 2 | 87.3800 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10971 | FRANR | 2 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-05-02 00:00:00 | 2 | 121.8200 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10972 | LACOR | 4 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-25 00:00:00 | 2 | 0.0200 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10973 | LACOR | 6 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-26 00:00:00 | 2 | 15.1700 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 11043 | SPECD | 5 | 1996-05-22 00:00:00 | 1996-06-19 00:00:00 | 1996-05-29 00:00:00 | 2 | 8.8000 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 11051 | LAMAI | 7 | 1996-05-27 00:00:00 | 1996-06-24 00:00:00 | NULL | 3 | 2.7900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 11076 | BONAP | 4 | 1996-06-05 00:00:00 | 1996-07-03 00:00:00 | NULL | 2 | 38.2800 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
77 rows in set (0.00 sec)
mysql> select * from orders where shipcountry in("france","india");
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
| 10248 | VINET | 5 | 1994-08-04 00:00:00 | 1994-09-01 00:00:00 | 1994-08-16 00:00:00 | 3 | 32.3800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10251 | VICTE | 3 | 1994-08-08 00:00:00 | 1994-09-05 00:00:00 | 1994-08-15 00:00:00 | 1 | 41.3400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10265 | BLONP | 2 | 1994-08-25 00:00:00 | 1994-09-22 00:00:00 | 1994-09-12 00:00:00 | 1 | 55.2800 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10274 | VINET | 6 | 1994-09-06 00:00:00 | 1994-10-04 00:00:00 | 1994-09-16 00:00:00 | 1 | 6.0100 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10295 | VINET | 2 | 1994-10-03 00:00:00 | 1994-10-31 00:00:00 | 1994-10-11 00:00:00 | 2 | 1.1500 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10297 | BLONP | 5 | 1994-10-05 00:00:00 | 1994-11-16 00:00:00 | 1994-10-11 00:00:00 | 2 | 5.7400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10311 | DUMON | 1 | 1994-10-21 00:00:00 | 1994-11-04 00:00:00 | 1994-10-27 00:00:00 | 3 | 24.6900 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10331 | BONAP | 9 | 1994-11-16 00:00:00 | 1994-12-28 00:00:00 | 1994-11-21 00:00:00 | 1 | 10.1900 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10334 | VICTE | 8 | 1994-11-21 00:00:00 | 1994-12-19 00:00:00 | 1994-11-28 00:00:00 | 2 | 8.5600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10340 | BONAP | 1 | 1994-11-29 00:00:00 | 1994-12-27 00:00:00 | 1994-12-09 00:00:00 | 3 | 166.3100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10350 | LAMAI | 6 | 1994-12-12 00:00:00 | 1995-01-09 00:00:00 | 1995-01-03 00:00:00 | 2 | 64.1900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10358 | LAMAI | 5 | 1994-12-21 00:00:00 | 1995-01-18 00:00:00 | 1994-12-28 00:00:00 | 1 | 19.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10360 | BLONP | 4 | 1994-12-23 00:00:00 | 1995-01-20 00:00:00 | 1995-01-02 00:00:00 | 3 | 131.7000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10362 | BONAP | 3 | 1994-12-26 00:00:00 | 1995-01-23 00:00:00 | 1994-12-29 00:00:00 | 1 | 96.0400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10371 | LAMAI | 1 | 1995-01-03 00:00:00 | 1995-01-31 00:00:00 | 1995-01-24 00:00:00 | 1 | 0.4500 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10408 | FOLIG | 8 | 1995-02-08 00:00:00 | 1995-03-08 00:00:00 | 1995-02-14 00:00:00 | 1 | 11.2600 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10413 | LAMAI | 3 | 1995-02-14 00:00:00 | 1995-03-14 00:00:00 | 1995-02-16 00:00:00 | 2 | 95.6600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10425 | LAMAI | 6 | 1995-02-24 00:00:00 | 1995-03-24 00:00:00 | 1995-03-17 00:00:00 | 2 | 7.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10436 | BLONP | 3 | 1995-03-08 00:00:00 | 1995-04-05 00:00:00 | 1995-03-14 00:00:00 | 2 | 156.6600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10449 | BLONP | 3 | 1995-03-21 00:00:00 | 1995-04-18 00:00:00 | 1995-03-30 00:00:00 | 2 | 53.3000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10450 | VICTE | 8 | 1995-03-22 00:00:00 | 1995-04-19 00:00:00 | 1995-04-11 00:00:00 | 2 | 7.2300 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10454 | LAMAI | 4 | 1995-03-24 00:00:00 | 1995-04-21 00:00:00 | 1995-03-28 00:00:00 | 3 | 2.7400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10459 | VICTE | 4 | 1995-03-30 00:00:00 | 1995-04-27 00:00:00 | 1995-03-31 00:00:00 | 2 | 25.0900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10470 | BONAP | 4 | 1995-04-11 00:00:00 | 1995-05-09 00:00:00 | 1995-04-14 00:00:00 | 2 | 64.5600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10478 | VICTE | 2 | 1995-04-18 00:00:00 | 1995-05-02 00:00:00 | 1995-04-26 00:00:00 | 3 | 4.8100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10480 | FOLIG | 6 | 1995-04-20 00:00:00 | 1995-05-18 00:00:00 | 1995-04-24 00:00:00 | 2 | 1.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10493 | LAMAI | 4 | 1995-05-03 00:00:00 | 1995-05-31 00:00:00 | 1995-05-11 00:00:00 | 3 | 10.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10500 | LAMAI | 6 | 1995-05-10 00:00:00 | 1995-06-07 00:00:00 | 1995-05-18 00:00:00 | 1 | 42.6800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10511 | BONAP | 4 | 1995-05-19 00:00:00 | 1995-06-16 00:00:00 | 1995-05-22 00:00:00 | 3 | 350.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10525 | BONAP | 1 | 1995-06-02 00:00:00 | 1995-06-30 00:00:00 | 1995-06-23 00:00:00 | 2 | 11.0600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10546 | VICTE | 1 | 1995-06-23 00:00:00 | 1995-07-21 00:00:00 | 1995-06-27 00:00:00 | 3 | 194.7200 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10559 | BLONP | 6 | 1995-07-06 00:00:00 | 1995-08-03 00:00:00 | 1995-07-14 00:00:00 | 1 | 8.0500 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10566 | BLONP | 9 | 1995-07-13 00:00:00 | 1995-08-10 00:00:00 | 1995-07-19 00:00:00 | 1 | 88.4000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10584 | BLONP | 4 | 1995-07-31 00:00:00 | 1995-08-28 00:00:00 | 1995-08-04 00:00:00 | 1 | 59.1400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10609 | DUMON | 7 | 1995-08-24 00:00:00 | 1995-09-21 00:00:00 | 1995-08-30 00:00:00 | 2 | 1.8500 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10610 | LAMAI | 8 | 1995-08-25 00:00:00 | 1995-09-22 00:00:00 | 1995-09-06 00:00:00 | 1 | 26.7800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10628 | BLONP | 4 | 1995-09-12 00:00:00 | 1995-10-10 00:00:00 | 1995-09-20 00:00:00 | 3 | 30.3600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10631 | LAMAI | 8 | 1995-09-14 00:00:00 | 1995-10-12 00:00:00 | 1995-09-15 00:00:00 | 1 | 0.8700 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10634 | FOLIG | 4 | 1995-09-15 00:00:00 | 1995-10-13 00:00:00 | 1995-09-21 00:00:00 | 3 | 487.3800 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10663 | BONAP | 2 | 1995-10-11 00:00:00 | 1995-10-25 00:00:00 | 1995-11-03 00:00:00 | 2 | 113.1500 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10671 | FRANR | 1 | 1995-10-18 00:00:00 | 1995-11-15 00:00:00 | 1995-10-25 00:00:00 | 1 | 30.3400 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10679 | BLONP | 8 | 1995-10-24 00:00:00 | 1995-11-21 00:00:00 | 1995-10-31 00:00:00 | 3 | 27.9400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10683 | DUMON | 2 | 1995-10-27 00:00:00 | 1995-11-24 00:00:00 | 1995-11-01 00:00:00 | 1 | 4.4000 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10715 | BONAP | 3 | 1995-11-23 00:00:00 | 1995-12-07 00:00:00 | 1995-11-29 00:00:00 | 1 | 63.2000 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10730 | BONAP | 5 | 1995-12-06 00:00:00 | 1996-01-03 00:00:00 | 1995-12-15 00:00:00 | 1 | 20.1200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10732 | BONAP | 3 | 1995-12-07 00:00:00 | 1996-01-04 00:00:00 | 1995-12-08 00:00:00 | 1 | 16.9700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10737 | VINET | 2 | 1995-12-12 00:00:00 | 1996-01-09 00:00:00 | 1995-12-19 00:00:00 | 2 | 7.7900 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10738 | SPECD | 2 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-19 00:00:00 | 1 | 2.9100 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10739 | VINET | 3 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-18 00:00:00 | 3 | 11.0800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10755 | BONAP | 4 | 1995-12-27 00:00:00 | 1996-01-24 00:00:00 | 1995-12-29 00:00:00 | 2 | 16.7100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10763 | FOLIG | 3 | 1996-01-03 00:00:00 | 1996-01-31 00:00:00 | 1996-01-08 00:00:00 | 3 | 37.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10787 | LAMAI | 2 | 1996-01-19 00:00:00 | 1996-02-02 00:00:00 | 1996-01-26 00:00:00 | 1 | 249.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10789 | FOLIG | 1 | 1996-01-22 00:00:00 | 1996-02-19 00:00:00 | 1996-01-31 00:00:00 | 2 | 100.6000 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10806 | VICTE | 3 | 1996-01-31 00:00:00 | 1996-02-28 00:00:00 | 1996-02-05 00:00:00 | 2 | 22.1100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10814 | VICTE | 3 | 1996-02-05 00:00:00 | 1996-03-04 00:00:00 | 1996-02-14 00:00:00 | 3 | 130.9400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10826 | BLONP | 6 | 1996-02-12 00:00:00 | 1996-03-11 00:00:00 | 1996-03-08 00:00:00 | 1 | 7.0900 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10827 | BONAP | 1 | 1996-02-12 00:00:00 | 1996-02-26 00:00:00 | 1996-03-08 00:00:00 | 2 | 63.5400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10832 | LAMAI | 2 | 1996-02-14 00:00:00 | 1996-03-13 00:00:00 | 1996-02-19 00:00:00 | 2 | 43.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10843 | VICTE | 4 | 1996-02-21 00:00:00 | 1996-03-20 00:00:00 | 1996-02-26 00:00:00 | 2 | 9.2600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10850 | VICTE | 1 | 1996-02-23 00:00:00 | 1996-04-05 00:00:00 | 1996-03-01 00:00:00 | 1 | 49.1900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10858 | LACOR | 2 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-05 00:00:00 | 1 | 52.5100 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10860 | FRANR | 3 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-06 00:00:00 | 3 | 19.2600 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10871 | BONAP | 9 | 1996-03-07 00:00:00 | 1996-04-04 00:00:00 | 1996-03-12 00:00:00 | 2 | 112.2700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10876 | BONAP | 7 | 1996-03-11 00:00:00 | 1996-04-08 00:00:00 | 1996-03-14 00:00:00 | 3 | 60.4200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10890 | DUMON | 7 | 1996-03-18 00:00:00 | 1996-04-15 00:00:00 | 1996-03-20 00:00:00 | 1 | 32.7600 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10907 | SPECD | 6 | 1996-03-27 00:00:00 | 1996-04-24 00:00:00 | 1996-03-29 00:00:00 | 3 | 9.1900 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10923 | LAMAI | 7 | 1996-04-02 00:00:00 | 1996-05-14 00:00:00 | 1996-04-12 00:00:00 | 3 | 68.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10927 | LACOR | 4 | 1996-04-04 00:00:00 | 1996-05-02 00:00:00 | 1996-05-08 00:00:00 | 1 | 19.7900 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10932 | BONAP | 8 | 1996-04-05 00:00:00 | 1996-05-03 00:00:00 | 1996-04-23 00:00:00 | 1 | 134.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10940 | BONAP | 8 | 1996-04-10 00:00:00 | 1996-05-08 00:00:00 | 1996-04-22 00:00:00 | 3 | 19.7700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10964 | SPECD | 3 | 1996-04-19 00:00:00 | 1996-05-17 00:00:00 | 1996-04-23 00:00:00 | 2 | 87.3800 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10971 | FRANR | 2 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-05-02 00:00:00 | 2 | 121.8200 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10972 | LACOR | 4 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-25 00:00:00 | 2 | 0.0200 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10973 | LACOR | 6 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-26 00:00:00 | 2 | 15.1700 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 11043 | SPECD | 5 | 1996-05-22 00:00:00 | 1996-06-19 00:00:00 | 1996-05-29 00:00:00 | 2 | 8.8000 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 11051 | LAMAI | 7 | 1996-05-27 00:00:00 | 1996-06-24 00:00:00 | NULL | 3 | 2.7900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 11076 | BONAP | 4 | 1996-06-05 00:00:00 | 1996-07-03 00:00:00 | NULL | 2 | 38.2800 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+----------+---------------------------+------------------------------+------------+------------+----------------+-------------+
77 rows in set (0.00 sec)
mysql>
mysql> select * from orders where shipcountry in("france","germany");
+---------+------------+------------+---------------------+---------------------+---------------------+---------+-----------+---------------------------+------------------------------+-----------------+------------+----------------+-------------+
| OrderID | CustomerID | EmployeeID | OrderDate | RequiredDate | ShippedDate | ShipVia | Freight | ShipName | ShipAddress | ShipCity | ShipRegion | ShipPostalCode | ShipCountry |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+-----------+---------------------------+------------------------------+-----------------+------------+----------------+-------------+
| 10248 | VINET | 5 | 1994-08-04 00:00:00 | 1994-09-01 00:00:00 | 1994-08-16 00:00:00 | 3 | 32.3800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10249 | TOMSP | 6 | 1994-08-05 00:00:00 | 1994-09-16 00:00:00 | 1994-08-10 00:00:00 | 1 | 11.6100 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10251 | VICTE | 3 | 1994-08-08 00:00:00 | 1994-09-05 00:00:00 | 1994-08-15 00:00:00 | 1 | 41.3400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10260 | OTTIK | 4 | 1994-08-19 00:00:00 | 1994-09-16 00:00:00 | 1994-08-29 00:00:00 | 1 | 55.0900 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10265 | BLONP | 2 | 1994-08-25 00:00:00 | 1994-09-22 00:00:00 | 1994-09-12 00:00:00 | 1 | 55.2800 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10267 | FRANK | 4 | 1994-08-29 00:00:00 | 1994-09-26 00:00:00 | 1994-09-06 00:00:00 | 1 | 208.5800 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10273 | QUICK | 3 | 1994-09-05 00:00:00 | 1994-10-03 00:00:00 | 1994-09-12 00:00:00 | 3 | 76.0700 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10274 | VINET | 6 | 1994-09-06 00:00:00 | 1994-10-04 00:00:00 | 1994-09-16 00:00:00 | 1 | 6.0100 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10277 | MORGK | 2 | 1994-09-09 00:00:00 | 1994-10-07 00:00:00 | 1994-09-13 00:00:00 | 3 | 125.7700 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10279 | LEHMS | 8 | 1994-09-13 00:00:00 | 1994-10-11 00:00:00 | 1994-09-16 00:00:00 | 2 | 25.8300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10284 | LEHMS | 4 | 1994-09-19 00:00:00 | 1994-10-17 00:00:00 | 1994-09-27 00:00:00 | 1 | 76.5600 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10285 | QUICK | 1 | 1994-09-20 00:00:00 | 1994-10-18 00:00:00 | 1994-09-26 00:00:00 | 2 | 76.8300 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10286 | QUICK | 8 | 1994-09-21 00:00:00 | 1994-10-19 00:00:00 | 1994-09-30 00:00:00 | 3 | 229.2400 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10295 | VINET | 2 | 1994-10-03 00:00:00 | 1994-10-31 00:00:00 | 1994-10-11 00:00:00 | 2 | 1.1500 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10297 | BLONP | 5 | 1994-10-05 00:00:00 | 1994-11-16 00:00:00 | 1994-10-11 00:00:00 | 2 | 5.7400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10301 | WANDK | 8 | 1994-10-10 00:00:00 | 1994-11-07 00:00:00 | 1994-10-18 00:00:00 | 2 | 45.0800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10311 | DUMON | 1 | 1994-10-21 00:00:00 | 1994-11-04 00:00:00 | 1994-10-27 00:00:00 | 3 | 24.6900 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10312 | WANDK | 2 | 1994-10-24 00:00:00 | 1994-11-21 00:00:00 | 1994-11-03 00:00:00 | 2 | 40.2600 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10313 | QUICK | 2 | 1994-10-25 00:00:00 | 1994-11-22 00:00:00 | 1994-11-04 00:00:00 | 2 | 1.9600 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10323 | KOENE | 4 | 1994-11-07 00:00:00 | 1994-12-05 00:00:00 | 1994-11-14 00:00:00 | 1 | 4.8800 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10325 | KOENE | 1 | 1994-11-09 00:00:00 | 1994-11-23 00:00:00 | 1994-11-14 00:00:00 | 3 | 64.8600 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10331 | BONAP | 9 | 1994-11-16 00:00:00 | 1994-12-28 00:00:00 | 1994-11-21 00:00:00 | 1 | 10.1900 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10334 | VICTE | 8 | 1994-11-21 00:00:00 | 1994-12-19 00:00:00 | 1994-11-28 00:00:00 | 2 | 8.5600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10337 | FRANK | 4 | 1994-11-24 00:00:00 | 1994-12-22 00:00:00 | 1994-11-29 00:00:00 | 3 | 108.2600 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10340 | BONAP | 1 | 1994-11-29 00:00:00 | 1994-12-27 00:00:00 | 1994-12-09 00:00:00 | 3 | 166.3100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10342 | FRANK | 4 | 1994-11-30 00:00:00 | 1994-12-14 00:00:00 | 1994-12-05 00:00:00 | 2 | 54.8300 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10343 | LEHMS | 4 | 1994-12-01 00:00:00 | 1994-12-29 00:00:00 | 1994-12-07 00:00:00 | 1 | 110.3700 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10345 | QUICK | 2 | 1994-12-05 00:00:00 | 1995-01-02 00:00:00 | 1994-12-12 00:00:00 | 2 | 249.0600 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10348 | WANDK | 4 | 1994-12-08 00:00:00 | 1995-01-05 00:00:00 | 1994-12-16 00:00:00 | 2 | 0.7800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10350 | LAMAI | 6 | 1994-12-12 00:00:00 | 1995-01-09 00:00:00 | 1995-01-03 00:00:00 | 2 | 64.1900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10356 | WANDK | 6 | 1994-12-19 00:00:00 | 1995-01-16 00:00:00 | 1994-12-28 00:00:00 | 2 | 36.7100 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10358 | LAMAI | 5 | 1994-12-21 00:00:00 | 1995-01-18 00:00:00 | 1994-12-28 00:00:00 | 1 | 19.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10360 | BLONP | 4 | 1994-12-23 00:00:00 | 1995-01-20 00:00:00 | 1995-01-02 00:00:00 | 3 | 131.7000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10361 | QUICK | 1 | 1994-12-23 00:00:00 | 1995-01-20 00:00:00 | 1995-01-03 00:00:00 | 2 | 183.1700 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10362 | BONAP | 3 | 1994-12-26 00:00:00 | 1995-01-23 00:00:00 | 1994-12-29 00:00:00 | 1 | 96.0400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10363 | DRACD | 4 | 1994-12-27 00:00:00 | 1995-01-24 00:00:00 | 1995-01-04 00:00:00 | 3 | 30.5400 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 10371 | LAMAI | 1 | 1995-01-03 00:00:00 | 1995-01-31 00:00:00 | 1995-01-24 00:00:00 | 1 | 0.4500 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10391 | DRACD | 3 | 1995-01-23 00:00:00 | 1995-02-20 00:00:00 | 1995-01-31 00:00:00 | 3 | 5.4500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 10396 | FRANK | 1 | 1995-01-27 00:00:00 | 1995-02-10 00:00:00 | 1995-02-06 00:00:00 | 3 | 135.3500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10407 | OTTIK | 2 | 1995-02-07 00:00:00 | 1995-03-07 00:00:00 | 1995-03-02 00:00:00 | 2 | 91.4800 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10408 | FOLIG | 8 | 1995-02-08 00:00:00 | 1995-03-08 00:00:00 | 1995-02-14 00:00:00 | 1 | 11.2600 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10413 | LAMAI | 3 | 1995-02-14 00:00:00 | 1995-03-14 00:00:00 | 1995-02-16 00:00:00 | 2 | 95.6600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10418 | QUICK | 4 | 1995-02-17 00:00:00 | 1995-03-17 00:00:00 | 1995-02-24 00:00:00 | 1 | 17.5500 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10425 | LAMAI | 6 | 1995-02-24 00:00:00 | 1995-03-24 00:00:00 | 1995-03-17 00:00:00 | 2 | 7.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10436 | BLONP | 3 | 1995-03-08 00:00:00 | 1995-04-05 00:00:00 | 1995-03-14 00:00:00 | 2 | 156.6600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10438 | TOMSP | 3 | 1995-03-09 00:00:00 | 1995-04-06 00:00:00 | 1995-03-17 00:00:00 | 2 | 8.2400 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10446 | TOMSP | 6 | 1995-03-17 00:00:00 | 1995-04-14 00:00:00 | 1995-03-22 00:00:00 | 1 | 14.6800 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10449 | BLONP | 3 | 1995-03-21 00:00:00 | 1995-04-18 00:00:00 | 1995-03-30 00:00:00 | 2 | 53.3000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10450 | VICTE | 8 | 1995-03-22 00:00:00 | 1995-04-19 00:00:00 | 1995-04-11 00:00:00 | 2 | 7.2300 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10451 | QUICK | 4 | 1995-03-22 00:00:00 | 1995-04-05 00:00:00 | 1995-04-12 00:00:00 | 3 | 189.0900 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10454 | LAMAI | 4 | 1995-03-24 00:00:00 | 1995-04-21 00:00:00 | 1995-03-28 00:00:00 | 3 | 2.7400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10456 | KOENE | 8 | 1995-03-28 00:00:00 | 1995-05-09 00:00:00 | 1995-03-31 00:00:00 | 2 | 8.1200 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10457 | KOENE | 2 | 1995-03-28 00:00:00 | 1995-04-25 00:00:00 | 1995-04-03 00:00:00 | 1 | 11.5700 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10459 | VICTE | 4 | 1995-03-30 00:00:00 | 1995-04-27 00:00:00 | 1995-03-31 00:00:00 | 2 | 25.0900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10468 | KOENE | 3 | 1995-04-07 00:00:00 | 1995-05-05 00:00:00 | 1995-04-12 00:00:00 | 3 | 44.1200 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10470 | BONAP | 4 | 1995-04-11 00:00:00 | 1995-05-09 00:00:00 | 1995-04-14 00:00:00 | 2 | 64.5600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10478 | VICTE | 2 | 1995-04-18 00:00:00 | 1995-05-02 00:00:00 | 1995-04-26 00:00:00 | 3 | 4.8100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10480 | FOLIG | 6 | 1995-04-20 00:00:00 | 1995-05-18 00:00:00 | 1995-04-24 00:00:00 | 2 | 1.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10488 | FRANK | 8 | 1995-04-27 00:00:00 | 1995-05-25 00:00:00 | 1995-05-03 00:00:00 | 2 | 4.9300 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10493 | LAMAI | 4 | 1995-05-03 00:00:00 | 1995-05-31 00:00:00 | 1995-05-11 00:00:00 | 3 | 10.6400 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10497 | LEHMS | 7 | 1995-05-05 00:00:00 | 1995-06-02 00:00:00 | 1995-05-08 00:00:00 | 1 | 36.2100 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10500 | LAMAI | 6 | 1995-05-10 00:00:00 | 1995-06-07 00:00:00 | 1995-05-18 00:00:00 | 1 | 42.6800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10501 | BLAUS | 9 | 1995-05-10 00:00:00 | 1995-06-07 00:00:00 | 1995-05-17 00:00:00 | 3 | 8.8500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10506 | KOENE | 9 | 1995-05-16 00:00:00 | 1995-06-13 00:00:00 | 1995-06-02 00:00:00 | 2 | 21.1900 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10508 | OTTIK | 1 | 1995-05-17 00:00:00 | 1995-06-14 00:00:00 | 1995-06-13 00:00:00 | 2 | 4.9900 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10509 | BLAUS | 4 | 1995-05-18 00:00:00 | 1995-06-15 00:00:00 | 1995-05-30 00:00:00 | 1 | 0.1500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10511 | BONAP | 4 | 1995-05-19 00:00:00 | 1995-06-16 00:00:00 | 1995-05-22 00:00:00 | 3 | 350.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10513 | WANDK | 7 | 1995-05-23 00:00:00 | 1995-07-04 00:00:00 | 1995-05-29 00:00:00 | 1 | 105.6500 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10515 | QUICK | 2 | 1995-05-24 00:00:00 | 1995-06-07 00:00:00 | 1995-06-23 00:00:00 | 1 | 204.4700 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10522 | LEHMS | 4 | 1995-05-31 00:00:00 | 1995-06-28 00:00:00 | 1995-06-06 00:00:00 | 1 | 45.3300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10525 | BONAP | 1 | 1995-06-02 00:00:00 | 1995-06-30 00:00:00 | 1995-06-23 00:00:00 | 2 | 11.0600 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10527 | QUICK | 7 | 1995-06-05 00:00:00 | 1995-07-03 00:00:00 | 1995-06-07 00:00:00 | 1 | 41.9000 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10534 | LEHMS | 8 | 1995-06-12 00:00:00 | 1995-07-10 00:00:00 | 1995-06-14 00:00:00 | 2 | 27.9400 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10536 | LEHMS | 3 | 1995-06-14 00:00:00 | 1995-07-12 00:00:00 | 1995-07-07 00:00:00 | 2 | 58.8800 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10540 | QUICK | 3 | 1995-06-19 00:00:00 | 1995-07-17 00:00:00 | 1995-07-14 00:00:00 | 3 | 1007.6400 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10542 | KOENE | 1 | 1995-06-20 00:00:00 | 1995-07-18 00:00:00 | 1995-06-26 00:00:00 | 3 | 10.9500 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10546 | VICTE | 1 | 1995-06-23 00:00:00 | 1995-07-21 00:00:00 | 1995-06-27 00:00:00 | 3 | 194.7200 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10548 | TOMSP | 3 | 1995-06-26 00:00:00 | 1995-07-24 00:00:00 | 1995-07-03 00:00:00 | 2 | 1.4300 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10549 | QUICK | 5 | 1995-06-27 00:00:00 | 1995-07-11 00:00:00 | 1995-06-30 00:00:00 | 1 | 171.2400 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10554 | OTTIK | 4 | 1995-06-30 00:00:00 | 1995-07-28 00:00:00 | 1995-07-06 00:00:00 | 3 | 120.9700 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10557 | LEHMS | 9 | 1995-07-04 00:00:00 | 1995-07-18 00:00:00 | 1995-07-07 00:00:00 | 2 | 96.7200 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10559 | BLONP | 6 | 1995-07-06 00:00:00 | 1995-08-03 00:00:00 | 1995-07-14 00:00:00 | 1 | 8.0500 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10560 | FRANK | 8 | 1995-07-07 00:00:00 | 1995-08-04 00:00:00 | 1995-07-10 00:00:00 | 1 | 36.6500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10566 | BLONP | 9 | 1995-07-13 00:00:00 | 1995-08-10 00:00:00 | 1995-07-19 00:00:00 | 1 | 88.4000 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10575 | MORGK | 5 | 1995-07-21 00:00:00 | 1995-08-04 00:00:00 | 1995-07-31 00:00:00 | 1 | 127.3400 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10580 | OTTIK | 4 | 1995-07-27 00:00:00 | 1995-08-24 00:00:00 | 1995-08-01 00:00:00 | 3 | 75.8900 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10582 | BLAUS | 3 | 1995-07-28 00:00:00 | 1995-08-25 00:00:00 | 1995-08-14 00:00:00 | 2 | 27.7100 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10584 | BLONP | 4 | 1995-07-31 00:00:00 | 1995-08-28 00:00:00 | 1995-08-04 00:00:00 | 1 | 59.1400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10588 | QUICK | 2 | 1995-08-03 00:00:00 | 1995-08-31 00:00:00 | 1995-08-10 00:00:00 | 3 | 194.6700 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10592 | LEHMS | 3 | 1995-08-08 00:00:00 | 1995-09-05 00:00:00 | 1995-08-16 00:00:00 | 1 | 32.1000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10593 | LEHMS | 7 | 1995-08-09 00:00:00 | 1995-09-06 00:00:00 | 1995-09-13 00:00:00 | 2 | 174.2000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10608 | TOMSP | 4 | 1995-08-23 00:00:00 | 1995-09-20 00:00:00 | 1995-09-01 00:00:00 | 2 | 27.7900 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10609 | DUMON | 7 | 1995-08-24 00:00:00 | 1995-09-21 00:00:00 | 1995-08-30 00:00:00 | 2 | 1.8500 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10610 | LAMAI | 8 | 1995-08-25 00:00:00 | 1995-09-22 00:00:00 | 1995-09-06 00:00:00 | 1 | 26.7800 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10614 | BLAUS | 8 | 1995-08-29 00:00:00 | 1995-09-26 00:00:00 | 1995-09-01 00:00:00 | 3 | 1.9300 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10623 | FRANK | 8 | 1995-09-07 00:00:00 | 1995-10-05 00:00:00 | 1995-09-12 00:00:00 | 2 | 97.1800 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10628 | BLONP | 4 | 1995-09-12 00:00:00 | 1995-10-10 00:00:00 | 1995-09-20 00:00:00 | 3 | 30.3600 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10630 | KOENE | 1 | 1995-09-13 00:00:00 | 1995-10-11 00:00:00 | 1995-09-19 00:00:00 | 2 | 32.3500 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10631 | LAMAI | 8 | 1995-09-14 00:00:00 | 1995-10-12 00:00:00 | 1995-09-15 00:00:00 | 1 | 0.8700 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10632 | WANDK | 8 | 1995-09-14 00:00:00 | 1995-10-12 00:00:00 | 1995-09-19 00:00:00 | 1 | 41.3800 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10634 | FOLIG | 4 | 1995-09-15 00:00:00 | 1995-10-13 00:00:00 | 1995-09-21 00:00:00 | 3 | 487.3800 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10640 | WANDK | 4 | 1995-09-21 00:00:00 | 1995-10-19 00:00:00 | 1995-09-28 00:00:00 | 1 | 23.5500 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10643 | ALFKI | 6 | 1995-09-25 00:00:00 | 1995-10-23 00:00:00 | 1995-10-03 00:00:00 | 1 | 29.4600 | Alfreds Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 10651 | WANDK | 8 | 1995-10-02 00:00:00 | 1995-10-30 00:00:00 | 1995-10-12 00:00:00 | 2 | 20.6000 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10653 | FRANK | 1 | 1995-10-03 00:00:00 | 1995-10-31 00:00:00 | 1995-10-20 00:00:00 | 1 | 93.2500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10658 | QUICK | 4 | 1995-10-06 00:00:00 | 1995-11-03 00:00:00 | 1995-10-09 00:00:00 | 1 | 364.1500 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10663 | BONAP | 2 | 1995-10-11 00:00:00 | 1995-10-25 00:00:00 | 1995-11-03 00:00:00 | 2 | 113.1500 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10668 | WANDK | 1 | 1995-10-16 00:00:00 | 1995-11-13 00:00:00 | 1995-10-24 00:00:00 | 2 | 47.2200 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 10670 | FRANK | 4 | 1995-10-17 00:00:00 | 1995-11-14 00:00:00 | 1995-10-19 00:00:00 | 1 | 203.4800 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10671 | FRANR | 1 | 1995-10-18 00:00:00 | 1995-11-15 00:00:00 | 1995-10-25 00:00:00 | 1 | 30.3400 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10675 | FRANK | 5 | 1995-10-20 00:00:00 | 1995-11-17 00:00:00 | 1995-10-24 00:00:00 | 2 | 31.8500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10679 | BLONP | 8 | 1995-10-24 00:00:00 | 1995-11-21 00:00:00 | 1995-10-31 00:00:00 | 3 | 27.9400 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10683 | DUMON | 2 | 1995-10-27 00:00:00 | 1995-11-24 00:00:00 | 1995-11-01 00:00:00 | 1 | 4.4000 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10684 | OTTIK | 3 | 1995-10-27 00:00:00 | 1995-11-24 00:00:00 | 1995-10-31 00:00:00 | 1 | 145.6300 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10691 | QUICK | 2 | 1995-11-03 00:00:00 | 1995-12-15 00:00:00 | 1995-11-22 00:00:00 | 2 | 810.0500 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10692 | ALFKI | 4 | 1995-11-03 00:00:00 | 1995-12-01 00:00:00 | 1995-11-13 00:00:00 | 2 | 61.0200 | Alfred's Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 10694 | QUICK | 8 | 1995-11-06 00:00:00 | 1995-12-04 00:00:00 | 1995-11-09 00:00:00 | 3 | 398.3600 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10699 | MORGK | 3 | 1995-11-09 00:00:00 | 1995-12-07 00:00:00 | 1995-11-13 00:00:00 | 3 | 0.5800 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10702 | ALFKI | 4 | 1995-11-13 00:00:00 | 1995-12-25 00:00:00 | 1995-11-21 00:00:00 | 1 | 23.9400 | Alfred's Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 10715 | BONAP | 3 | 1995-11-23 00:00:00 | 1995-12-07 00:00:00 | 1995-11-29 00:00:00 | 1 | 63.2000 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10717 | FRANK | 1 | 1995-11-24 00:00:00 | 1995-12-22 00:00:00 | 1995-11-29 00:00:00 | 2 | 59.2500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10718 | KOENE | 1 | 1995-11-27 00:00:00 | 1995-12-25 00:00:00 | 1995-11-29 00:00:00 | 3 | 170.8800 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10721 | QUICK | 5 | 1995-11-29 00:00:00 | 1995-12-27 00:00:00 | 1995-12-01 00:00:00 | 3 | 48.9200 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10730 | BONAP | 5 | 1995-12-06 00:00:00 | 1996-01-03 00:00:00 | 1995-12-15 00:00:00 | 1 | 20.1200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10732 | BONAP | 3 | 1995-12-07 00:00:00 | 1996-01-04 00:00:00 | 1995-12-08 00:00:00 | 1 | 16.9700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10737 | VINET | 2 | 1995-12-12 00:00:00 | 1996-01-09 00:00:00 | 1995-12-19 00:00:00 | 2 | 7.7900 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10738 | SPECD | 2 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-19 00:00:00 | 1 | 2.9100 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10739 | VINET | 3 | 1995-12-13 00:00:00 | 1996-01-10 00:00:00 | 1995-12-18 00:00:00 | 3 | 11.0800 | Vins et alcools Chevalier | 59 rue de l'Abbaye | Reims | NULL | 51100 | France |
| 10745 | QUICK | 9 | 1995-12-19 00:00:00 | 1996-01-16 00:00:00 | 1995-12-28 00:00:00 | 1 | 3.5200 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10755 | BONAP | 4 | 1995-12-27 00:00:00 | 1996-01-24 00:00:00 | 1995-12-29 00:00:00 | 2 | 16.7100 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10763 | FOLIG | 3 | 1996-01-03 00:00:00 | 1996-01-31 00:00:00 | 1996-01-08 00:00:00 | 3 | 37.3500 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10765 | QUICK | 3 | 1996-01-04 00:00:00 | 1996-02-01 00:00:00 | 1996-01-09 00:00:00 | 3 | 42.7400 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10766 | OTTIK | 4 | 1996-01-05 00:00:00 | 1996-02-02 00:00:00 | 1996-01-09 00:00:00 | 1 | 157.5500 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10772 | LEHMS | 3 | 1996-01-10 00:00:00 | 1996-02-07 00:00:00 | 1996-01-19 00:00:00 | 2 | 91.2800 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10779 | MORGK | 3 | 1996-01-16 00:00:00 | 1996-02-13 00:00:00 | 1996-02-14 00:00:00 | 2 | 58.1300 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10787 | LAMAI | 2 | 1996-01-19 00:00:00 | 1996-02-02 00:00:00 | 1996-01-26 00:00:00 | 1 | 249.9300 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10788 | QUICK | 1 | 1996-01-22 00:00:00 | 1996-02-19 00:00:00 | 1996-02-19 00:00:00 | 2 | 42.7000 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10789 | FOLIG | 1 | 1996-01-22 00:00:00 | 1996-02-19 00:00:00 | 1996-01-31 00:00:00 | 2 | 100.6000 | Folies gourmandes | 184, chauss├®e de Tournai | Lille | NULL | 59000 | France |
| 10791 | FRANK | 6 | 1996-01-23 00:00:00 | 1996-02-20 00:00:00 | 1996-02-01 00:00:00 | 2 | 16.8500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10797 | DRACD | 7 | 1996-01-25 00:00:00 | 1996-02-22 00:00:00 | 1996-02-05 00:00:00 | 2 | 33.3500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 10799 | KOENE | 9 | 1996-01-26 00:00:00 | 1996-03-08 00:00:00 | 1996-02-05 00:00:00 | 3 | 30.7600 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10806 | VICTE | 3 | 1996-01-31 00:00:00 | 1996-02-28 00:00:00 | 1996-02-05 00:00:00 | 2 | 22.1100 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10814 | VICTE | 3 | 1996-02-05 00:00:00 | 1996-03-04 00:00:00 | 1996-02-14 00:00:00 | 3 | 130.9400 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10817 | KOENE | 3 | 1996-02-06 00:00:00 | 1996-02-20 00:00:00 | 1996-02-13 00:00:00 | 2 | 306.0700 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10825 | DRACD | 1 | 1996-02-09 00:00:00 | 1996-03-08 00:00:00 | 1996-02-14 00:00:00 | 1 | 79.2500 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 10826 | BLONP | 6 | 1996-02-12 00:00:00 | 1996-03-11 00:00:00 | 1996-03-08 00:00:00 | 1 | 7.0900 | Blondel p├¿re et fils | 24, place Kl├®ber | Strasbourg | NULL | 67000 | France |
| 10827 | BONAP | 1 | 1996-02-12 00:00:00 | 1996-02-26 00:00:00 | 1996-03-08 00:00:00 | 2 | 63.5400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10832 | LAMAI | 2 | 1996-02-14 00:00:00 | 1996-03-13 00:00:00 | 1996-02-19 00:00:00 | 2 | 43.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10833 | OTTIK | 6 | 1996-02-15 00:00:00 | 1996-03-14 00:00:00 | 1996-02-23 00:00:00 | 2 | 71.4900 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 10835 | ALFKI | 1 | 1996-02-15 00:00:00 | 1996-03-14 00:00:00 | 1996-02-21 00:00:00 | 3 | 69.5300 | Alfred's Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 10843 | VICTE | 4 | 1996-02-21 00:00:00 | 1996-03-20 00:00:00 | 1996-02-26 00:00:00 | 2 | 9.2600 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10845 | QUICK | 8 | 1996-02-21 00:00:00 | 1996-03-06 00:00:00 | 1996-03-01 00:00:00 | 1 | 212.9800 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10849 | KOENE | 9 | 1996-02-23 00:00:00 | 1996-03-22 00:00:00 | 1996-03-01 00:00:00 | 2 | 0.5600 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10850 | VICTE | 1 | 1996-02-23 00:00:00 | 1996-04-05 00:00:00 | 1996-03-01 00:00:00 | 1 | 49.1900 | Victuailles en stock | 2, rue du Commerce | Lyon | NULL | 69004 | France |
| 10853 | BLAUS | 9 | 1996-02-27 00:00:00 | 1996-03-26 00:00:00 | 1996-03-05 00:00:00 | 2 | 53.8300 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10858 | LACOR | 2 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-05 00:00:00 | 1 | 52.5100 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10859 | FRANK | 1 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-04 00:00:00 | 2 | 76.1000 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10860 | FRANR | 3 | 1996-02-29 00:00:00 | 1996-03-28 00:00:00 | 1996-03-06 00:00:00 | 3 | 19.2600 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10862 | LEHMS | 8 | 1996-03-01 00:00:00 | 1996-04-12 00:00:00 | 1996-03-04 00:00:00 | 2 | 53.2300 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10865 | QUICK | 2 | 1996-03-04 00:00:00 | 1996-03-18 00:00:00 | 1996-03-14 00:00:00 | 1 | 348.1400 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10871 | BONAP | 9 | 1996-03-07 00:00:00 | 1996-04-04 00:00:00 | 1996-03-12 00:00:00 | 2 | 112.2700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10876 | BONAP | 7 | 1996-03-11 00:00:00 | 1996-04-08 00:00:00 | 1996-03-14 00:00:00 | 3 | 60.4200 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10878 | QUICK | 4 | 1996-03-12 00:00:00 | 1996-04-09 00:00:00 | 1996-03-14 00:00:00 | 1 | 46.6900 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10890 | DUMON | 7 | 1996-03-18 00:00:00 | 1996-04-15 00:00:00 | 1996-03-20 00:00:00 | 1 | 32.7600 | Du monde entier | 67, rue des Cinquante Otages | Nantes | NULL | 44000 | France |
| 10891 | LEHMS | 7 | 1996-03-19 00:00:00 | 1996-04-16 00:00:00 | 1996-03-21 00:00:00 | 2 | 20.3700 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10893 | KOENE | 9 | 1996-03-20 00:00:00 | 1996-04-17 00:00:00 | 1996-03-22 00:00:00 | 2 | 77.7800 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 10907 | SPECD | 6 | 1996-03-27 00:00:00 | 1996-04-24 00:00:00 | 1996-03-29 00:00:00 | 3 | 9.1900 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10923 | LAMAI | 7 | 1996-04-02 00:00:00 | 1996-05-14 00:00:00 | 1996-04-12 00:00:00 | 3 | 68.2600 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 10927 | LACOR | 4 | 1996-04-04 00:00:00 | 1996-05-02 00:00:00 | 1996-05-08 00:00:00 | 1 | 19.7900 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10929 | FRANK | 6 | 1996-04-04 00:00:00 | 1996-05-02 00:00:00 | 1996-04-11 00:00:00 | 1 | 33.9300 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 10932 | BONAP | 8 | 1996-04-05 00:00:00 | 1996-05-03 00:00:00 | 1996-04-23 00:00:00 | 1 | 134.6400 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10934 | LEHMS | 3 | 1996-04-08 00:00:00 | 1996-05-06 00:00:00 | 1996-04-11 00:00:00 | 3 | 32.0100 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 10938 | QUICK | 3 | 1996-04-09 00:00:00 | 1996-05-07 00:00:00 | 1996-04-15 00:00:00 | 2 | 31.8900 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10940 | BONAP | 8 | 1996-04-10 00:00:00 | 1996-05-08 00:00:00 | 1996-04-22 00:00:00 | 3 | 19.7700 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
| 10945 | MORGK | 4 | 1996-04-11 00:00:00 | 1996-05-09 00:00:00 | 1996-04-17 00:00:00 | 1 | 10.2200 | Morgenstern Gesundkost | Heerstr. 22 | Leipzig | NULL | 04179 | Germany |
| 10952 | ALFKI | 1 | 1996-04-15 00:00:00 | 1996-05-27 00:00:00 | 1996-04-23 00:00:00 | 1 | 40.4200 | Alfred's Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 10956 | BLAUS | 6 | 1996-04-16 00:00:00 | 1996-05-28 00:00:00 | 1996-04-19 00:00:00 | 2 | 44.6500 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 10962 | QUICK | 8 | 1996-04-18 00:00:00 | 1996-05-16 00:00:00 | 1996-04-22 00:00:00 | 2 | 275.7900 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10964 | SPECD | 3 | 1996-04-19 00:00:00 | 1996-05-17 00:00:00 | 1996-04-23 00:00:00 | 2 | 87.3800 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 10967 | TOMSP | 2 | 1996-04-22 00:00:00 | 1996-05-20 00:00:00 | 1996-05-02 00:00:00 | 2 | 62.2200 | Toms Spezialitäten | Luisenstr. 48 | Münster | NULL | 44087 | Germany |
| 10971 | FRANR | 2 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-05-02 00:00:00 | 2 | 121.8200 | France restauration | 54, rue Royale | Nantes | NULL | 44000 | France |
| 10972 | LACOR | 4 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-25 00:00:00 | 2 | 0.0200 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10973 | LACOR | 6 | 1996-04-23 00:00:00 | 1996-05-21 00:00:00 | 1996-04-26 00:00:00 | 2 | 15.1700 | La corne d'abondance | 67, avenue de l'Europe | Versailles | NULL | 78000 | France |
| 10991 | QUICK | 1 | 1996-05-01 00:00:00 | 1996-05-29 00:00:00 | 1996-05-07 00:00:00 | 1 | 38.5100 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10996 | QUICK | 4 | 1996-05-02 00:00:00 | 1996-05-30 00:00:00 | 1996-05-10 00:00:00 | 2 | 1.1200 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 10999 | OTTIK | 6 | 1996-05-03 00:00:00 | 1996-05-31 00:00:00 | 1996-05-10 00:00:00 | 2 | 96.3500 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 11011 | ALFKI | 3 | 1996-05-09 00:00:00 | 1996-06-06 00:00:00 | 1996-05-13 00:00:00 | 1 | 1.2100 | Alfred's Futterkiste | Obere Str. 57 | Berlin | NULL | 12209 | Germany |
| 11012 | FRANK | 1 | 1996-05-09 00:00:00 | 1996-05-23 00:00:00 | 1996-05-17 00:00:00 | 3 | 242.9500 | Frankenversand | Berliner Platz 43 | M├╝nchen | NULL | 80805 | Germany |
| 11020 | OTTIK | 2 | 1996-05-14 00:00:00 | 1996-06-11 00:00:00 | 1996-05-16 00:00:00 | 2 | 43.3000 | Ottilies K├ñseladen | Mehrheimerstr. 369 | K├Âln | NULL | 50739 | Germany |
| 11021 | QUICK | 3 | 1996-05-14 00:00:00 | 1996-06-11 00:00:00 | 1996-05-21 00:00:00 | 1 | 297.1800 | QUICK-Stop | Taucherstraße 10 | Cunewalde | NULL | 01307 | Germany |
| 11028 | KOENE | 2 | 1996-05-16 00:00:00 | 1996-06-13 00:00:00 | 1996-05-22 00:00:00 | 1 | 29.5900 | K├Âniglich Essen | Maubelstr. 90 | Brandenburg | NULL | 14776 | Germany |
| 11036 | DRACD | 8 | 1996-05-20 00:00:00 | 1996-06-17 00:00:00 | 1996-05-22 00:00:00 | 3 | 149.4700 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 11043 | SPECD | 5 | 1996-05-22 00:00:00 | 1996-06-19 00:00:00 | 1996-05-29 00:00:00 | 2 | 8.8000 | Sp├®cialit├®s du monde | 25, rue Lauriston | Paris | NULL | 75016 | France |
| 11046 | WANDK | 8 | 1996-05-23 00:00:00 | 1996-06-20 00:00:00 | 1996-05-24 00:00:00 | 2 | 71.6400 | Die Wandernde Kuh | Adenauerallee 900 | Stuttgart | NULL | 70563 | Germany |
| 11051 | LAMAI | 7 | 1996-05-27 00:00:00 | 1996-06-24 00:00:00 | NULL | 3 | 2.7900 | La maison d'Asie | 1 rue Alsace-Lorraine | Toulouse | NULL | 31000 | France |
| 11058 | BLAUS | 9 | 1996-05-29 00:00:00 | 1996-06-26 00:00:00 | NULL | 3 | 31.1400 | Blauer See Delikatessen | Forsterstr. 57 | Mannheim | NULL | 68306 | Germany |
| 11067 | DRACD | 1 | 1996-06-03 00:00:00 | 1996-06-17 00:00:00 | 1996-06-05 00:00:00 | 2 | 7.9800 | Drachenblut Delikatessen | Walserweg 21 | Aachen | NULL | 52066 | Germany |
| 11070 | LEHMS | 2 | 1996-06-04 00:00:00 | 1996-07-02 00:00:00 | NULL | 1 | 136.0000 | Lehmanns Marktstand | Magazinweg 7 | Frankfurt a.M. | NULL | 60528 | Germany |
| 11076 | BONAP | 4 | 1996-06-05 00:00:00 | 1996-07-03 00:00:00 | NULL | 2 | 38.2800 | Bon app' | 12, rue des Bouchers | Marseille | NULL | 13008 | France |
+---------+------------+------------+---------------------+---------------------+---------------------+---------+-----------+---------------------------+------------------------------+-----------------+------------+----------------+-------------+
199 rows in set (0.00 sec)
mysql> select * from customers limit 4;
+------------+------------------------------------+----------------+----------------------+--------------------------------+--------------+--------+------------+---------+----------------+----------------+-------+----------------+
| CustomerID | CompanyName | ContactName | ContactTitle | Address | City | Region | PostalCode | Country | Phone | Fax | Image | ImageThumbnail |
+------------+------------------------------------+----------------+----------------------+--------------------------------+--------------+--------+------------+---------+----------------+----------------+-------+----------------+
| ALFKI | Alfreds Futterkiste | Maria Anders | Sales Representative | Obere Str. 57 | Berlin | NULL | 12209 | Germany | 030-0074321 | 030-0076545 | NULL | NULL |
| ANATR | Ana Trujillo Emparedados y helados | Ana Trujillo | Owner | Avda. de la Constituci├│n 2222 | M├®xico D.F. | NULL | 05021 | Mexico | (5) 555-4729 | (5) 555-3745 | NULL | NULL |
| ANTON | Antonio Moreno Taquer├¡a | Antonio Moreno | Owner | Mataderos 2312 | M├®xico D.F. | NULL | 05023 | Mexico | (5) 555-3932 | NULL | NULL | NULL |
| AROUT | Around the Horn | Thomas Hardy | Sales Representative | 120 Hanover Sq. | London | NULL | WA1 1DP | UK | (171) 555-7788 | (171) 555-6750 | NULL | NULL |
+------------+------------------------------------+----------------+----------------------+--------------------------------+--------------+--------+------------+---------+----------------+----------------+-------+----------------+
4 rows in set (0.00 sec)
mysql> select companyname from customers where
-> customerid in (select customerid from orders);
+------------------------------------+
| companyname |
+------------------------------------+
| Alfreds Futterkiste |
| Ana Trujillo Emparedados y helados |
| Antonio Moreno Taquería |
| Around the Horn |
| Berglunds snabbk├Âp |
| Blauer See Delikatessen |
| Blondel père et fils |
| B├│lido Comidas preparadas |
| Bon app' |
| Bottom-Dollar Markets |
| B's Beverages |
| Cactus Comidas para llevar |
| Centro comercial Moctezuma |
| Chop-suey Chinese |
| Com├®rcio Mineiro |
| Consolidated Holdings |
| Drachenblut Delikatessen |
| Du monde entier |
| Eastern Connection |
| Ernst Handel |
| Familia Arquibaldo |
| Folies gourmandes |
| Folk och fä HB |
| Frankenversand |
| France restauration |
| Franchi S.p.A. |
| Furia Bacalhau e Frutos do Mar |
| Galería del gastrónomo |
| Godos Cocina Típica |
| Gourmet Lanchonetes |
| Great Lakes Food Market |
| GROSELLA-Restaurante |
| Hanari Carnes |
| HILARIÓN-Abastos |
| Hungry Coyote Import Store |
| Hungry Owl All-Night Grocers |
| Island Trading |
| K├Âniglich Essen |
| La corne d'abondance |
| La maison d'Asie |
| Laughing Bacchus Wine Cellars |
| Lazy K Kountry Store |
| Lehmanns Marktstand |
| Let's Stop N Shop |
| LILA-Supermercado |
| LINO-Delicateses |
| Lonesome Pine Restaurant |
| Magazzini Alimentari Riuniti |
| Maison Dewey |
| Mère Paillarde |
| Morgenstern Gesundkost |
| North/South |
| Oc├®ano Atl├íntico Ltda. |
| Old World Delicatessen |
| Ottilies Käseladen |
| Pericles Comidas clásicas |
| Piccolo und mehr |
| Princesa Isabel Vinhos |
| Que Delícia |
| Queen Cozinha |
| QUICK-Stop |
| Rancho grande |
| Rattlesnake Canyon Grocery |
| Reggiani Caseifici |
| Ricardo Adocicados |
| Richter Supermarkt |
| Romero y tomillo |
| Sant├® Gourmet |
| Save-a-lot Markets |
| Seven Seas Imports |
| Simons bistro |
| Sp├®cialit├®s du monde |
| Split Rail Beer & Ale |
| Supr├¬mes d├®lices |
| The Big Cheese |
| The Cracker Box |
| Toms Spezialitäten |
| Tortuga Restaurante |
| Tradição Hipermercados |
| Trail's Head Gourmet Provisioners |
| Vaffeljernet |
| Victuailles en stock |
| Vins et alcools Chevalier |
| Die Wandernde Kuh |
| Wartian Herkku |
| Wellington Importadora |
| White Clover Markets |
| Wilman Kala |
| Wolski Zajazd |
+------------------------------------+
89 rows in set (0.01 sec)
mysql> select companyname from customers;
+--------------------------------------+
| companyname |
+--------------------------------------+
| Alfreds Futterkiste |
| Ana Trujillo Emparedados y helados |
| Antonio Moreno Taquería |
| Around the Horn |
| B's Beverages |
| Berglunds snabbk├Âp |
| Blauer See Delikatessen |
| Blondel père et fils |
| Bon app' |
| Bottom-Dollar Markets |
| B├│lido Comidas preparadas |
| Cactus Comidas para llevar |
| Centro comercial Moctezuma |
| Chop-suey Chinese |
| Com├®rcio Mineiro |
| Consolidated Holdings |
| Die Wandernde Kuh |
| Drachenblut Delikatessen |
| Du monde entier |
| Eastern Connection |
| Ernst Handel |
| Familia Arquibaldo |
| FISSA Fabrica Inter. Salchichas S.A. |
| Folies gourmandes |
| Folk och fä HB |
| France restauration |
| Franchi S.p.A. |
| Frankenversand |
| Furia Bacalhau e Frutos do Mar |
| Galería del gastrónomo |
| Godos Cocina Típica |
| Gourmet Lanchonetes |
| Great Lakes Food Market |
| GROSELLA-Restaurante |
| Hanari Carnes |
| HILARIÓN-Abastos |
| Hungry Coyote Import Store |
| Hungry Owl All-Night Grocers |
| Island Trading |
| K├Âniglich Essen |
| La corne d'abondance |
| La maison d'Asie |
| Laughing Bacchus Wine Cellars |
| Lazy K Kountry Store |
| Lehmanns Marktstand |
| Let's Stop N Shop |
| LILA-Supermercado |
| LINO-Delicateses |
| Lonesome Pine Restaurant |
| Magazzini Alimentari Riuniti |
| Maison Dewey |
| Morgenstern Gesundkost |
| Mère Paillarde |
| North/South |
| Oc├®ano Atl├íntico Ltda. |
| Old World Delicatessen |
| Ottilies Käseladen |
| Paris sp├®cialit├®s |
| Pericles Comidas clásicas |
| Piccolo und mehr |
| Princesa Isabel Vinhos |
| Que Delícia |
| Queen Cozinha |
| QUICK-Stop |
| Rancho grande |
| Rattlesnake Canyon Grocery |
| Reggiani Caseifici |
| Ricardo Adocicados |
| Richter Supermarkt |
| Romero y tomillo |
| Sant├® Gourmet |
| Save-a-lot Markets |
| Seven Seas Imports |
| Simons bistro |
| Split Rail Beer & Ale |
| Sp├®cialit├®s du monde |
| Supr├¬mes d├®lices |
| The Big Cheese |
| The Cracker Box |
| Toms Spezialitäten |
| Tortuga Restaurante |
| Tradição Hipermercados |
| Trail's Head Gourmet Provisioners |
| Vaffeljernet |
| Victuailles en stock |
| Vins et alcools Chevalier |
| Wartian Herkku |
| Wellington Importadora |
| White Clover Markets |
| Wilman Kala |
| Wolski Zajazd |
+--------------------------------------+
91 rows in set (0.00 sec)
mysql>
No comments:
Post a Comment
Note: only a member of this blog may post a comment.