Window LEAD SQL function

1. Usage of LEAD to show year wise order details

SQL Server Query 1

            
 WITH CustomerMonthlyOrders AS (  

     SELECT  

         c.CustomerID,  

         c.CompanyName,  

         YEAR(o.OrderDate) AS OrderYear,  

         MONTH(o.OrderDate) AS OrderMonth,  

         COUNT(o.OrderID) AS TotalOrders  

     FROM  

         Customers c  

     LEFT JOIN  

         Orders o ON c.CustomerID = o.CustomerID  

     GROUP BY  

         c.CustomerID,  

         c.CompanyName,  

         YEAR(o.OrderDate),  

         MONTH(o.OrderDate)  

 ),  

 LeadedCustomerOrders AS (  

     SELECT  

         CustomerID,  

         CompanyName,  

         OrderYear,  

         OrderMonth,  

         TotalOrders,  

         LEAD(TotalOrders, 1, 0) OVER (PARTITION BY CustomerID ORDER BY OrderYear, OrderMonth) AS NextMonthOrders,  

         LEAD(TotalOrders, 2) OVER (PARTITION BY CustomerID ORDER BY OrderYear, OrderMonth) AS TwoMonthsLaterOrders  

     FROM  

         CustomerMonthlyOrders  

 )  

 SELECT  

     CustomerID,  

     CompanyName,  

     OrderYear,  

     OrderMonth,  

     TotalOrders,  

     NextMonthOrders,  

     (NextMonthOrders - TotalOrders) AS NextMonthDifference,  

     TwoMonthsLaterOrders,  

     (TwoMonthsLaterOrders - TotalOrders) AS TwoMonthsLaterDifference  

 FROM  

     LeadedCustomerOrders  

 ORDER BY  

     CustomerID,  

     OrderYear,  

     OrderMonth;

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .WithCTETable(new Table("CustomerMonthlyOrders"), new SqlQueryBuilder()  

         .Select()  

         .Columns("c.CustomerID", "c.CompanyName")  

         .Column(new YEAR(new Column("o.OrderDate")), "OrderYear")  

         .Column(new YEAR(new Column("o.OrderDate")), "OrderMonth")  

         .Column(new YEAR(new Column("o.OrderDate")), "TotalOrders")  

         .From("Customers", "c")  

         .Join(new List<IJoin>()  

         {  

             new LEFTJOIN().TableName(new Table("Orders", "o"))  

                 .On(new Column("c.CustomerID").Equale(new Column("o.CustomerID")))  

         })  

         .GroupBy(new GroupBy(  

             new Column("c.CustomerID"),  

             new Column("c.CompanyName"),  

             new YEAR(new Column("o.OrderDate")),  

             new MONTH(new Column("o.OrderDate"))  

         ))  

     )  

     .WithCTETable(new Table("LeadedCustomerOrders"), new SqlQueryBuilder()  

         .Select()  

         .Columns("CustomerID", "CompanyName", "OrderYear", "OrderMonth", "TotalOrders")  

         .Column(new LEAD(new Column("TotalOrders"), 1, 0)  

             .PARTITION_BY(new Column("CustomerID"))  

             .ORDER_BY(new OrderBy().SetColumnAscending("OrderYear").SetColumnAscending("OrderMonth")), "NextMonthOrders")  

         .Column(new LEAD(new Column("TotalOrders"), 2)  

             .PARTITION_BY(new Column("CustomerID"))  

             .ORDER_BY(new OrderBy().SetColumnAscending("OrderYear").SetColumnAscending("OrderMonth")), "TwoMonthsLaterOrders")  

         .From("CustomerMonthlyOrders")  

     )  

     .Select()  

     .Columns("CustomerID", "CompanyName", "OrderYear", "OrderMonth", "TotalOrders", "NextMonthOrders")  

     .Column(new ColumnArithmatic().StartBracket().Column("NextMonthOrders").SUBTRACT().Column("TotalOrders").EndBracket(), "NextMonthDifference")  

     .Columns("TwoMonthsLaterOrders")  

     .Column(new ColumnArithmatic().StartBracket().Column("TwoMonthsLaterOrders").SUBTRACT().Column("TotalOrders").EndBracket(), "TwoMonthsLaterDifference")  

     .From("LeadedCustomerOrders")  

     .OrderBy(new OrderBy().Set(new Column("CustomerID"))  

         .SetColumnAscending("OrderYear")  

         .SetColumnAscending("OrderMonth"))  

     .Build();

Query build by SqlQueryBuilder 1

            
WITH CustomerMonthlyOrders
AS (SELECT c.CustomerID,
           c.CompanyName,
           YEAR(o.OrderDate) AS OrderYear,
           YEAR(o.OrderDate) AS OrderMonth,
           YEAR(o.OrderDate) AS TotalOrders
    FROM Customers AS c
         LEFT OUTER JOIN
         Orders AS o
         ON c.CustomerID = o.CustomerID
    GROUP BY c.CustomerID, c.CompanyName, YEAR(o.OrderDate), MONTH(o.OrderDate)),
 LeadedCustomerOrders
AS (SELECT CustomerID,
           CompanyName,
           OrderYear,
           OrderMonth,
           TotalOrders,
           LEAD(TotalOrders, 1, 0) OVER (PARTITION BY CustomerID ORDER BY OrderYear ASC, OrderMonth ASC) AS NextMonthOrders,
           LEAD(TotalOrders, 2) OVER (PARTITION BY CustomerID ORDER BY OrderYear ASC, OrderMonth ASC) AS TwoMonthsLaterOrders
    FROM CustomerMonthlyOrders)
SELECT CustomerID,
       CompanyName,
       OrderYear,
       OrderMonth,
       TotalOrders,
       NextMonthOrders,
       (NextMonthOrders - TotalOrders) AS NextMonthDifference,
       TwoMonthsLaterOrders,
       (TwoMonthsLaterOrders - TotalOrders) AS TwoMonthsLaterDifference
FROM LeadedCustomerOrders
ORDER BY CustomerID ASC, OrderYear ASC, OrderMonth ASC;

Parameters (If used)

Name Value

Query Results 1:

  CustomerID CompanyName OrderYear OrderMonth TotalOrders NextMonthOrders NextMonthDifference TwoMonthsLaterOrders TwoMonthsLaterDifference
1 ALFKI Alfreds Futterkiste 1997 1997 1997 1997 0 1998 1
2 ALFKI Alfreds Futterkiste 1997 1997 1997 1998 1 1998 1
3 ALFKI Alfreds Futterkiste 1998 1998 1998 1998 0 1998 0
4 ALFKI Alfreds Futterkiste 1998 1998 1998 1998 0
5 ALFKI Alfreds Futterkiste 1998 1998 1998 0 -1998
6 ANATR Ana Trujillo Emparedados y helados 1996 1996 1996 1997 1 1997 1
7 ANATR Ana Trujillo Emparedados y helados 1997 1997 1997 1997 0 1998 1
8 ANATR Ana Trujillo Emparedados y helados 1997 1997 1997 1998 1
9 ANATR Ana Trujillo Emparedados y helados 1998 1998 1998 0 -1998
10 ANTON Antonio Moreno Taquería 1996 1996 1996 1997 1 1997 1
11 ANTON Antonio Moreno Taquería 1997 1997 1997 1997 0 1997 0
12 ANTON Antonio Moreno Taquería 1997 1997 1997 1997 0 1997 0
13 ANTON Antonio Moreno Taquería 1997 1997 1997 1997 0 1998 1
14 ANTON Antonio Moreno Taquería 1997 1997 1997 1998 1
15 ANTON Antonio Moreno Taquería 1998 1998 1998 0 -1998
16 AROUT Around the Horn 1996 1996 1996 1996 0 1997 1
17 AROUT Around the Horn 1996 1996 1996 1997 1 1997 1
18 AROUT Around the Horn 1997 1997 1997 1997 0 1997 0
19 AROUT Around the Horn 1997 1997 1997 1997 0 1997 0
20 AROUT Around the Horn 1997 1997 1997 1997 0 1997 0
21 AROUT Around the Horn 1997 1997 1997 1997 0 1998 1
22 AROUT Around the Horn 1997 1997 1997 1998 1 1998 1
23 AROUT Around the Horn 1998 1998 1998 1998 0 1998 0
24 AROUT Around the Horn 1998 1998 1998 1998 0
25 AROUT Around the Horn 1998 1998 1998 0 -1998
26 BERGS Berglunds snabbköp 1996 1996 1996 1996 0 1997 1
27 BERGS Berglunds snabbköp 1996 1996 1996 1997 1 1997 1
28 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
29 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
30 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
31 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
32 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
33 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1997 0
34 BERGS Berglunds snabbköp 1997 1997 1997 1997 0 1998 1
35 BERGS Berglunds snabbköp 1997 1997 1997 1998 1 1998 1
36 BERGS Berglunds snabbköp 1998 1998 1998 1998 0 1998 0
37 BERGS Berglunds snabbköp 1998 1998 1998 1998 0
38 BERGS Berglunds snabbköp 1998 1998 1998 0 -1998
39 BLAUS Blauer See Delikatessen 1997 1997 1997 1997 0 1997 0
40 BLAUS Blauer See Delikatessen 1997 1997 1997 1997 0 1998 1
41 BLAUS Blauer See Delikatessen 1997 1997 1997 1998 1 1998 1
42 BLAUS Blauer See Delikatessen 1998 1998 1998 1998 0 1998 0
43 BLAUS Blauer See Delikatessen 1998 1998 1998 1998 0
44 BLAUS Blauer See Delikatessen 1998 1998 1998 0 -1998
45 BLONP Blondesddsl père et fils 1996 1996 1996 1996 0 1996 0
46 BLONP Blondesddsl père et fils 1996 1996 1996 1996 0 1997 1
47 BLONP Blondesddsl père et fils 1996 1996 1996 1997 1 1997 1
48 BLONP Blondesddsl père et fils 1997 1997 1997 1997 0 1997 0
49 BLONP Blondesddsl père et fils 1997 1997 1997 1997 0 1997 0
50 BLONP Blondesddsl père et fils 1997 1997 1997 1997 0 1998 1
51 BLONP Blondesddsl père et fils 1997 1997 1997 1998 1
52 BLONP Blondesddsl père et fils 1998 1998 1998 0 -1998
53 BOLID Bólido Comidas preparadas 1996 1996 1996 1997 1 1998 2
54 BOLID Bólido Comidas preparadas 1997 1997 1997 1998 1
55 BOLID Bólido Comidas preparadas 1998 1998 1998 0 -1998
56 BONAP Bon app' 1996 1996 1996 1996 0 1997 1
57 BONAP Bon app' 1996 1996 1996 1997 1 1997 1
58 BONAP Bon app' 1997 1997 1997 1997 0 1997 0
59 BONAP Bon app' 1997 1997 1997 1997 0 1997 0
60 BONAP Bon app' 1997 1997 1997 1997 0 1997 0
61 BONAP Bon app' 1997 1997 1997 1997 0 1997 0
62 BONAP Bon app' 1997 1997 1997 1997 0 1998 1
63 BONAP Bon app' 1997 1997 1997 1998 1 1998 1
64 BONAP Bon app' 1998 1998 1998 1998 0 1998 0
65 BONAP Bon app' 1998 1998 1998 1998 0 1998 0
66 BONAP Bon app' 1998 1998 1998 1998 0
67 BONAP Bon app' 1998 1998 1998 0 -1998
68 BOTTM Bottom-Dollar Markets 1996 1996 1996 1997 1 1997 1
69 BOTTM Bottom-Dollar Markets 1997 1997 1997 1997 0 1997 0
70 BOTTM Bottom-Dollar Markets 1997 1997 1997 1997 0 1998 1
71 BOTTM Bottom-Dollar Markets 1997 1997 1997 1998 1 1998 1
72 BOTTM Bottom-Dollar Markets 1998 1998 1998 1998 0
73 BOTTM Bottom-Dollar Markets 1998 1998 1998 0 -1998
74 BSBEV B's Beverages 1996 1996 1996 1997 1 1997 1
75 BSBEV B's Beverages 1997 1997 1997 1997 0 1997 0
76 BSBEV B's Beverages 1997 1997 1997 1997 0 1997 0
77 BSBEV B's Beverages 1997 1997 1997 1997 0 1998 1
78 BSBEV B's Beverages 1997 1997 1997 1998 1 1998 1
79 BSBEV B's Beverages 1998 1998 1998 1998 0
80 BSBEV B's Beverages 1998 1998 1998 0 -1998
81 CACTU Cactus Comidas para llevar 1997 1997 1997 1997 0 1998 1
82 CACTU Cactus Comidas para llevar 1997 1997 1997 1998 1 1998 1
83 CACTU Cactus Comidas para llevar 1998 1998 1998 1998 0 1998 0
84 CACTU Cactus Comidas para llevar 1998 1998 1998 1998 0 1998 0
85 CACTU Cactus Comidas para llevar 1998 1998 1998 1998 0
86 CACTU Cactus Comidas para llevar 1998 1998 1998 0 -1998
87 CENTC Centro comercial Moctezuma 1996 1996 1996 0 -1996
88 CHOPS Chop-suey Chinese 1996 1996 1996 1996 0 1997 1
89 CHOPS Chop-suey Chinese 1996 1996 1996 1997 1 1997 1
90 CHOPS Chop-suey Chinese 1997 1997 1997 1997 0 1998 1
91 CHOPS Chop-suey Chinese 1997 1997 1997 1998 1 1998 1
92 CHOPS Chop-suey Chinese 1998 1998 1998 1998 0
93 CHOPS Chop-suey Chinese 1998 1998 1998 0 -1998
94 COMMI Comércio Mineiro 1996 1996 1996 1997 1 1997 1
95 COMMI Comércio Mineiro 1997 1997 1997 1997 0 1998 1
96 COMMI Comércio Mineiro 1997 1997 1997 1998 1 1998 1
97 COMMI Comércio Mineiro 1998 1998 1998 1998 0
98 COMMI Comércio Mineiro 1998 1998 1998 0 -1998
99 CONSH Consolidated Holdings 1997 1997 1997 1997 0 1998 1
100 CONSH Consolidated Holdings 1997 1997 1997 1998 1
101 CONSH Consolidated Holdings 1998 1998 1998 0 -1998
102 DRACD Drachenblut Delikatessen 1996 1996 1996 1996 0 1997 1
103 DRACD Drachenblut Delikatessen 1996 1996 1996 1997 1 1998 2
104 DRACD Drachenblut Delikatessen 1997 1997 1997 1998 1 1998 1
105 DRACD Drachenblut Delikatessen 1998 1998 1998 1998 0 1998 0
106 DRACD Drachenblut Delikatessen 1998 1998 1998 1998 0
107 DRACD Drachenblut Delikatessen 1998 1998 1998 0 -1998
108 DUMON Du monde entier 1996 1996 1996 1997 1 1997 1
109 DUMON Du monde entier 1997 1997 1997 1997 0 1998 1
110 DUMON Du monde entier 1997 1997 1997 1998 1
111 DUMON Du monde entier 1998 1998 1998 0 -1998
112 EASTC Eastern Connection 1996 1996 1996 1997 1 1997 1
113 EASTC Eastern Connection 1997 1997 1997 1997 0 1997 0
114 EASTC Eastern Connection 1997 1997 1997 1997 0 1998 1
115 EASTC Eastern Connection 1997 1997 1997 1998 1 1998 1
116 EASTC Eastern Connection 1998 1998 1998 1998 0
117 EASTC Eastern Connection 1998 1998 1998 0 -1998
118 ERNSH Ernst Handel 1996 1996 1996 1996 0 1996 0
119 ERNSH Ernst Handel 1996 1996 1996 1996 0 1997 1
120 ERNSH Ernst Handel 1996 1996 1996 1997 1 1997 1
121 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
122 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
123 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
124 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
125 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
126 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
127 ERNSH Ernst Handel 1997 1997 1997 1997 0 1997 0
128 ERNSH Ernst Handel 1997 1997 1997 1997 0 1998 1
129 ERNSH Ernst Handel 1997 1997 1997 1998 1 1998 1
130 ERNSH Ernst Handel 1998 1998 1998 1998 0 1998 0
131 ERNSH Ernst Handel 1998 1998 1998 1998 0 1998 0
132 ERNSH Ernst Handel 1998 1998 1998 1998 0 1998 0
133 ERNSH Ernst Handel 1998 1998 1998 1998 0
134 ERNSH Ernst Handel 1998 1998 1998 0 -1998
135 FAMIA Familia Arquibaldo 1996 1996 1996 1996 0 1997 1
136 FAMIA Familia Arquibaldo 1996 1996 1996 1997 1 1997 1
137 FAMIA Familia Arquibaldo 1997 1997 1997 1997 0 1997 0
138 FAMIA Familia Arquibaldo 1997 1997 1997 1997 0 1997 0
139 FAMIA Familia Arquibaldo 1997 1997 1997 1997 0 1997 0
140 FAMIA Familia Arquibaldo 1997 1997 1997 1997 0
141 FAMIA Familia Arquibaldo 1997 1997 1997 0 -1997
142 FISSA FISSA Fabrica Inter. Salchichas S.A. 0 0 0 0 0
143 FOLIG Folies gourmandes 1997 1997 1997 1997 0 1997 0
144 FOLIG Folies gourmandes 1997 1997 1997 1997 0 1997 0
145 FOLIG Folies gourmandes 1997 1997 1997 1997 0
146 FOLIG Folies gourmandes 1997 1997 1997 0 -1997
147 FOLKO Folk och fä HB 1996 1996 1996 1996 0 1996 0
148 FOLKO Folk och fä HB 1996 1996 1996 1996 0 1997 1
149 FOLKO Folk och fä HB 1996 1996 1996 1997 1 1997 1
150 FOLKO Folk och fä HB 1997 1997 1997 1997 0 1997 0
151 FOLKO Folk och fä HB 1997 1997 1997 1997 0 1997 0
152 FOLKO Folk och fä HB 1997 1997 1997 1997 0 1997 0
153 FOLKO Folk och fä HB 1997 1997 1997 1997 0 1998 1
154 FOLKO Folk och fä HB 1997 1997 1997 1998 1 1998 1
155 FOLKO Folk och fä HB 1998 1998 1998 1998 0 1998 0
156 FOLKO Folk och fä HB 1998 1998 1998 1998 0 1998 0
157 FOLKO Folk och fä HB 1998 1998 1998 1998 0
158 FOLKO Folk och fä HB 1998 1998 1998 0 -1998
159 FRANK Frankenversand 1996 1996 1996 1996 0 1996 0
160 FRANK Frankenversand 1996 1996 1996 1996 0 1997 1
161 FRANK Frankenversand 1996 1996 1996 1997 1 1997 1
162 FRANK Frankenversand 1997 1997 1997 1997 0 1997 0
163 FRANK Frankenversand 1997 1997 1997 1997 0 1997 0
164 FRANK Frankenversand 1997 1997 1997 1997 0 1997 0
165 FRANK Frankenversand 1997 1997 1997 1997 0 1997 0
166 FRANK Frankenversand 1997 1997 1997 1997 0 1998 1
167 FRANK Frankenversand 1997 1997 1997 1998 1 1998 1
168 FRANK Frankenversand 1998 1998 1998 1998 0 1998 0
169 FRANK Frankenversand 1998 1998 1998 1998 0
170 FRANK Frankenversand 1998 1998 1998 0 -1998
171 FRANR France restauration 1997 1997 1997 1998 1 1998 1
172 FRANR France restauration 1998 1998 1998 1998 0
173 FRANR France restauration 1998 1998 1998 0 -1998
174 FRANS Franchi S.p.A. 1997 1997 1997 1997 0 1997 0
175 FRANS Franchi S.p.A. 1997 1997 1997 1997 0 1997 0
176 FRANS Franchi S.p.A. 1997 1997 1997 1997 0 1998 1
177 FRANS Franchi S.p.A. 1997 1997 1997 1998 1
178 FRANS Franchi S.p.A. 1998 1998 1998 0 -1998
179 FURIB Furia Bacalhau e Frutos do Mar 1996 1996 1996 1996 0 1997 1
180 FURIB Furia Bacalhau e Frutos do Mar 1996 1996 1996 1997 1 1997 1
181 FURIB Furia Bacalhau e Frutos do Mar 1997 1997 1997 1997 0 1997 0
182 FURIB Furia Bacalhau e Frutos do Mar 1997 1997 1997 1997 0 1997 0
183 FURIB Furia Bacalhau e Frutos do Mar 1997 1997 1997 1997 0 1998 1
184 FURIB Furia Bacalhau e Frutos do Mar 1997 1997 1997 1998 1
185 FURIB Furia Bacalhau e Frutos do Mar 1998 1998 1998 0 -1998
186 GALED Galería del gastrónomo 1996 1996 1996 1997 1 1997 1
187 GALED Galería del gastrónomo 1997 1997 1997 1997 0 1998 1
188 GALED Galería del gastrónomo 1997 1997 1997 1998 1 1998 1
189 GALED Galería del gastrónomo 1998 1998 1998 1998 0
190 GALED Galería del gastrónomo 1998 1998 1998 0 -1998
191 GODOS Godos Cocina Típica 1996 1996 1996 1997 1 1997 1
192 GODOS Godos Cocina Típica 1997 1997 1997 1997 0 1998 1
193 GODOS Godos Cocina Típica 1997 1997 1997 1998 1 1998 1
194 GODOS Godos Cocina Típica 1998 1998 1998 1998 0 1998 0
195 GODOS Godos Cocina Típica 1998 1998 1998 1998 0
196 GODOS Godos Cocina Típica 1998 1998 1998 0 -1998
197 GOURL Gourmet Lanchonetes 1997 1997 1997 1997 0 1997 0
198 GOURL Gourmet Lanchonetes 1997 1997 1997 1997 0 1997 0
199 GOURL Gourmet Lanchonetes 1997 1997 1997 1997 0 1997 0
200 GOURL Gourmet Lanchonetes 1997 1997 1997 1997 0 1998 1
201 GOURL Gourmet Lanchonetes 1997 1997 1997 1998 1 1998 1
202 GOURL Gourmet Lanchonetes 1998 1998 1998 1998 0
203 GOURL Gourmet Lanchonetes 1998 1998 1998 0 -1998
204 GREAL Great Lakes Food Market 1997 1997 1997 1997 0 1997 0
205 GREAL Great Lakes Food Market 1997 1997 1997 1997 0 1998 1
206 GREAL Great Lakes Food Market 1997 1997 1997 1998 1 1998 1
207 GREAL Great Lakes Food Market 1998 1998 1998 1998 0 1998 0
208 GREAL Great Lakes Food Market 1998 1998 1998 1998 0
209 GREAL Great Lakes Food Market 1998 1998 1998 0 -1998
210 GROSR GROSELLA-Restaurante 1996 1996 1996 1997 1
211 GROSR GROSELLA-Restaurante 1997 1997 1997 0 -1997
212 HANAR Hanari Carnes 1996 1996 1996 1997 1 1997 1
213 HANAR Hanari Carnes 1997 1997 1997 1997 0 1997 0
214 HANAR Hanari Carnes 1997 1997 1997 1997 0 1997 0
215 HANAR Hanari Carnes 1997 1997 1997 1997 0 1998 1
216 HANAR Hanari Carnes 1997 1997 1997 1998 1 1998 1
217 HANAR Hanari Carnes 1998 1998 1998 1998 0 1998 0
218 HANAR Hanari Carnes 1998 1998 1998 1998 0
219 HANAR Hanari Carnes 1998 1998 1998 0 -1998
220 HILAA HILARION-Abastos 1996 1996 1996 1996 0 1997 1
221 HILAA HILARION-Abastos 1996 1996 1996 1997 1 1997 1
222 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1997 0
223 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1997 0
224 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1997 0
225 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1997 0
226 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1997 0
227 HILAA HILARION-Abastos 1997 1997 1997 1997 0 1998 1
228 HILAA HILARION-Abastos 1997 1997 1997 1998 1 1998 1
229 HILAA HILARION-Abastos 1998 1998 1998 1998 0 1998 0
230 HILAA HILARION-Abastos 1998 1998 1998 1998 0
231 HILAA HILARION-Abastos 1998 1998 1998 0 -1998
232 HUNGC Hungry Coyote Import Store 1996 1996 1996 1997 1 1997 1
233 HUNGC Hungry Coyote Import Store 1997 1997 1997 1997 0 1997 0
234 HUNGC Hungry Coyote Import Store 1997 1997 1997 1997 0
235 HUNGC Hungry Coyote Import Store 1997 1997 1997 0 -1997
236 HUNGO Hungry Owl All-Night Grocers 1996 1996 1996 1996 0 1996 0
237 HUNGO Hungry Owl All-Night Grocers 1996 1996 1996 1996 0 1997 1
238 HUNGO Hungry Owl All-Night Grocers 1996 1996 1996 1997 1 1997 1
239 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1997 0
240 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1997 0
241 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1997 0
242 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1997 0
243 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1997 0
244 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1997 0 1998 1
245 HUNGO Hungry Owl All-Night Grocers 1997 1997 1997 1998 1 1998 1
246 HUNGO Hungry Owl All-Night Grocers 1998 1998 1998 1998 0 1998 0
247 HUNGO Hungry Owl All-Night Grocers 1998 1998 1998 1998 0
248 HUNGO Hungry Owl All-Night Grocers 1998 1998 1998 0 -1998
249 ISLAT Island Trading 1996 1996 1996 1996 0 1997 1
250 ISLAT Island Trading 1996 1996 1996 1997 1 1997 1
251 ISLAT Island Trading 1997 1997 1997 1997 0 1997 0
252 ISLAT Island Trading 1997 1997 1997 1997 0 1997 0
253 ISLAT Island Trading 1997 1997 1997 1997 0 1997 0
254 ISLAT Island Trading 1997 1997 1997 1997 0 1998 1
255 ISLAT Island Trading 1997 1997 1997 1998 1 1998 1
256 ISLAT Island Trading 1998 1998 1998 1998 0
257 ISLAT Island Trading 1998 1998 1998 0 -1998
258 KOENE Königlich Essen 1996 1996 1996 1997 1 1997 1
259 KOENE Königlich Essen 1997 1997 1997 1997 0 1997 0
260 KOENE Königlich Essen 1997 1997 1997 1997 0 1997 0
261 KOENE Königlich Essen 1997 1997 1997 1997 0 1997 0
262 KOENE Königlich Essen 1997 1997 1997 1997 0 1997 0
263 KOENE Königlich Essen 1997 1997 1997 1997 0 1997 0
264 KOENE Königlich Essen 1997 1997 1997 1997 0 1998 1
265 KOENE Königlich Essen 1997 1997 1997 1998 1 1998 1
266 KOENE Königlich Essen 1998 1998 1998 1998 0 1998 0
267 KOENE Königlich Essen 1998 1998 1998 1998 0
268 KOENE Königlich Essen 1998 1998 1998 0 -1998
269 LACOR La corne d'abondance 1998 1998 1998 1998 0
270 LACOR La corne d'abondance 1998 1998 1998 0 -1998
271 LAMAI La maison d'Asie 1996 1996 1996 1996 0 1997 1
272 LAMAI La maison d'Asie 1996 1996 1996 1997 1 1997 1
273 LAMAI La maison d'Asie 1997 1997 1997 1997 0 1997 0
274 LAMAI La maison d'Asie 1997 1997 1997 1997 0 1997 0
275 LAMAI La maison d'Asie 1997 1997 1997 1997 0 1997 0
276 LAMAI La maison d'Asie 1997 1997 1997 1997 0 1997 0
277 LAMAI La maison d'Asie 1997 1997 1997 1997 0 1998 1
278 LAMAI La maison d'Asie 1997 1997 1997 1998 1 1998 1
279 LAMAI La maison d'Asie 1998 1998 1998 1998 0 1998 0
280 LAMAI La maison d'Asie 1998 1998 1998 1998 0
281 LAMAI La maison d'Asie 1998 1998 1998 0 -1998
282 LAUGB Laughing Bacchus Wine Cellars 1997 1997 1997 1997 0 1998 1
283 LAUGB Laughing Bacchus Wine Cellars 1997 1997 1997 1998 1
284 LAUGB Laughing Bacchus Wine Cellars 1998 1998 1998 0 -1998
285 LAZYK Lazy K Kountry Store 1997 1997 1997 1997 0
286 LAZYK Lazy K Kountry Store 1997 1997 1997 0 -1997
287 LEHMS Lehmanns Marktstand 1996 1996 1996 1996 0 1997 1
288 LEHMS Lehmanns Marktstand 1996 1996 1996 1997 1 1997 1
289 LEHMS Lehmanns Marktstand 1997 1997 1997 1997 0 1997 0
290 LEHMS Lehmanns Marktstand 1997 1997 1997 1997 0 1997 0
291 LEHMS Lehmanns Marktstand 1997 1997 1997 1997 0 1997 0
292 LEHMS Lehmanns Marktstand 1997 1997 1997 1997 0 1998 1
293 LEHMS Lehmanns Marktstand 1997 1997 1997 1998 1 1998 1
294 LEHMS Lehmanns Marktstand 1998 1998 1998 1998 0 1998 0
295 LEHMS Lehmanns Marktstand 1998 1998 1998 1998 0 1998 0
296 LEHMS Lehmanns Marktstand 1998 1998 1998 1998 0
297 LEHMS Lehmanns Marktstand 1998 1998 1998 0 -1998
298 LETSS Let's Stop N Shop 1997 1997 1997 1997 0 1997 0
299 LETSS Let's Stop N Shop 1997 1997 1997 1997 0 1998 1
300 LETSS Let's Stop N Shop 1997 1997 1997 1998 1
301 LETSS Let's Stop N Shop 1998 1998 1998 0 -1998
302 LILAS LILA-Supermercado 1996 1996 1996 1996 0 1996 0
303 LILAS LILA-Supermercado 1996 1996 1996 1996 0 1996 0
304 LILAS LILA-Supermercado 1996 1996 1996 1996 0 1996 0
305 LILAS LILA-Supermercado 1996 1996 1996 1996 0 1997 1
306 LILAS LILA-Supermercado 1996 1996 1996 1997 1 1997 1
307 LILAS LILA-Supermercado 1997 1997 1997 1997 0 1997 0
308 LILAS LILA-Supermercado 1997 1997 1997 1997 0 1997 0
309 LILAS LILA-Supermercado 1997 1997 1997 1997 0 1998 1
310 LILAS LILA-Supermercado 1997 1997 1997 1998 1 1998 1
311 LILAS LILA-Supermercado 1998 1998 1998 1998 0 1998 0
312 LILAS LILA-Supermercado 1998 1998 1998 1998 0 1998 0
313 LILAS LILA-Supermercado 1998 1998 1998 1998 0
314 LILAS LILA-Supermercado 1998 1998 1998 0 -1998
315 LINOD LINO-Delicateses 1997 1997 1997 1997 0 1997 0
316 LINOD LINO-Delicateses 1997 1997 1997 1997 0 1997 0
317 LINOD LINO-Delicateses 1997 1997 1997 1997 0 1997 0
318 LINOD LINO-Delicateses 1997 1997 1997 1997 0 1998 1
319 LINOD LINO-Delicateses 1997 1997 1997 1998 1 1998 1
320 LINOD LINO-Delicateses 1998 1998 1998 1998 0 1998 0
321 LINOD LINO-Delicateses 1998 1998 1998 1998 0
322 LINOD LINO-Delicateses 1998 1998 1998 0 -1998
323 LONEP Lonesome Pine Restaurant 1996 1996 1996 1997 1 1997 1
324 LONEP Lonesome Pine Restaurant 1997 1997 1997 1997 0 1998 1
325 LONEP Lonesome Pine Restaurant 1997 1997 1997 1998 1 1998 1
326 LONEP Lonesome Pine Restaurant 1998 1998 1998 1998 0
327 LONEP Lonesome Pine Restaurant 1998 1998 1998 0 -1998
328 MAGAA Magazzini Alimentari Riuniti 1996 1996 1996 1996 0 1997 1
329 MAGAA Magazzini Alimentari Riuniti 1996 1996 1996 1997 1 1997 1
330 MAGAA Magazzini Alimentari Riuniti 1997 1997 1997 1997 0 1997 0
331 MAGAA Magazzini Alimentari Riuniti 1997 1997 1997 1997 0 1997 0
332 MAGAA Magazzini Alimentari Riuniti 1997 1997 1997 1997 0 1997 0
333 MAGAA Magazzini Alimentari Riuniti 1997 1997 1997 1997 0 1998 1
334 MAGAA Magazzini Alimentari Riuniti 1997 1997 1997 1998 1 1998 1
335 MAGAA Magazzini Alimentari Riuniti 1998 1998 1998 1998 0
336 MAGAA Magazzini Alimentari Riuniti 1998 1998 1998 0 -1998
337 MAISD Maison Dewey 1997 1997 1997 1997 0 1997 0
338 MAISD Maison Dewey 1997 1997 1997 1997 0 1998 1
339 MAISD Maison Dewey 1997 1997 1997 1998 1 1998 1
340 MAISD Maison Dewey 1998 1998 1998 1998 0 1998 0
341 MAISD Maison Dewey 1998 1998 1998 1998 0
342 MAISD Maison Dewey 1998 1998 1998 0 -1998
343 MEREP Mère Paillarde 1996 1996 1996 1996 0 1997 1
344 MEREP Mère Paillarde 1996 1996 1996 1997 1 1997 1
345 MEREP Mère Paillarde 1997 1997 1997 1997 0 1997 0
346 MEREP Mère Paillarde 1997 1997 1997 1997 0 1997 0
347 MEREP Mère Paillarde 1997 1997 1997 1997 0 1997 0
348 MEREP Mère Paillarde 1997 1997 1997 1997 0 1997 0
349 MEREP Mère Paillarde 1997 1997 1997 1997 0 1997 0
350 MEREP Mère Paillarde 1997 1997 1997 1997 0
351 MEREP Mère Paillarde 1997 1997 1997 0 -1997
352 MORGK Morgenstern Gesundkost 1996 1996 1996 1997 1 1997 1
353 MORGK Morgenstern Gesundkost 1997 1997 1997 1997 0 1997 0
354 MORGK Morgenstern Gesundkost 1997 1997 1997 1997 0 1998 1
355 MORGK Morgenstern Gesundkost 1997 1997 1997 1998 1
356 MORGK Morgenstern Gesundkost 1998 1998 1998 0 -1998
357 NORTS North/South 1997 1997 1997 1997 0 1998 1
358 NORTS North/South 1997 1997 1997 1998 1
359 NORTS North/South 1998 1998 1998 0 -1998
360 OCEAN Océano Atlántico Ltda. 1997 1997 1997 1997 0 1998 1
361 OCEAN Océano Atlántico Ltda. 1997 1997 1997 1998 1 1998 1
362 OCEAN Océano Atlántico Ltda. 1998 1998 1998 1998 0
363 OCEAN Océano Atlántico Ltda. 1998 1998 1998 0 -1998
364 OLDWO Old World Delicatessen 1996 1996 1996 1996 0 1997 1
365 OLDWO Old World Delicatessen 1996 1996 1996 1997 1 1997 1
366 OLDWO Old World Delicatessen 1997 1997 1997 1997 0 1997 0
367 OLDWO Old World Delicatessen 1997 1997 1997 1997 0 1997 0
368 OLDWO Old World Delicatessen 1997 1997 1997 1997 0 1998 1
369 OLDWO Old World Delicatessen 1997 1997 1997 1998 1 1998 1
370 OLDWO Old World Delicatessen 1998 1998 1998 1998 0 1998 0
371 OLDWO Old World Delicatessen 1998 1998 1998 1998 0
372 OLDWO Old World Delicatessen 1998 1998 1998 0 -1998
373 OTTIK Ottilies Käseladen 1996 1996 1996 1997 1 1997 1
374 OTTIK Ottilies Käseladen 1997 1997 1997 1997 0 1997 0
375 OTTIK Ottilies Käseladen 1997 1997 1997 1997 0 1997 0
376 OTTIK Ottilies Käseladen 1997 1997 1997 1997 0 1997 0
377 OTTIK Ottilies Käseladen 1997 1997 1997 1997 0 1997 0
378 OTTIK Ottilies Käseladen 1997 1997 1997 1997 0 1998 1
379 OTTIK Ottilies Käseladen 1997 1997 1997 1998 1 1998 1
380 OTTIK Ottilies Käseladen 1998 1998 1998 1998 0
381 OTTIK Ottilies Käseladen 1998 1998 1998 0 -1998
382 PARIS Paris spécialités 0 0 0 0 0
383 PERIC Pericles Comidas clásicas 1996 1996 1996 1996 0 1997 1
384 PERIC Pericles Comidas clásicas 1996 1996 1996 1997 1 1997 1
385 PERIC Pericles Comidas clásicas 1997 1997 1997 1997 0 1998 1
386 PERIC Pericles Comidas clásicas 1997 1997 1997 1998 1 1998 1
387 PERIC Pericles Comidas clásicas 1998 1998 1998 1998 0
388 PERIC Pericles Comidas clásicas 1998 1998 1998 0 -1998
389 PICCO Piccolo und mehr 1996 1996 1996 1996 0 1997 1
390 PICCO Piccolo und mehr 1996 1996 1996 1997 1 1997 1
391 PICCO Piccolo und mehr 1997 1997 1997 1997 0 1997 0
392 PICCO Piccolo und mehr 1997 1997 1997 1997 0 1997 0
393 PICCO Piccolo und mehr 1997 1997 1997 1997 0 1997 0
394 PICCO Piccolo und mehr 1997 1997 1997 1997 0 1997 0
395 PICCO Piccolo und mehr 1997 1997 1997 1997 0 1998 1
396 PICCO Piccolo und mehr 1997 1997 1997 1998 1 1998 1
397 PICCO Piccolo und mehr 1998 1998 1998 1998 0
398 PICCO Piccolo und mehr 1998 1998 1998 0 -1998
399 PRINI Princesa Isabel Vinhos 1996 1996 1996 1996 0 1997 1
400 PRINI Princesa Isabel Vinhos 1996 1996 1996 1997 1 1997 1
401 PRINI Princesa Isabel Vinhos 1997 1997 1997 1997 0 1998 1
402 PRINI Princesa Isabel Vinhos 1997 1997 1997 1998 1
403 PRINI Princesa Isabel Vinhos 1998 1998 1998 0 -1998
404 QUEDE Que Delícia 1996 1996 1996 1996 0 1996 0
405 QUEDE Que Delícia 1996 1996 1996 1996 0 1997 1
406 QUEDE Que Delícia 1996 1996 1996 1997 1 1997 1
407 QUEDE Que Delícia 1997 1997 1997 1997 0 1997 0
408 QUEDE Que Delícia 1997 1997 1997 1997 0 1997 0
409 QUEDE Que Delícia 1997 1997 1997 1997 0 1997 0
410 QUEDE Que Delícia 1997 1997 1997 1997 0 1998 1
411 QUEDE Que Delícia 1997 1997 1997 1998 1
412 QUEDE Que Delícia 1998 1998 1998 0 -1998
413 QUEEN Queen Cozinha 1996 1996 1996 1997 1 1997 1
414 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1997 0
415 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1997 0
416 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1997 0
417 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1997 0
418 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1997 0
419 QUEEN Queen Cozinha 1997 1997 1997 1997 0 1998 1
420 QUEEN Queen Cozinha 1997 1997 1997 1998 1 1998 1
421 QUEEN Queen Cozinha 1998 1998 1998 1998 0 1998 0
422 QUEEN Queen Cozinha 1998 1998 1998 1998 0
423 QUEEN Queen Cozinha 1998 1998 1998 0 -1998
424 QUICK QUICK-Stop 1996 1996 1996 1996 0 1996 0
425 QUICK QUICK-Stop 1996 1996 1996 1996 0 1997 1
426 QUICK QUICK-Stop 1996 1996 1996 1997 1 1997 1
427 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
428 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
429 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
430 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
431 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
432 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
433 QUICK QUICK-Stop 1997 1997 1997 1997 0 1997 0
434 QUICK QUICK-Stop 1997 1997 1997 1997 0 1998 1
435 QUICK QUICK-Stop 1997 1997 1997 1998 1 1998 1
436 QUICK QUICK-Stop 1998 1998 1998 1998 0 1998 0
437 QUICK QUICK-Stop 1998 1998 1998 1998 0 1998 0
438 QUICK QUICK-Stop 1998 1998 1998 1998 0
439 QUICK QUICK-Stop 1998 1998 1998 0 -1998
440 RANCH Rancho grande 1997 1997 1997 1997 0 1998 1
441 RANCH Rancho grande 1997 1997 1997 1998 1 1998 1
442 RANCH Rancho grande 1998 1998 1998 1998 0 1998 0
443 RANCH Rancho grande 1998 1998 1998 1998 0
444 RANCH Rancho grande 1998 1998 1998 0 -1998
445 RATTC Rattlesnake Canyon Grocery 1996 1996 1996 1996 0 1996 0
446 RATTC Rattlesnake Canyon Grocery 1996 1996 1996 1996 0 1996 0
447 RATTC Rattlesnake Canyon Grocery 1996 1996 1996 1996 0 1997 1
448 RATTC Rattlesnake Canyon Grocery 1996 1996 1996 1997 1 1997 1
449 RATTC Rattlesnake Canyon Grocery 1997 1997 1997 1997 0 1997 0
450 RATTC Rattlesnake Canyon Grocery 1997 1997 1997 1997 0 1997 0
451 RATTC Rattlesnake Canyon Grocery 1997 1997 1997 1997 0 1997 0
452 RATTC Rattlesnake Canyon Grocery 1997 1997 1997 1997 0 1998 1
453 RATTC Rattlesnake Canyon Grocery 1997 1997 1997 1998 1 1998 1
454 RATTC Rattlesnake Canyon Grocery 1998 1998 1998 1998 0 1998 0
455 RATTC Rattlesnake Canyon Grocery 1998 1998 1998 1998 0 1998 0
456 RATTC Rattlesnake Canyon Grocery 1998 1998 1998 1998 0 1998 0
457 RATTC Rattlesnake Canyon Grocery 1998 1998 1998 1998 0
458 RATTC Rattlesnake Canyon Grocery 1998 1998 1998 0 -1998
459 REGGC Reggiani Caseifici 1996 1996 1996 1997 1 1997 1
460 REGGC Reggiani Caseifici 1997 1997 1997 1997 0 1997 0
461 REGGC Reggiani Caseifici 1997 1997 1997 1997 0 1997 0
462 REGGC Reggiani Caseifici 1997 1997 1997 1997 0 1997 0
463 REGGC Reggiani Caseifici 1997 1997 1997 1997 0 1997 0
464 REGGC Reggiani Caseifici 1997 1997 1997 1997 0 1998 1
465 REGGC Reggiani Caseifici 1997 1997 1997 1998 1 1998 1
466 REGGC Reggiani Caseifici 1998 1998 1998 1998 0 1998 0
467 REGGC Reggiani Caseifici 1998 1998 1998 1998 0 1998 0
468 REGGC Reggiani Caseifici 1998 1998 1998 1998 0
469 REGGC Reggiani Caseifici 1998 1998 1998 0 -1998
470 RICAR Ricardo Adocicados 1996 1996 1996 1996 0 1997 1
471 RICAR Ricardo Adocicados 1996 1996 1996 1997 1 1997 1
472 RICAR Ricardo Adocicados 1997 1997 1997 1997 0 1997 0
473 RICAR Ricardo Adocicados 1997 1997 1997 1997 0 1997 0
474 RICAR Ricardo Adocicados 1997 1997 1997 1997 0 1998 1
475 RICAR Ricardo Adocicados 1997 1997 1997 1998 1 1998 1
476 RICAR Ricardo Adocicados 1998 1998 1998 1998 0 1998 0
477 RICAR Ricardo Adocicados 1998 1998 1998 1998 0
478 RICAR Ricardo Adocicados 1998 1998 1998 0 -1998
479 RICSU Richter Supermarkt 1996 1996 1996 1997 1 1997 1
480 RICSU Richter Supermarkt 1997 1997 1997 1997 0 1997 0
481 RICSU Richter Supermarkt 1997 1997 1997 1997 0 1997 0
482 RICSU Richter Supermarkt 1997 1997 1997 1997 0 1998 1
483 RICSU Richter Supermarkt 1997 1997 1997 1998 1 1998 1
484 RICSU Richter Supermarkt 1998 1998 1998 1998 0 1998 0
485 RICSU Richter Supermarkt 1998 1998 1998 1998 0
486 RICSU Richter Supermarkt 1998 1998 1998 0 -1998
487 ROMEY Romero y tomillo 1996 1996 1996 1996 0 1998 2
488 ROMEY Romero y tomillo 1996 1996 1996 1998 2 1998 2
489 ROMEY Romero y tomillo 1998 1998 1998 1998 0
490 ROMEY Romero y tomillo 1998 1998 1998 0 -1998
491 SANTG Santé Gourmet 1996 1996 1996 1997 1 1997 1
492 SANTG Santé Gourmet 1997 1997 1997 1997 0 1998 1
493 SANTG Santé Gourmet 1997 1997 1997 1998 1 1998 1
494 SANTG Santé Gourmet 1998 1998 1998 1998 0 1998 0
495 SANTG Santé Gourmet 1998 1998 1998 1998 0
496 SANTG Santé Gourmet 1998 1998 1998 0 -1998
497 SAVEA Save-a-lot Markets 1996 1996 1996 1996 0 1997 1
498 SAVEA Save-a-lot Markets 1996 1996 1996 1997 1 1997 1
499 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
500 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
501 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
502 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
503 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
504 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1997 0
505 SAVEA Save-a-lot Markets 1997 1997 1997 1997 0 1998 1
506 SAVEA Save-a-lot Markets 1997 1997 1997 1998 1 1998 1
507 SAVEA Save-a-lot Markets 1998 1998 1998 1998 0 1998 0
508 SAVEA Save-a-lot Markets 1998 1998 1998 1998 0 1998 0
509 SAVEA Save-a-lot Markets 1998 1998 1998 1998 0 1998 0
510 SAVEA Save-a-lot Markets 1998 1998 1998 1998 0
511 SAVEA Save-a-lot Markets 1998 1998 1998 0 -1998
512 SEVES Seven Seas Imports 1996 1996 1996 1996 0 1997 1
513 SEVES Seven Seas Imports 1996 1996 1996 1997 1 1997 1
514 SEVES Seven Seas Imports 1997 1997 1997 1997 0 1997 0
515 SEVES Seven Seas Imports 1997 1997 1997 1997 0 1998 1
516 SEVES Seven Seas Imports 1997 1997 1997 1998 1
517 SEVES Seven Seas Imports 1998 1998 1998 0 -1998
518 SIMOB Simons bistro 1996 1996 1996 1997 1 1997 1
519 SIMOB Simons bistro 1997 1997 1997 1997 0 1997 0
520 SIMOB Simons bistro 1997 1997 1997 1997 0 1997 0
521 SIMOB Simons bistro 1997 1997 1997 1997 0 1997 0
522 SIMOB Simons bistro 1997 1997 1997 1997 0 1998 1
523 SIMOB Simons bistro 1997 1997 1997 1998 1
524 SIMOB Simons bistro 1998 1998 1998 0 -1998
525 SPECD Spécialités du monde 1997 1997 1997 1998 1 1998 1
526 SPECD Spécialités du monde 1998 1998 1998 1998 0 1998 0
527 SPECD Spécialités du monde 1998 1998 1998 1998 0
528 SPECD Spécialités du monde 1998 1998 1998 0 -1998
529 SPLIR Split Rail Beer & Ale 1996 1996 1996 1996 0 1996 0
530 SPLIR Split Rail Beer & Ale 1996 1996 1996 1996 0 1996 0
531 SPLIR Split Rail Beer & Ale 1996 1996 1996 1996 0 1997 1
532 SPLIR Split Rail Beer & Ale 1996 1996 1996 1997 1 1997 1
533 SPLIR Split Rail Beer & Ale 1997 1997 1997 1997 0 1998 1
534 SPLIR Split Rail Beer & Ale 1997 1997 1997 1998 1 1998 1
535 SPLIR Split Rail Beer & Ale 1998 1998 1998 1998 0
536 SPLIR Split Rail Beer & Ale 1998 1998 1998 0 -1998
537 SUPRD Suprêmes délices 1996 1996 1996 1996 0 1997 1
538 SUPRD Suprêmes délices 1996 1996 1996 1997 1 1997 1
539 SUPRD Suprêmes délices 1997 1997 1997 1997 0 1997 0
540 SUPRD Suprêmes délices 1997 1997 1997 1997 0 1998 1
541 SUPRD Suprêmes délices 1997 1997 1997 1998 1 1998 1
542 SUPRD Suprêmes délices 1998 1998 1998 1998 0 1998 0
543 SUPRD Suprêmes délices 1998 1998 1998 1998 0 1998 0
544 SUPRD Suprêmes délices 1998 1998 1998 1998 0
545 SUPRD Suprêmes délices 1998 1998 1998 0 -1998
546 THEBI The Big Cheese 1996 1996 1996 1997 1 1997 1
547 THEBI The Big Cheese 1997 1997 1997 1997 0 1998 1
548 THEBI The Big Cheese 1997 1997 1997 1998 1
549 THEBI The Big Cheese 1998 1998 1998 0 -1998
550 THECR The Cracker Box 1997 1997 1997 1997 0 1998 1
551 THECR The Cracker Box 1997 1997 1997 1998 1
552 THECR The Cracker Box 1998 1998 1998 0 -1998
553 TOMSP Toms Spezialitäten 1996 1996 1996 1997 1 1997 1
554 TOMSP Toms Spezialitäten 1997 1997 1997 1997 0 1997 0
555 TOMSP Toms Spezialitäten 1997 1997 1997 1997 0 1998 1
556 TOMSP Toms Spezialitäten 1997 1997 1997 1998 1
557 TOMSP Toms Spezialitäten 1998 1998 1998 0 -1998
558 TORTU Tortuga Restaurante 1996 1996 1996 1996 0 1996 0
559 TORTU Tortuga Restaurante 1996 1996 1996 1996 0 1997 1
560 TORTU Tortuga Restaurante 1996 1996 1996 1997 1 1997 1
561 TORTU Tortuga Restaurante 1997 1997 1997 1997 0 1997 0
562 TORTU Tortuga Restaurante 1997 1997 1997 1997 0 1998 1
563 TORTU Tortuga Restaurante 1997 1997 1997 1998 1 1998 1
564 TORTU Tortuga Restaurante 1998 1998 1998 1998 0 1998 0
565 TORTU Tortuga Restaurante 1998 1998 1998 1998 0
566 TORTU Tortuga Restaurante 1998 1998 1998 0 -1998
567 TRADH Tradição Hipermercados 1996 1996 1996 1997 1 1997 1
568 TRADH Tradição Hipermercados 1997 1997 1997 1997 0 1998 1
569 TRADH Tradição Hipermercados 1997 1997 1997 1998 1
570 TRADH Tradição Hipermercados 1998 1998 1998 0 -1998
571 TRAIH Trail's Head Gourmet Provisioners 1997 1997 1997 1998 1
572 TRAIH Trail's Head Gourmet Provisioners 1998 1998 1998 0 -1998
573 VAFFE Vaffeljernet 1996 1996 1996 1996 0 1997 1
574 VAFFE Vaffeljernet 1996 1996 1996 1997 1 1997 1
575 VAFFE Vaffeljernet 1997 1997 1997 1997 0 1997 0
576 VAFFE Vaffeljernet 1997 1997 1997 1997 0 1997 0
577 VAFFE Vaffeljernet 1997 1997 1997 1997 0 1997 0
578 VAFFE Vaffeljernet 1997 1997 1997 1997 0 1998 1
579 VAFFE Vaffeljernet 1997 1997 1997 1998 1 1998 1
580 VAFFE Vaffeljernet 1998 1998 1998 1998 0
581 VAFFE Vaffeljernet 1998 1998 1998 0 -1998
582 VICTE Victuailles en stock 1996 1996 1996 1996 0 1997 1
583 VICTE Victuailles en stock 1996 1996 1996 1997 1 1997 1
584 VICTE Victuailles en stock 1997 1997 1997 1997 0 1997 0
585 VICTE Victuailles en stock 1997 1997 1997 1997 0 1997 0
586 VICTE Victuailles en stock 1997 1997 1997 1997 0 1998 1
587 VICTE Victuailles en stock 1997 1997 1997 1998 1
588 VICTE Victuailles en stock 1998 1998 1998 0 -1998
589 VINET Vins et alcools Chevalier 1996 1996 1996 1996 0 1996 0
590 VINET Vins et alcools Chevalier 1996 1996 1996 1996 0 1997 1
591 VINET Vins et alcools Chevalier 1996 1996 1996 1997 1
592 VINET Vins et alcools Chevalier 1997 1997 1997 0 -1997
593 WANDK Die Wandernde Kuh 1996 1996 1996 1996 0 1997 1
594 WANDK Die Wandernde Kuh 1996 1996 1996 1997 1 1997 1
595 WANDK Die Wandernde Kuh 1997 1997 1997 1997 0 1997 0
596 WANDK Die Wandernde Kuh 1997 1997 1997 1997 0 1998 1
597 WANDK Die Wandernde Kuh 1997 1997 1997 1998 1
598 WANDK Die Wandernde Kuh 1998 1998 1998 0 -1998
599 WARTH Wartian Herkku 1996 1996 1996 1996 0 1996 0
600 WARTH Wartian Herkku 1996 1996 1996 1996 0 1997 1
601 WARTH Wartian Herkku 1996 1996 1996 1997 1 1997 1
602 WARTH Wartian Herkku 1997 1997 1997 1997 0 1997 0
603 WARTH Wartian Herkku 1997 1997 1997 1997 0 1997 0
604 WARTH Wartian Herkku 1997 1997 1997 1997 0 1997 0
605 WARTH Wartian Herkku 1997 1997 1997 1997 0 1997 0
606 WARTH Wartian Herkku 1997 1997 1997 1997 0 1997 0
607 WARTH Wartian Herkku 1997 1997 1997 1997 0 1998 1
608 WARTH Wartian Herkku 1997 1997 1997 1998 1
609 WARTH Wartian Herkku 1998 1998 1998 0 -1998
610 WELLI Wellington Importadora 1996 1996 1996 1997 1 1997 1
611 WELLI Wellington Importadora 1997 1997 1997 1997 0 1997 0
612 WELLI Wellington Importadora 1997 1997 1997 1997 0 1997 0
613 WELLI Wellington Importadora 1997 1997 1997 1997 0 1998 1
614 WELLI Wellington Importadora 1997 1997 1997 1998 1 1998 1
615 WELLI Wellington Importadora 1998 1998 1998 1998 0 1998 0
616 WELLI Wellington Importadora 1998 1998 1998 1998 0
617 WELLI Wellington Importadora 1998 1998 1998 0 -1998
618 WHITC White Clover Markets 1996 1996 1996 1996 0 1997 1
619 WHITC White Clover Markets 1996 1996 1996 1997 1 1997 1
620 WHITC White Clover Markets 1997 1997 1997 1997 0 1997 0
621 WHITC White Clover Markets 1997 1997 1997 1997 0 1997 0
622 WHITC White Clover Markets 1997 1997 1997 1997 0 1997 0
623 WHITC White Clover Markets 1997 1997 1997 1997 0 1998 1
624 WHITC White Clover Markets 1997 1997 1997 1998 1 1998 1
625 WHITC White Clover Markets 1998 1998 1998 1998 0 1998 0
626 WHITC White Clover Markets 1998 1998 1998 1998 0 1998 0
627 WHITC White Clover Markets 1998 1998 1998 1998 0
628 WHITC White Clover Markets 1998 1998 1998 0 -1998
629 WILMK Wilman Kala 1997 1997 1997 1997 0 1997 0
630 WILMK Wilman Kala 1997 1997 1997 1997 0 1998 1
631 WILMK Wilman Kala 1997 1997 1997 1998 1 1998 1
632 WILMK Wilman Kala 1998 1998 1998 1998 0
633 WILMK Wilman Kala 1998 1998 1998 0 -1998
634 WOLZA Wolski Zajazd 1996 1996 1996 1997 1 1997 1
635 WOLZA Wolski Zajazd 1997 1997 1997 1997 0 1998 1
636 WOLZA Wolski Zajazd 1997 1997 1997 1998 1 1998 1
637 WOLZA Wolski Zajazd 1998 1998 1998 1998 0
638 WOLZA Wolski Zajazd 1998 1998 1998 0 -1998