SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Clermont' OR Away='Clermont') 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
2017-07-28 Paris FC 0-0 Clermont 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
2017-08-04 Clermont 2-0 Tours 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2017-08-11 Valenciennes 0-0 Clermont 2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1   2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1
2017-08-18 Clermont 0-2 Lorient 2/2 0,67 1.67/3 1.67/3 3.00/1 1.00/2   4/3 1,67 1.67/3 1.67/3 2.00/2 1.00/1
2017-08-25 Quevilly Rouen 0-2 Clermont 3/-4 2,50 0.50/4 0.50/4 0.50/2 0.50/2   2/0 1,00 1.25/4 1.25/4 1.50/2 1.00/2
2017-09-08 Clermont 4-1 Bourg en Bresse 4/2 1,20 1.60/5 1.60/5 1.50/2 1.67/3   7/-1 3,00 1.20/5 1.20/5 1.50/2 1.00/3
2017-09-15 GFC Ajaccio 2-1 Clermont 2/-2 1,00 1.00/6 1.00/6 1.33/3 0.67/3   8/5 1,83 1.83/6 1.83/6 2.00/3 1.67/3
2017-09-19 Chateauroux 0-2 Clermont 12/0 3,43 1.71/7 1.71/7 2.00/3 1.50/4   9/4 2,00 1.57/7 1.57/7 2.00/3 1.25/4
2017-09-25 Clermont 1-0 Lens 11/6 2,00 1.75/8 1.75/8 2.00/3 1.60/5   9/-7 3,13 0.38/8 0.38/8 0.75/4 0.00/4
2017-09-30 Reims 1-0 Clermont 19/13 2,78 2.33/9 2.25/8 2.25/4 2.40/5   12/7 1,89 1.89/9 2.00/8 2.25/4 1.60/5
2017-10-14 Clermont 3-0 Le Havre 12/6 1,80 1.70/10 1.63/8 2.25/4 1.33/6   17/9 2,50 1.90/10 1.63/8 2.60/5 1.20/5
2017-10-20 Nancy 2-2 Clermont 14/1 2,45 1.18/11 1.38/8 2.20/5 0.33/6   15/9 1,91 1.82/11 1.88/8 2.40/5 1.33/6
2017-10-28 Clermont 1-1 AC Ajaccio 17/9 2,08 1.75/12 2.00/8 2.40/5 1.29/7   22/13 2,58 2.17/12 2.25/8 2.50/6 1.83/6
2017-11-03 Niort 1-1 Clermont 16/0 2,46 1.38/13 1.25/8 1.86/7 0.83/6   18/9 2,08 1.69/13 1.75/8 2.17/6 1.29/7
2017-11-17 Clermont 1-0 Auxerre 19/9 2,07 1.64/14 1.50/8 2.17/6 1.25/8   14/-5 2,36 1.29/14 1.75/8 1.86/7 0.71/7
2017-11-24 Orleans 1-2 Clermont 22/0 2,93 1.27/15 0.63/8 1.50/8 1.00/7   20/10 2,00 1.73/15 1.88/8 2.29/7 1.25/8
2017-11-28 Clermont 1-2 Brest 22/11 2,06 1.81/16 1.88/8 2.29/7 1.44/9   20/0 2,50 1.56/16 1.13/8 1.50/8 1.63/8
2017-12-11 Nimes 3-1 Clermont 37/20 3,18 2.00/17 2.25/8 2.11/9 1.88/8   23/10 2,12 1.71/17 1.50/8 2.00/8 1.44/9
2017-12-15 Clermont 0-2 Sochaux 24/8 2,22 1.61/18 1.50/8 2.00/8 1.30/10   26/-6 3,22 1.50/18 2.00/8 2.00/9 1.00/9
2018-01-12 Tours 0-0 Clermont 10/-29 2,58 0.26/19 0.38/8 0.33/9 0.20/10   24/6 2,21 1.53/19 1.13/8 1.78/9 1.30/10
2018-01-16 Clermont 3-0 Valenciennes 24/6 2,10 1.50/20 1.13/8 1.78/9 1.27/11   27/-6 3,00 1.25/20 1.00/8 1.45/11 1.00/9
2018-01-19 Lorient 1-1 Clermont 36/11 2,90 1.71/21 1.38/8 2.18/11 1.20/10   27/9 2,14 1.57/21 1.38/8 1.90/10 1.27/11
2018-01-26 Clermont 1-1 Quevilly Rouen 28/9 2,14 1.55/22 1.38/8 1.90/10 1.25/12   24/-15 2,86 0.82/22 1.63/8 0.91/11 0.73/11
2018-02-02 Bourg en Bresse 0-2 Clermont 29/-22 3,48 0.87/23 0.88/8 1.27/11 0.50/12   29/9 2,13 1.52/23 1.13/8 1.82/11 1.25/12
2018-02-09 Clermont 1-0 GFC Ajaccio 31/11 2,13 1.58/24 1.13/8 1.82/11 1.38/13   20/-13 2,21 1.25/24 0.88/8 1.58/12 0.92/12
2018-02-16 Clermont 1-1 Chateauroux 32/12 2,08 1.64/25 1.50/8 1.92/12 1.38/13   34/1 2,68 1.64/25 2.13/8 1.83/12 1.46/13
2018-02-23 Lens 0-1 Clermont 33/4 2,38 1.15/26 1.50/8 1.33/12 1.00/14   33/12 2,08 1.62/26 1.63/8 1.85/13 1.38/13
2018-03-02 Clermont 2-1 Reims 34/13 2,04 1.67/27 2.00/8 1.85/13 1.50/14   48/33 2,33 2.33/27 2.38/8 2.38/13 2.29/14
2018-03-09 Le Havre 2-1 Clermont 36/11 2,18 1.57/28 1.13/8 2.23/13 1.00/15   36/14 2,07 1.71/28 2.25/8 1.93/14 1.50/14
2018-03-16 Clermont 2-0 Nancy 37/13 2,10 1.66/29 1.88/8 1.93/14 1.40/15   29/-11 2,38 0.97/29 0.88/8 1.20/15 0.71/14
2018-03-30 AC Ajaccio 2-1 Clermont 51/15 2,90 1.80/30 2.00/8 2.27/15 1.33/15   39/15 2,10 1.70/30 2.13/8 2.00/15 1.40/15
2018-04-06 Clermont 2-2 Niort 40/14 2,13 1.65/31 2.00/8 2.00/15 1.31/16   35/-12 2,65 1.16/31 1.25/8 1.19/16 1.13/15
2018-04-13 Auxerre 1-2 Clermont 44/1 2,72 1.34/32 1.63/8 1.63/16 1.06/16   42/14 2,19 1.63/32 1.75/8 1.94/16 1.31/16
2018-04-20 Clermont 4-2 Orleans 44/15 2,21 1.67/33 1.75/8 1.94/16 1.41/17   44/-7 2,88 1.27/33 1.13/8 1.35/17 1.19/16
2018-04-24 Brest 1-0 Clermont 49/10 2,59 1.62/34 1.75/8 1.53/17 1.71/17   48/17 2,32 1.71/34 2.00/8 2.00/17 1.41/17
2018-04-28 Clermont 1-1 Nimes 48/16 2,29 1.66/35 1.63/8 2.00/17 1.33/18   68/34 2,91 1.94/35 2.38/8 2.00/18 1.88/17
2018-05-04 Sochaux 1-3 Clermont 49/-8 2,94 1.47/36 1.25/8 1.78/18 1.17/18   49/16 2,28 1.64/36 1.38/8 1.94/18 1.33/18
2018-05-11 Clermont 2-2 Paris FC 52/18 2,32 1.68/37 1.75/8 1.94/18 1.42/19   44/10 2,11 1.62/37 1.38/8 1.84/19 1.39/18