SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Nice' OR Away='Nice') 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 Nice 1-0 Rennes 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 Angers 0-1 Nice 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-27 Nice 1-1 Lille 2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1   3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1
2016-09-11 Nice 3-2 Marseille 3/2 1,33 2.33/3 2.33/3 2.00/2 3.00/1   3/1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-18 Montpellier 1-1 Nice 4/-1 2,25 1.25/4 1.25/4 2.00/2 0.50/2   6/3 2,25 2.50/4 2.50/4 2.33/3 3.00/1
2016-09-21 Nice 4-0 Monaco 7/3 2,20 2.20/5 2.20/5 2.33/3 2.00/2   16/11 3,50 2.67/6 2.67/6 2.50/4 3.00/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-02 Nice 2-1 Lorient 12/8 2,29 2.43/7 2.43/7 2.50/4 2.33/3   4/-7 2,14 0.86/7 0.86/7 1.50/4 0.00/3
2016-10-14 Nice 2-0 Lyon 14/9 2,38 2.50/8 2.50/8 2.60/5 2.33/3   15/6 3,00 1.63/8 1.63/8 2.25/4 1.00/4
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 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-06 Caen 1-0 Nice 9/-18 3,00 0.83/12 0.50/8 1.50/6 0.17/6   24/16 2,91 2.64/11 2.75/8 2.71/7 2.50/4
2016-11-20 St Etienne 0-1 Nice 15/4 2,00 1.46/13 1.63/8 2.00/6 1.00/7   24/15 2,75 2.42/12 2.38/8 2.71/7 2.00/5
2016-11-27 Nice 1-1 Bastia 25/16 2,62 2.46/13 2.63/8 2.71/7 2.17/6   10/-4 1,71 0.86/14 0.75/8 1.13/8 0.50/6
2016-11-30 Guingamp 0-1 Nice 19/5 2,36 1.64/14 1.50/8 2.33/6 1.13/8   26/16 2,57 2.36/14 2.38/8 2.50/8 2.17/6
2016-12-04 Nice 3-0 Toulouse 27/17 2,47 2.40/15 2.38/8 2.50/8 2.29/7   20/7 2,06 1.56/16 1.00/8 2.25/8 0.88/8
2016-12-11 Paris SG 2-2 Nice 30/19 2,56 2.19/16 2.38/8 2.50/8 1.88/8   30/20 2,50 2.44/16 2.38/8 2.56/9 2.29/7
2016-12-11 PSG 2-2 Nice 30/19 2,56 2.19/16 2.38/8 2.50/8 1.88/8   32/20 2,59 2.35/17 1.88/8 2.56/9 2.13/8
2016-12-18 Nice 2-1 Dijon 34/20 2,67 2.28/18 1.88/8 2.56/9 2.00/9   23/-7 2,94 0.89/18 0.88/8 1.44/9 0.33/9
2016-12-21 Bordeaux 0-0 Nice 20/-8 2,53 1.26/19 1.13/8 1.56/9 1.00/10   36/21 2,68 2.32/19 1.88/8 2.60/10 2.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-20 Bastia 1-1 Nice 17/-8 2,00 0.95/21 1.13/8 1.18/11 0.70/10   36/21 2,43 2.19/21 1.75/8 2.45/11 1.90/10
2017-01-29 Nice 3-1 Guingamp 37/21 2,41 2.14/22 1.75/8 2.45/11 1.82/11   29/5 2,41 1.55/22 1.38/8 2.18/11 0.91/11
2017-02-04 Monaco 3-0 Nice 69/45 3,88 2.21/24 2.13/8 2.58/12 1.83/12   40/23 2,48 2.17/23 1.75/8 2.50/12 1.82/11
2017-02-08 Nice 1-0 St Etienne 40/20 2,50 2.08/24 1.38/8 2.50/12 1.67/12   27/8 1,92 1.54/24 1.75/8 1.92/12 1.17/12
2017-02-12 Rennes 2-2 Nice 23/-9 2,12 1.23/26 0.63/8 1.85/13 0.62/13   41/21 2,44 2.12/25 1.63/8 2.54/13 1.67/12
2017-02-18 Lorient 0-1 Nice 27/-29 3,19 0.85/26 0.88/8 1.42/12 0.36/14   43/21 2,50 2.08/26 1.63/8 2.54/13 1.62/13
2017-02-24 Nice 2-1 Montpellier 44/22 2,44 2.11/27 1.63/8 2.54/13 1.71/14   41/-2 3,11 1.30/27 1.25/8 2.00/14 0.54/13
2017-03-04 Dijon 0-1 Nice 38/-12 3,03 0.93/29 0.88/8 1.43/14 0.47/15   46/23 2,46 2.14/28 1.88/8 2.57/14 1.71/14
2017-03-10 Nice 2-2 Caen 47/24 2,41 2.17/29 2.13/8 2.57/14 1.80/15   29/-23 2,79 1.07/29 1.25/8 1.53/15 0.57/14
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 Nice 2-1 Bordeaux 50/24 2,45 2.10/31 1.88/8 2.47/15 1.75/16   42/0 2,63 1.44/32 1.63/8 1.53/17 1.33/15
2017-04-07 Lille 1-2 Nice 31/-9 2,15 1.12/33 1.38/8 1.13/16 1.12/17   52/25 2,47 2.13/32 2.25/8 2.50/16 1.75/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-23 Toulouse 1-1 Nice 36/1 2,03 1.29/35 1.00/8 1.82/17 0.78/18   57/28 2,53 2.18/34 2.50/8 2.53/17 1.82/17
2017-04-30 Nice 3-1 PSG 58/28 2,51 2.14/35 2.25/8 2.53/17 1.78/18   71/48 2,76 2.35/34 3.00/8 2.41/17 2.29/17
2017-04-30 Nice 3-1 Paris SG 61/30 2,56 2.17/36 2.25/8 2.56/18 1.78/18   71/48 2,76 2.35/34 3.00/8 2.41/17 2.29/17
2017-05-07 Marseille 2-1 Nice 54/10 2,65 1.51/37 2.00/8 2.06/18 1.00/19   64/32 2,59 2.19/37 2.25/8 2.58/19 1.78/18
2017-05-14 Nice 0-2 Angers 65/31 2,61 2.13/38 2.13/8 2.58/19 1.68/19   36/-17 2,34 1.05/38 0.50/8 1.37/19 0.74/19
2017-05-20 Lyon 3-3 Nice 79/30 3,28 1.69/39 2.00/8 1.89/19 1.50/20   65/29 2,59 2.08/39 2.00/8 2.45/20 1.68/19