SELECT * FROM 1_Kampe WHERE LigaID = '84' 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
2012-08-11 Nancy 1-0 Brest 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
2012-08-17 Lille 1-1 Nancy 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-08-25 Nancy 0-1 Toulouse 2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1   3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1
2012-09-01 Lorient 3-0 Nancy 6/1 3,67 1.67/3 1.67/3 3.00/1 1.00/2   2/0 1,33 1.33/3 1.33/3 1.50/2 1.00/1
2012-09-16 Nancy 0-1 Marseille 2/-3 1,75 1.00/4 1.00/4 1.50/2 0.50/2   7/6 2,00 3.00/4 3.00/4 3.00/2 3.00/2
2012-09-22 Reims 2-0 Nancy 6/1 2,20 1.40/5 1.40/5 2.00/3 0.50/2   2/-4 1,60 0.80/5 0.80/5 1.00/3 0.50/2
2012-09-29 Nancy 0-2 Montpellier 2/-6 1,67 0.67/6 0.67/6 1.00/3 0.33/3   7/-2 2,67 0.83/6 0.83/6 0.67/3 1.00/3
2012-10-05 St Etienne 4-0 Nancy 10/4 2,29 1.14/7 1.14/7 1.00/4 1.33/3   2/-8 1,71 0.57/7 0.57/7 0.75/4 0.33/3
2012-10-20 Nancy 1-1 Sochaux 2/-12 2,00 0.50/8 0.50/8 0.75/4 0.25/4   7/-6 2,50 0.75/8 0.75/8 0.75/4 0.75/4
2012-10-27 Nancy 0-1 PSG 3/-12 2,00 0.56/9 0.25/8 0.80/5 0.25/4   15/10 2,22 2.11/9 2.25/8 2.20/5 2.00/4
2012-11-03 Nice 2-1 Nancy 13/-3 2,90 0.90/10 1.00/8 1.20/5 0.60/5   3/-13 1,90 0.50/10 0.13/8 0.67/6 0.25/4
2012-11-09 Nancy 1-3 Rennes 4/-14 2,00 0.45/11 0.13/8 0.67/6 0.20/5   13/-1 2,45 1.45/11 1.63/8 2.00/6 0.80/5
2012-11-17 Troyes 3-3 Nancy 11/-11 2,75 0.58/12 0.75/8 1.00/6 0.17/6   5/-16 2,17 0.42/12 0.13/8 0.57/7 0.20/5
2012-11-24 Nancy 1-1 AC Ajaccio 8/-16 2,46 0.46/13 0.25/8 0.57/7 0.33/6   14/-4 2,46 1.23/13 1.13/8 1.33/6 1.14/7
2012-12-01 Thonon-Evian 1-1 Nancy 16/-6 2,71 1.07/14 1.38/8 0.86/7 1.29/7   9/-16 2,43 0.50/14 0.38/8 0.63/8 0.33/6
2012-12-08 Nancy 1-1 Valenciennes 10/-16 2,40 0.53/15 0.50/8 0.63/8 0.43/7   28/12 2,93 1.67/15 1.75/8 2.25/8 1.00/7
2012-12-12 Lyon 1-1 Nancy 29/14 2,75 2.13/16 2.38/8 2.63/8 1.63/8   11/-16 2,38 0.56/16 0.63/8 0.67/9 0.43/7
2012-12-16 Nancy 1-1 Bordeaux 12/-16 2,35 0.59/17 0.63/8 0.67/9 0.50/8   20/7 1,94 1.59/17 1.50/8 1.75/8 1.44/9
2012-12-22 Bastia 4-2 Nancy 22/-17 3,39 1.06/18 0.63/8 1.50/8 0.70/10   13/-16 2,33 0.61/18 0.75/8 0.70/10 0.50/8
2013-01-12 Nancy 2-2 Lille 15/-18 2,53 0.58/19 0.75/8 0.70/10 0.44/9   24/6 2,21 1.53/19 1.50/8 2.00/9 1.10/10
2013-01-19 Toulouse 2-1 Nancy 27/5 2,45 1.35/20 1.00/8 1.60/10 1.10/10   17/-18 2,60 0.60/20 0.88/8 0.73/11 0.44/9
2013-01-26 Nancy 2-1 Lorient 18/-19 2,62 0.57/21 0.75/8 0.73/11 0.40/10   35/2 3,24 1.62/21 2.00/8 2.00/11 1.20/10
2013-02-03 Marseille 0-1 Nancy 30/3 2,59 1.91/22 2.00/8 2.00/10 1.83/12   20/-18 2,64 0.68/22 1.00/8 0.92/12 0.40/10
2013-02-09 Nancy 1-2 Reims 21/-17 2,57 0.78/23 1.25/8 0.92/12 0.64/11   19/-8 2,00 0.87/23 0.50/8 1.42/12 0.27/11
2013-02-16 Montpellier 1-0 Nancy 39/7 2,96 1.46/24 1.88/8 2.00/12 0.92/12   22/-18 2,58 0.75/24 1.13/8 0.85/13 0.64/11
2013-02-23 Nancy 0-3 St Etienne 22/-19 2,52 0.72/25 1.00/8 0.85/13 0.58/12   37/18 2,24 1.64/25 1.75/8 1.77/13 1.50/12
2013-03-02 Sochaux 1-2 Nancy 27/-11 2,50 1.04/26 1.38/8 1.31/13 0.77/13   22/-22 2,54 0.69/26 0.88/8 0.79/14 0.58/12
2013-03-09 PSG 2-1 Nancy 49/32 2,44 2.00/27 2.00/8 2.14/14 1.85/13   24/-21 2,56 0.78/27 1.25/8 0.79/14 0.77/13
2013-03-17 Nancy 1-0 Nice 25/-22 2,57 0.75/28 1.13/8 0.79/14 0.71/14   41/9 2,61 1.71/28 2.00/8 2.07/15 1.31/13
2013-03-30 Rennes 0-2 Nancy 41/2 2,76 1.45/29 0.88/8 1.57/14 1.33/15   26/-21 2,52 0.83/29 1.50/8 0.93/15 0.71/14
2013-04-06 Nancy 1-0 Troyes 28/-19 2,50 0.90/30 1.50/8 0.93/15 0.87/15   36/-17 2,97 0.83/30 1.13/8 1.25/16 0.36/14
2013-04-13 AC Ajaccio 1-1 Nancy 32/-8 2,32 1.16/31 1.13/8 1.47/15 0.88/16   29/-18 2,45 0.97/31 1.50/8 1.06/16 0.87/15
2013-04-21 Nancy 3-1 Thonon-Evian 30/-18 2,44 0.97/32 1.63/8 1.06/16 0.88/16   38/-8 2,63 1.06/32 1.38/8 1.19/16 0.94/16
2013-04-27 Valenciennes 0-0 Nancy 42/-6 2,73 1.21/33 0.88/8 1.63/16 0.82/17   33/-16 2,48 1.03/33 2.00/8 1.18/17 0.88/16
2013-05-05 Nancy 0-3 Lyon 33/-16 2,41 1.03/34 2.13/8 1.18/17 0.88/17   55/19 2,68 1.76/34 1.13/8 2.00/17 1.53/17
2013-05-11 Bordeaux 3-2 Nancy 35/5 1,86 1.40/35 1.38/8 1.53/17 1.28/18   33/-19 2,43 1.00/35 1.75/8 1.11/18 0.88/17
2013-05-18 Nancy 1-2 Bastia 35/-20 2,50 0.97/36 1.75/8 1.11/18 0.83/18   48/-17 3,14 1.19/36 1.63/8 1.61/18 0.78/18
2013-05-26 Brest 1-2 Nancy 31/-29 2,46 0.78/37 0.00/8 1.00/18 0.58/19   36/-21 2,51 0.95/37 1.38/8 1.05/19 0.83/18
2018-10-21 Nancy 0-1 Evian TG 38/-20 2,53 1.00/38 1.38/8 1.05/19 0.95/19   12/0 1,00 1.50/24 1.13/8 0.00/12 3.00/12
2018-10-21 Nancy 0-1 Paris SG 38/-21 2,49 0.97/39 1.13/8 1.00/20 0.95/19   1/1 1,00 3.00/1 1.50/8 0.00/0 3.00/1
2018-10-21 Evian TG 0-1 Nancy 3/2 1,00 2.25/4 1.13/8 0.00/1 3.00/3   38/-22 2,45 0.95/40 1.13/8 0.95/21 0.95/19
2018-10-21 Paris SG 0-1 Nancy 18/3 1,10 1.60/30 1.50/8 0.00/14 3.00/16   39/-21 2,41 1.00/41 1.13/8 0.95/21 1.05/20