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/-3 3,25 1.50/4 1.50/4 3.00/2 0.00/2
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   8/2 2,33 1.50/6 1.50/6 2.33/3 0.67/3
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/0 1,50 1.25/8 1.25/8 1.40/5 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   17/8 2,17 1.75/12 2.00/8 2.50/6 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-19 PSG 2-0 Nantes 24/17 2,58 2.17/12 2.38/8 2.33/6 2.00/6   9/-9 2,08 0.92/13 0.88/8 0.83/6 1.00/7
2016-11-26 Nantes 0-0 Lille 9/-11 2,07 0.86/14 0.88/8 0.83/6 0.88/8   10/-10 2,14 0.71/14 0.75/8 1.13/8 0.17/6
2016-11-30 Nantes 0-6 Lyon 9/-11 1,93 0.87/15 1.00/8 0.86/7 0.88/8   23/3 2,87 1.47/15 1.50/8 1.50/8 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/-17 2,19 0.81/16 0.63/8 0.75/8 0.88/8
2016-12-16 Angers 0-2 Nantes 15/-7 2,06 1.06/18 0.63/8 1.50/8 0.70/10   9/-19 2,18 0.76/17 0.25/8 0.75/8 0.78/9
2016-12-21 Nantes 1-0 Montpellier 11/-17 2,17 0.89/18 0.63/8 0.75/8 1.00/10   31/1 3,21 1.32/19 1.75/8 2.10/10 0.44/9
2017-01-14 Toulouse 0-1 Nantes 24/3 2,25 1.45/20 1.00/8 2.20/10 0.70/10   12/-16 2,11 1.00/19 1.00/8 1.00/9 1.00/10
2017-01-18 Nantes 1-0 Caen 13/-15 2,05 1.10/20 1.25/8 1.00/9 1.18/11   23/-17 3,15 1.05/20 1.38/8 1.82/11 0.11/9
2017-01-21 Nantes 0-2 PSG 14/-14 2,00 1.19/21 1.63/8 1.20/10 1.18/11   39/24 2,70 2.10/20 2.00/8 2.40/10 1.80/10
2017-01-21 Nantes 0-2 Paris SG 14/-16 2,00 1.14/22 1.50/8 1.09/11 1.18/11   39/24 2,70 2.10/20 2.00/8 2.40/10 1.80/10
2017-01-28 Rennes 1-1 Nantes 21/-9 2,22 1.26/23 0.63/8 1.92/12 0.55/11   14/-18 2,00 1.09/23 1.50/8 1.00/12 1.18/11
2017-02-05 Nantes 0-2 Nancy 15/-18 2,00 1.08/24 1.63/8 1.00/12 1.17/12   17/-10 2,00 1.09/22 1.50/8 1.33/12 0.80/10
2017-02-12 Nantes 3-2 Marseille 15/-20 2,00 1.04/25 1.63/8 0.92/13 1.17/12   31/3 2,36 1.48/25 1.88/8 2.25/12 0.77/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-24 Nantes 3-1 Dijon 19/-19 2,11 1.11/27 1.38/8 1.07/14 1.15/13   37/-10 3,00 0.96/28 1.00/8 1.43/14 0.50/14
2017-03-01 Bastia 2-2 Nantes 22/-15 2,19 0.85/27 0.38/8 1.14/14 0.54/13   22/-17 2,18 1.18/28 1.38/8 1.20/15 1.15/13
2017-03-05 Monaco 4-0 Nantes 82/55 3,76 2.28/29 2.25/8 2.64/14 1.93/15   24/-17 2,24 1.17/29 1.13/8 1.20/15 1.14/14
2017-03-11 Montpellier 2-3 Nantes 43/-3 3,07 1.24/29 1.25/8 1.93/15 0.50/14   24/-21 2,30 1.13/30 1.13/8 1.20/15 1.07/15
2017-03-18 Nantes 1-1 Nice 27/-20 2,39 1.19/31 1.50/8 1.20/15 1.19/16   49/24 2,47 2.13/30 2.13/8 2.47/15 1.80/15
2017-04-02 Nantes 2-1 Angers 28/-20 2,38 1.19/32 1.50/8 1.19/16 1.19/16   31/-9 2,29 1.26/31 2.00/8 1.73/15 0.81/16
2017-04-09 St Etienne 1-1 Nantes 35/10 1,94 1.45/31 1.38/8 1.80/15 1.13/16   30/-19 2,39 1.24/33 1.88/8 1.29/17 1.19/16
2017-04-16 Nantes 0-1 Bordeaux 31/-19 2,38 1.24/34 1.63/8 1.29/17 1.18/17   46/2 2,65 1.44/34 1.63/8 1.61/18 1.25/16
2017-04-22 Caen 0-2 Nantes 33/-29 2,79 0.97/34 1.00/8 1.35/17 0.59/17   31/-20 2,34 1.20/35 1.50/8 1.22/18 1.18/17
2017-04-29 Nantes 1-0 Lorient 33/-18 2,33 1.25/36 1.50/8 1.22/18 1.28/18   43/-29 3,19 0.94/36 1.50/8 1.28/18 0.61/18
2017-05-07 Lyon 3-2 Nantes 73/27 3,22 1.62/37 1.25/8 1.83/18 1.42/19   34/-17 2,30 1.30/37 1.75/8 1.32/19 1.28/18
2017-05-14 Nantes 4-1 Guingamp 36/-18 2,37 1.26/38 1.75/8 1.32/19 1.21/19   46/-8 2,63 1.32/38 1.13/8 2.05/19 0.58/19
2017-05-20 Lille 3-0 Nantes 38/-12 2,26 1.10/39 1.25/8 1.11/19 1.10/20   40/-15 2,44 1.31/39 1.75/8 1.40/20 1.21/19