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   13/9 3,40 2.60/5 2.60/5 2.33/3 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/-7 2,78 1.44/9 1.25/8 1.50/4 1.40/5   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/-12 2,73 0.91/11 0.50/8 1.80/5 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 14/4 2,00 1.50/12 1.63/8 2.00/6 1.00/6   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/-3 1,77 0.92/13 0.75/8 1.29/7 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   18/5 2,07 1.47/15 1.00/8 2.14/7 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-18 Nice 2-1 Dijon 32/20 2,59 2.35/17 2.13/8 2.56/9 2.13/8   23/-4 2,94 0.94/17 0.88/8 1.44/9 0.38/8
2016-12-21 Bordeaux 0-0 Nice 20/-6 2,56 1.33/18 1.13/8 1.56/9 1.11/9   34/21 2,61 2.39/18 2.13/8 2.60/10 2.13/8
2017-01-15 Nice 0-0 Metz 34/21 2,47 2.32/19 1.88/8 2.60/10 2.00/9   18/-18 3,00 1.06/18 0.75/8 1.13/8 1.00/10
2017-01-20 Bastia 1-1 Nice 17/-7 2,05 1.00/20 1.13/8 1.30/10 0.70/10   34/21 2,35 2.25/20 2.00/8 2.45/11 2.00/9
2017-01-29 Nice 3-1 Guingamp 35/21 2,33 2.19/21 1.75/8 2.45/11 1.90/10   27/4 2,38 1.48/21 1.13/8 2.10/10 0.91/11
2017-02-04 Monaco 3-0 Nice 65/43 3,95 2.23/22 2.13/8 2.55/11 1.91/11   38/23 2,41 2.23/22 2.00/8 2.50/12 1.90/10
2017-02-08 Nice 1-0 St Etienne 38/20 2,43 2.13/23 1.63/8 2.50/12 1.73/11   26/8 1,91 1.57/23 1.75/8 1.92/12 1.18/11
2017-02-12 Rennes 2-2 Nice 23/-4 2,08 1.33/24 0.63/8 2.00/12 0.67/12   39/21 2,38 2.17/24 1.63/8 2.54/13 1.73/11
2017-02-18 Lorient 0-1 Nice 27/-24 3,12 0.88/25 1.25/8 1.42/12 0.38/13   41/21 2,44 2.12/25 1.63/8 2.54/13 1.67/12
2017-02-24 Nice 2-1 Montpellier 42/22 2,38 2.15/26 1.63/8 2.54/13 1.77/13   38/-5 3,12 1.23/26 1.25/8 1.92/13 0.54/13
2017-03-04 Dijon 0-1 Nice 37/-7 3,00 1.00/27 1.00/8 1.54/13 0.50/14   44/23 2,41 2.19/27 1.88/8 2.57/14 1.77/13
2017-03-10 Nice 2-2 Caen 45/24 2,36 2.21/28 2.13/8 2.57/14 1.86/14   29/-17 2,68 1.11/28 1.25/8 1.64/14 0.57/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 Nice 2-1 Bordeaux 48/24 2,40 2.13/30 1.88/8 2.47/15 1.80/15   42/5 2,63 1.53/30 1.75/8 1.63/16 1.43/14
2017-04-07 Lille 1-2 Nice 30/-7 2,16 1.19/31 1.38/8 1.20/15 1.19/16   50/25 2,42 2.16/31 2.25/8 2.50/16 1.80/15
2017-04-15 Nice 3-1 Nancy 52/26 2,44 2.19/32 2.25/8 2.50/16 1.88/16   24/-17 2,03 0.97/32 0.50/8 1.25/16 0.69/16
2017-04-23 Toulouse 1-1 Nice 34/-1 2,09 1.24/33 1.00/8 1.75/16 0.76/17   55/28 2,48 2.21/33 2.50/8 2.53/17 1.88/16
2017-04-30 Nice 3-1 Paris SG 56/28 2,47 2.18/34 2.25/8 2.53/17 1.82/17   71/48 2,76 2.35/34 3.00/8 2.41/17 2.29/17
2017-05-07 Marseille 2-1 Nice 53/14 2,63 1.57/35 2.00/8 2.18/17 1.00/18   59/30 2,51 2.20/35 2.25/8 2.56/18 1.82/17
2017-05-14 Nice 0-2 Angers 60/29 2,53 2.14/36 1.88/8 2.56/18 1.72/18   36/-13 2,36 1.11/36 0.50/8 1.44/18 0.78/18
2017-05-20 Lyon 3-3 Nice 77/32 3,30 1.78/37 2.00/8 2.00/18 1.58/19   60/27 2,51 2.08/37 1.75/8 2.42/19 1.72/18