SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Nancy' OR Away='Nancy') 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-14 Nancy 0-3 Lyon 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 Rennes 2-0 Nancy 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-27 Nancy 0-2 Guingamp 0/-5 2,50 0.00/2 0.00/2 0.00/1 0.00/1   4/1 3,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-09-10 Lorient 0-2 Nancy 2/-6 3,33 0.00/3 0.00/3 0.00/1 0.00/2   0/-7 2,33 0.00/3 0.00/3 0.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 Bastia 0-0 Nancy 5/-1 1,83 1.00/6 1.00/6 1.00/3 1.00/3   3/-5 2,20 0.80/5 0.80/5 0.33/3 1.50/2
2016-09-25 Nancy 0-1 Nice 3/-5 1,83 0.83/6 0.83/6 0.33/3 1.33/3   11/7 2,50 2.33/6 2.33/6 2.50/4 2.00/2
2016-10-01 Lille 1-0 Nancy 7/-7 3,00 0.57/7 0.57/7 1.00/3 0.25/4   3/-6 1,71 0.71/7 0.71/7 0.25/4 1.33/3
2016-10-15 Nancy 1-2 PSG 3/-7 1,63 0.63/8 0.63/8 0.25/4 1.00/4   17/11 2,88 2.00/8 2.00/8 2.50/4 1.50/4
2016-10-15 Nancy 1-2 Paris SG 4/-8 1,78 0.56/9 0.63/8 0.20/5 1.00/4   17/11 2,88 2.00/8 2.00/8 2.50/4 1.50/4
2016-10-22 Bordeaux 1-1 Nancy 12/-1 2,50 1.40/10 1.38/8 1.75/4 1.17/6   5/-9 1,90 0.50/10 0.63/8 0.17/6 1.00/4
2016-10-29 Nancy 2-0 Caen 6/-9 1,91 0.55/11 0.75/8 0.17/6 1.00/5   9/-16 3,09 0.91/11 0.50/8 1.50/6 0.20/5
2016-11-05 Monaco 6-0 Nancy 33/17 4,08 2.17/12 2.00/8 2.67/6 1.67/6   8/-7 1,92 0.75/12 0.75/8 0.57/7 1.00/5
2016-11-19 Nancy 1-0 Dijon 8/-13 2,23 0.69/13 0.63/8 0.57/7 0.83/6   16/-4 2,77 1.08/13 1.25/8 1.71/7 0.33/6
2016-11-26 Montpellier 0-0 Nancy 20/-7 3,62 1.15/13 1.13/8 1.83/6 0.57/7   9/-12 2,14 0.86/14 0.88/8 0.88/8 0.83/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-04 Marseille 3-0 Nancy 13/-4 1,88 1.19/16 1.25/8 2.14/7 0.44/9   13/-8 2,13 1.00/16 1.38/8 1.11/9 0.86/7
2016-12-10 Nancy 2-0 Angers 13/-11 2,18 0.94/17 1.38/8 1.11/9 0.75/8   15/-5 2,06 1.12/17 0.75/8 1.50/8 0.78/9
2016-12-17 Toulouse 1-1 Nancy 23/5 2,28 1.56/18 1.00/8 2.33/9 0.78/9   15/-9 2,17 1.06/18 1.75/8 1.30/10 0.75/8
2016-12-21 St Etienne 0-0 Nancy 19/2 1,89 1.37/19 1.13/8 1.78/9 1.00/10   16/-9 2,16 1.05/19 1.75/8 1.30/10 0.78/9
2017-01-14 Nancy 1-0 Bastia 16/-9 2,05 1.05/20 1.50/8 1.30/10 0.80/10   17/-7 2,05 1.00/20 1.13/8 1.18/11 0.78/9
2017-01-28 Nancy 0-2 Bordeaux 17/-8 2,00 1.14/21 1.88/8 1.45/11 0.80/10   22/-7 2,32 1.32/22 1.13/8 1.64/11 1.00/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-08 Lyon 4-0 Nancy 41/12 3,04 1.61/23 1.88/8 1.75/12 1.45/11   19/-8 2,00 1.17/23 1.75/8 1.33/12 1.00/11
2017-02-11 Nancy 0-3 Montpellier 19/-12 2,08 1.13/24 1.38/8 1.33/12 0.92/12   36/-6 3,12 1.16/25 0.88/8 1.92/13 0.33/12
2017-02-18 Angers 1-0 Nancy 21/-14 2,15 1.04/26 1.00/8 1.42/12 0.71/14   19/-15 2,12 1.08/25 1.38/8 1.23/13 0.92/12
2017-02-21 Caen 1-0 Nancy 25/-24 2,85 0.96/26 0.88/8 1.54/13 0.38/13   19/-16 2,08 1.04/26 1.00/8 1.23/13 0.85/13
2017-02-25 Nancy 0-0 Toulouse 19/-17 2,04 1.00/27 0.88/8 1.23/13 0.79/14   33/5 2,18 1.36/28 1.13/8 2.00/14 0.71/14
2017-03-04 Paris SG 1-0 Nancy 55/36 2,74 2.19/27 2.50/8 2.23/13 2.14/14   19/-17 1,96 1.00/28 0.88/8 1.21/14 0.79/14
2017-03-04 PSG 1-0 Nancy 55/36 2,74 2.19/27 2.50/8 2.23/13 2.14/14   19/-18 1,93 0.97/29 0.50/8 1.21/14 0.73/15
2017-03-11 Nancy 1-2 Lille 19/-19 1,90 0.93/30 0.50/8 1.21/14 0.69/16   28/-11 2,23 1.00/30 0.88/8 1.13/15 0.87/15
2017-03-18 Nancy 2-3 Lorient 20/-20 1,94 0.90/31 0.13/8 1.13/15 0.69/16   30/-36 3,10 0.71/31 0.50/8 1.06/16 0.33/15
2017-03-31 Guingamp 1-0 Nancy 39/-1 2,55 1.32/31 0.88/8 2.00/15 0.69/16   22/-21 2,03 0.88/32 0.13/8 1.06/16 0.69/16
2017-04-08 Nancy 3-0 Rennes 22/-22 2,00 0.85/33 0.13/8 1.06/16 0.65/17   29/-10 2,06 1.21/33 1.13/8 1.76/17 0.63/16
2017-04-15 Nice 3-1 Nancy 54/26 2,48 2.15/33 2.25/8 2.50/16 1.82/17   25/-19 2,03 0.91/34 0.50/8 1.18/17 0.65/17
2017-04-21 Nancy 0-0 Marseille 26/-21 2,09 0.89/35 0.50/8 1.18/17 0.61/18   49/6 2,63 1.49/35 1.50/8 2.06/18 0.88/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 Nancy 0-3 Monaco 27/-22 2,05 0.86/37 0.50/8 1.17/18 0.58/19   99/68 3,61 2.42/36 3.00/8 2.72/18 2.11/18
2017-05-14 Dijon 2-0 Nancy 45/-19 2,87 0.87/38 0.75/8 1.26/19 0.47/19   27/-25 2,08 0.84/38 0.50/8 1.11/19 0.58/19
2017-05-20 Nancy 3-1 St Etienne 27/-27 2,08 0.82/39 0.50/8 1.11/19 0.55/20   41/-4 2,21 1.31/39 0.75/8 1.50/20 1.11/19