SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Nantes' OR Away='Nantes') 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 Dijon 0-1 Nantes 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-20 Nantes 0-1 Monaco 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-28 Bordeaux 1-0 Nantes 4/-2 5,00 1.50/2 1.50/2 3.00/1 0.00/1   1/0 1,00 1.50/2 1.50/2 0.00/1 3.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/0 3,33 2.00/3 2.00/3 3.00/2 0.00/1
2016-09-17 Nancy 1-1 Nantes 2/-5 2,25 0.75/4 0.75/4 0.00/2 1.50/2   1/-4 1,50 0.75/4 0.75/4 0.00/2 1.50/2
2016-09-21 Nantes 0-0 St Etienne 2/-4 1,60 0.80/5 0.80/5 0.00/2 1.33/3   7/2 2,40 1.60/5 1.60/5 2.33/3 0.50/2
2016-09-25 Marseille 2-1 Nantes 7/-1 2,50 0.83/6 0.83/6 1.67/3 0.00/3   2/-4 1,33 0.83/6 0.83/6 0.33/3 1.33/3
2016-10-01 Nantes 1-0 Bastia 3/-5 1,57 0.71/7 0.71/7 0.33/3 1.00/4   6/1 1,57 1.43/7 1.43/7 1.75/4 1.00/3
2016-10-15 Lorient 1-2 Nantes 5/-8 2,25 0.75/8 0.75/8 1.50/4 0.00/4   4/-4 1,50 1.00/8 1.00/8 1.00/4 1.00/4
2016-10-22 Nantes 1-2 Rennes 6/-3 1,67 1.22/9 1.00/8 1.00/4 1.40/5   10/-1 2,33 1.56/9 1.75/8 2.60/5 0.25/4
2016-10-30 Nice 4-1 Nantes 20/13 2,70 2.60/10 2.50/8 2.67/6 2.50/4   7/-4 1,80 1.10/10 1.00/8 0.80/5 1.40/5
2016-11-05 Nantes 1-1 Toulouse 8/-7 2,09 1.00/11 1.00/8 0.80/5 1.17/6   15/6 2,18 1.64/11 1.63/8 2.40/5 1.00/6
2016-11-19 Paris SG 2-0 Nantes 24/17 2,58 2.17/12 2.38/8 2.33/6 2.00/6   9/-7 2,08 1.00/12 1.13/8 0.83/6 1.17/6
2016-11-26 Nantes 0-0 Lille 9/-9 2,08 0.92/13 1.00/8 0.83/6 1.00/7   10/-9 2,23 0.77/13 0.75/8 1.29/7 0.17/6
2016-11-30 Nantes 0-6 Lyon 9/-9 1,93 0.93/14 1.00/8 0.86/7 1.00/7   22/4 2,86 1.57/14 1.50/8 1.71/7 1.43/7
2016-12-03 Guingamp 2-0 Nantes 19/4 2,27 1.53/15 1.50/8 2.00/7 1.13/8   9/-15 2,20 0.87/15 1.00/8 0.75/8 1.00/7
2016-12-16 Angers 0-2 Nantes 15/-5 2,06 1.12/17 0.75/8 1.50/8 0.78/9   9/-17 2,19 0.81/16 0.63/8 0.75/8 0.88/8
2016-12-21 Nantes 1-0 Montpellier 11/-15 2,18 0.94/17 0.63/8 0.75/8 1.11/9   28/-2 3,22 1.22/18 1.50/8 2.00/9 0.44/9
2017-01-14 Toulouse 0-1 Nantes 22/1 2,26 1.37/19 1.00/8 2.11/9 0.70/10   12/-14 2,11 1.06/18 1.00/8 1.00/9 1.11/9
2017-01-18 Nantes 1-0 Caen 13/-13 2,05 1.16/19 1.38/8 1.00/9 1.30/10   23/-11 3,00 1.11/19 1.38/8 2.00/10 0.11/9
2017-01-21 Nantes 0-2 Paris SG 14/-12 2,00 1.25/20 1.63/8 1.20/10 1.30/10   39/24 2,70 2.10/20 2.00/8 2.40/10 1.80/10
2017-01-28 Rennes 1-1 Nantes 21/-4 2,19 1.38/21 1.00/8 2.09/11 0.60/10   14/-14 2,00 1.19/21 1.63/8 1.09/11 1.30/10
2017-02-05 Nantes 0-2 Nancy 15/-14 2,00 1.18/22 1.63/8 1.09/11 1.27/11   16/-9 1,95 1.14/21 1.50/8 1.45/11 0.80/10
2017-02-12 Nantes 3-2 Marseille 15/-16 2,00 1.13/23 1.63/8 1.00/12 1.27/11   31/3 2,46 1.50/24 1.88/8 2.25/12 0.75/12
2017-02-18 Metz 1-1 Nantes 24/-20 2,83 1.21/24 1.38/8 1.64/11 0.85/13   18/-15 2,13 1.21/24 2.00/8 1.15/13 1.27/11
2017-02-24 Nantes 3-1 Dijon 19/-15 2,12 1.20/25 1.75/8 1.15/13 1.25/12   36/-5 2,96 1.04/26 1.38/8 1.54/13 0.54/13
2017-03-01 Bastia 2-2 Nantes 22/-14 2,23 0.88/26 0.38/8 1.23/13 0.54/13   22/-13 2,19 1.27/26 1.75/8 1.29/14 1.25/12
2017-03-05 Monaco 4-0 Nantes 78/53 3,81 2.30/27 2.50/8 2.62/13 2.00/14   24/-13 2,26 1.26/27 1.50/8 1.29/14 1.23/13
2017-03-11 Montpellier 2-3 Nantes 40/-6 3,07 1.18/28 1.25/8 1.86/14 0.50/14   24/-17 2,32 1.21/28 1.13/8 1.29/14 1.14/14
2017-03-18 Nantes 1-1 Nice 27/-16 2,41 1.28/29 1.50/8 1.29/14 1.27/15   47/24 2,41 2.17/29 2.13/8 2.47/15 1.86/14
2017-04-02 Nantes 2-1 Angers 28/-16 2,40 1.27/30 1.50/8 1.27/15 1.27/15   31/-7 2,30 1.30/30 2.00/8 1.73/15 0.87/15
2017-04-09 St Etienne 1-1 Nantes 34/10 1,93 1.47/30 1.38/8 1.80/15 1.13/15   30/-15 2,42 1.32/31 1.88/8 1.38/16 1.27/15
2017-04-16 Nantes 0-1 Bordeaux 31/-15 2,41 1.31/32 1.63/8 1.38/16 1.25/16   46/7 2,66 1.53/32 1.63/8 1.71/17 1.33/15
2017-04-22 Caen 0-2 Nantes 33/-23 2,70 1.00/33 1.00/8 1.44/16 0.59/17   31/-16 2,36 1.27/33 1.50/8 1.29/17 1.25/16
2017-04-29 Nantes 1-0 Lorient 33/-14 2,35 1.32/34 1.50/8 1.29/17 1.35/17   42/-23 3,15 1.00/34 1.50/8 1.35/17 0.65/17
2017-05-07 Lyon 3-2 Nantes 71/29 3,23 1.71/35 1.63/8 1.94/17 1.50/18   34/-13 2,31 1.37/35 1.75/8 1.39/18 1.35/17
2017-05-14 Nantes 4-1 Guingamp 36/-14 2,39 1.33/36 1.75/8 1.39/18 1.28/18   44/-5 2,58 1.31/36 1.50/8 2.00/18 0.61/18
2017-05-20 Lille 3-0 Nantes 37/-10 2,27 1.16/37 1.25/8 1.17/18 1.16/19   40/-11 2,46 1.38/37 1.75/8 1.47/19 1.28/18