SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Metz' OR Away='Metz') ORDER BY Dato ASC;
Dato Home Score Away H Goals/Dif A Goals Av. H Avp/M H Avp Last/M H Avp Home/M H Avp Away/M   A Goals/Dif A Goals Av. A Avp/M A Avp Last/M A Avp Home/M A Avp Away/M
2016-08-13 Metz 3-2 Lille 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2016-08-21 PSG 3-0 Metz 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-21 Paris SG 3-0 Metz 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/-2 4,00 1.50/2 1.00/3 3.00/1 0.00/1
2016-08-27 Metz 2-0 Angers 3/-5 3,67 1.00/3 1.00/3 3.00/1 0.00/2   0/-2 1,00 0.00/2 0.00/2 0.00/1 0.00/1
2016-09-11 Nantes 0-3 Metz 1/-1 1,00 1.00/3 1.00/3 0.00/1 1.50/2   5/-3 3,25 1.50/4 1.50/4 3.00/2 0.00/2
2016-09-17 Dijon 0-0 Metz 5/-2 3,00 0.75/4 0.75/4 1.50/2 0.00/2   8/0 3,20 1.80/5 1.80/5 3.00/2 1.00/3
2016-09-21 Metz 0-3 Bordeaux 8/0 2,67 1.67/6 1.67/6 3.00/2 1.00/4   8/0 3,20 1.80/5 1.80/5 2.00/3 1.50/2
2016-09-24 Montpellier 0-1 Metz 6/-5 2,83 1.00/6 1.00/6 1.67/3 0.33/3   8/-3 2,71 1.43/7 1.43/7 2.00/3 1.00/4
2016-10-01 Metz 0-7 Monaco 9/-2 2,50 1.63/8 1.63/8 2.00/3 1.40/5   18/8 3,50 2.38/8 2.38/8 2.60/5 2.00/3
2016-10-16 Marseille 1-0 Metz 10/0 2,50 1.13/8 1.13/8 2.00/4 0.25/4   9/-9 3,00 1.44/9 1.25/8 1.50/4 1.40/5
2016-10-23 Metz 2-4 Nice 9/-10 2,80 1.30/10 1.25/8 1.50/4 1.17/6   16/11 2,33 2.56/9 2.50/8 2.67/6 2.33/3
2016-10-30 Rennes 1-0 Metz 12/0 2,40 1.70/10 1.75/8 2.60/5 0.80/5   11/-12 3,09 1.18/11 1.25/8 1.20/5 1.17/6
2016-11-06 Metz 0-0 St Etienne 11/-13 2,92 1.08/12 0.88/8 1.20/5 1.00/7   15/4 2,17 1.50/12 1.63/8 2.00/6 1.00/6
2016-11-19 Toulouse 1-2 Metz 18/8 2,15 1.69/13 1.75/8 2.50/6 1.00/7   11/-13 2,69 1.08/13 0.63/8 1.17/6 1.00/7
2016-11-26 Metz 3-3 Lorient 13/-12 2,71 1.21/14 0.88/8 1.17/6 1.25/8   9/-14 2,46 0.54/13 0.50/8 1.00/7 0.00/6
2016-11-30 Nancy 4-0 Metz 9/-12 2,00 0.87/15 1.00/8 0.88/8 0.86/7   16/-12 2,93 1.20/15 1.00/8 1.14/7 1.25/8
2016-12-10 Bastia 2-0 Metz 12/-9 1,94 0.82/17 0.50/8 1.11/9 0.50/8   16/-16 3,00 1.13/16 0.63/8 1.14/7 1.11/9
2016-12-18 Caen 3-0 Metz 16/-20 3,06 0.88/17 0.63/8 1.56/9 0.13/8   16/-18 2,94 1.06/17 0.63/8 1.14/7 1.00/10
2016-12-21 Metz 2-2 Guingamp 16/-21 2,94 1.00/18 0.63/8 1.14/7 0.91/11   25/7 2,26 1.68/19 1.50/8 2.30/10 1.00/9
2017-01-15 Nice 0-0 Metz 36/21 2,55 2.25/20 2.00/8 2.60/10 1.90/10   18/-21 3,00 1.00/19 0.75/8 1.13/8 0.91/11
2017-01-21 Metz 2-0 Montpellier 18/-21 2,85 1.00/20 0.88/8 1.13/8 0.92/12   32/0 3,05 1.24/21 1.38/8 2.00/11 0.40/10
2017-01-28 Angers 2-1 Metz 17/-12 2,09 0.91/22 0.25/8 1.30/10 0.58/12   20/-19 2,81 1.10/21 1.13/8 1.33/9 0.92/12
2017-02-03 Metz 1-0 Marseille 21/-20 2,82 1.05/22 0.75/8 1.33/9 0.85/13   29/2 2,43 1.48/23 2.00/8 2.18/11 0.83/12
2017-02-08 Metz 2-1 Dijon 22/-19 2,74 1.13/23 1.00/8 1.50/10 0.85/13   32/-9 2,92 0.96/25 1.00/8 1.31/13 0.58/12
2017-02-11 Monaco 5-0 Metz 74/49 3,81 2.27/26 2.13/8 2.62/13 1.92/13   24/-18 2,75 1.21/24 1.38/8 1.64/11 0.85/13
2017-02-18 Metz 1-1 Nantes 24/-23 2,84 1.16/25 1.38/8 1.64/11 0.79/14   18/-19 2,12 1.12/26 1.63/8 1.07/14 1.17/12
2017-02-26 Lyon 5-0 Metz 50/17 3,19 1.65/26 1.50/8 1.93/14 1.33/12   25/-23 2,81 1.15/26 1.50/8 1.58/12 0.79/14
2017-03-04 Metz 1-1 Rennes 25/-28 2,89 1.11/27 1.38/8 1.58/12 0.73/15   26/-10 2,14 1.24/29 1.00/8 1.87/15 0.57/14
2017-03-12 St Etienne 2-2 Metz 32/9 1,90 1.41/29 1.63/8 1.86/14 1.00/15   26/-28 2,86 1.11/28 1.38/8 1.54/13 0.73/15
2017-03-17 Metz 1-0 Bastia 28/-28 2,90 1.10/29 1.13/8 1.54/13 0.75/16   24/-20 2,27 0.83/30 0.50/8 1.13/16 0.50/14
2017-04-05 Metz 0-3 Lyon 29/-27 2,83 1.17/30 1.50/8 1.64/14 0.75/16   63/24 3,19 1.59/32 1.38/8 2.06/16 1.13/16
2017-04-08 Bordeaux 3-0 Metz 43/-1 2,64 1.39/33 1.25/8 1.53/17 1.25/16   29/-30 2,84 1.13/31 1.13/8 1.53/15 0.75/16
2017-04-15 Metz 2-2 Caen 29/-33 2,84 1.09/32 0.75/8 1.53/15 0.71/17   31/-29 2,76 0.97/33 0.88/8 1.35/17 0.56/16
2017-04-18 Metz 2-3 Paris SG 31/-33 2,88 1.09/33 0.88/8 1.50/16 0.71/17   66/45 2,72 2.31/32 2.75/8 2.38/16 2.25/16
2017-04-18 Metz 2-3 PSG 33/-34 2,94 1.06/34 0.75/8 1.41/17 0.71/17   66/45 2,72 2.31/32 2.75/8 2.38/16 2.25/16
2017-04-22 Lorient 5-1 Metz 38/-33 3,11 0.89/35 1.13/8 1.18/17 0.61/18   35/-35 3,00 1.03/35 0.75/8 1.33/18 0.71/17
2017-04-29 Metz 2-1 Nancy 36/-39 3,08 1.00/36 0.63/8 1.33/18 0.67/18   26/-21 2,03 0.89/36 0.50/8 1.17/18 0.61/18
2017-05-06 Lille 0-2 Metz 38/-6 2,22 1.16/37 1.75/8 1.17/18 1.16/19   38/-38 3,08 1.05/37 0.88/8 1.42/19 0.67/18
2017-05-14 Metz 1-1 Toulouse 40/-36 3,05 1.11/38 0.88/8 1.42/19 0.79/19   38/-2 2,05 1.21/38 0.75/8 1.68/19 0.74/19
2017-05-20 Guingamp 1-0 Metz 47/-11 2,69 1.28/39 1.13/8 2.05/19 0.55/20   41/-36 3,03 1.10/39 1.00/8 1.40/20 0.79/19