SELECT * FROM 1_Kampe WHERE LigaID = '90' 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
2016-07-29 Valenciennes 2-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
2016-08-05 Clermont 0-0 Red Star 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Clermont 1-2 Sochaux 0/-2 1,00 0.50/2 0.50/2 1.00/1 0.00/1   3/2 2,00 2.00/2 2.00/2 1.00/1 3.00/1
2016-08-19 Auxerre 0-1 Clermont 5/1 3,00 1.33/3 1.33/3 0.00/1 2.00/2   1/-3 1,67 0.33/3 0.33/3 0.50/2 0.00/1
2016-08-26 Clermont 2-1 AC Ajaccio 2/-2 1,50 1.00/4 1.00/4 0.50/2 1.50/2   5/1 2,25 1.75/4 1.75/4 3.00/2 0.50/2
2016-09-09 Brest 0-2 Clermont 10/5 3,00 2.20/5 2.20/5 3.00/2 1.67/3   4/-1 1,80 1.40/5 1.40/5 1.33/3 1.50/2
2016-09-16 Clermont 1-1 Lens 6/1 1,83 1.67/6 1.67/6 1.33/3 2.00/3   6/1 1,83 1.17/6 1.17/6 0.67/3 1.67/3
2016-09-20 Reims 2-1 Clermont 8/4 1,71 1.86/7 1.86/7 3.00/3 1.00/4   7/1 1,86 1.57/7 1.57/7 1.25/4 2.00/3
2016-09-23 Clermont 0-0 Strasbourg 8/0 2,00 1.38/8 1.38/8 1.25/4 1.50/4   9/3 1,88 1.63/8 1.63/8 2.00/4 1.25/4
2016-09-30 Laval 1-1 Clermont 5/-3 1,44 0.78/9 0.75/8 1.25/4 0.40/5   8/0 1,78 1.33/9 1.50/8 1.20/5 1.50/4
2016-10-14 Clermont 1-3 Le Havre 9/0 1,80 1.30/10 1.50/8 1.20/5 1.40/5   11/1 2,10 1.60/10 1.25/8 1.60/5 1.60/5
2016-10-21 Niort 2-1 Clermont 9/-7 2,27 1.00/11 1.13/8 1.00/5 1.00/6   10/-2 2,00 1.18/11 1.50/8 1.00/6 1.40/5
2016-10-29 Clermont 1-0 Amiens 11/-3 2,08 1.08/12 1.13/8 1.00/6 1.17/6   17/7 2,25 1.83/12 1.88/8 1.50/6 2.17/6
2016-11-04 Nimes 1-1 Clermont 19/3 2,69 1.38/13 2.00/8 0.67/6 2.00/7   12/-2 2,00 1.23/13 1.13/8 1.29/7 1.17/6
2016-11-18 Clermont 3-1 GFC Ajaccio 13/-2 2,00 1.21/14 0.88/8 1.29/7 1.14/7   13/2 1,71 1.43/14 1.38/8 1.43/7 1.43/7
2016-11-25 Troyes 1-0 Clermont 21/6 2,40 1.87/15 2.50/8 2.13/8 1.57/7   16/0 2,13 1.33/15 1.13/8 1.50/8 1.14/7
2016-11-29 Clermont 0-0 Tours 16/-1 2,06 1.25/16 1.13/8 1.50/8 1.00/8   19/-10 3,00 0.81/16 0.88/8 0.89/9 0.71/7
2016-12-09 Bourg en Bresse 1-1 Clermont 21/-1 2,53 1.18/17 1.25/8 1.44/9 0.88/8   16/-1 1,94 1.24/17 1.13/8 1.44/9 1.00/8
2016-12-16 Clermont 3-0 Orleans 17/-1 1,94 1.22/18 1.13/8 1.44/9 1.00/9   15/-8 2,11 0.83/18 0.88/8 1.30/10 0.25/8
2017-01-13 Red Star 1-3 Clermont 16/-9 2,16 1.00/19 1.00/8 1.30/10 0.67/9   20/2 2,00 1.32/19 1.50/8 1.60/10 1.00/9
2017-01-20 Sochaux 3-3 Clermont 21/5 1,85 1.60/20 1.63/8 1.70/10 1.50/10   23/4 2,10 1.40/20 1.88/8 1.60/10 1.20/10
2017-01-27 Clermont 0-1 Auxerre 26/4 2,29 1.38/21 1.63/8 1.60/10 1.18/11   14/-13 1,95 0.76/21 0.88/8 0.90/10 0.64/11
2017-02-03 AC Ajaccio 2-1 Clermont 25/-4 2,45 1.23/22 1.38/8 1.82/11 0.64/11   26/3 2,23 1.32/22 1.50/8 1.45/11 1.18/11
2017-02-07 Clermont 1-1 Brest 27/2 2,26 1.26/23 1.13/8 1.45/11 1.08/12   30/8 2,26 1.91/23 2.00/8 1.83/12 2.00/11
2017-02-13 Lens 3-1 Clermont 30/5 2,29 1.54/24 1.38/8 1.55/11 1.54/13   28/2 2,25 1.25/24 1.25/8 1.42/12 1.08/12
2017-02-17 Clermont 0-1 Reims 29/0 2,32 1.20/25 1.13/8 1.42/12 1.00/13   26/5 1,88 1.56/25 1.25/8 2.17/12 1.00/13
2017-02-24 Strasbourg 0-2 Clermont 40/6 2,85 1.65/26 1.75/8 2.23/13 1.08/13   29/-1 2,27 1.15/26 1.00/8 1.31/13 1.00/13
2017-03-03 Clermont 1-1 Laval 31/1 2,26 1.22/27 1.00/8 1.31/13 1.14/14   23/-8 2,00 0.89/27 1.00/8 0.92/13 0.86/14
2017-03-10 Le Havre 0-1 Clermont 27/3 1,82 1.39/28 1.38/8 1.46/13 1.33/15   32/1 2,25 1.21/28 0.75/8 1.29/14 1.14/14
2017-03-17 Clermont 0-1 Niort 33/2 2,21 1.28/29 1.00/8 1.29/14 1.27/15   37/-4 2,69 1.38/29 1.38/8 1.73/15 1.00/14
2017-03-31 Amiens 0-1 Clermont 42/11 2,43 1.60/30 1.63/8 1.67/15 1.53/15   33/1 2,17 1.23/30 1.00/8 1.20/15 1.27/15
2017-04-07 Clermont 2-3 Nimes 34/2 2,13 1.29/31 1.38/8 1.20/15 1.38/16   44/12 2,45 1.55/31 1.88/8 1.31/16 1.80/15
2017-04-14 GFC Ajaccio 4-4 Clermont 38/3 2,28 1.38/32 1.50/8 1.56/16 1.19/16   36/1 2,22 1.25/32 1.25/8 1.13/16 1.38/16
2017-04-21 Clermont 1-1 Troyes 40/1 2,39 1.24/33 1.38/8 1.13/16 1.35/17   49/11 2,64 1.61/33 1.75/8 2.18/17 1.00/16
2017-04-28 Tours 3-0 Clermont 47/-5 2,91 1.09/34 2.00/8 1.18/17 1.00/17   41/1 2,38 1.24/34 1.50/8 1.12/17 1.35/17
2017-05-05 Clermont 2-3 Bourg en Bresse 41/-2 2,40 1.20/35 1.13/8 1.12/17 1.28/18   44/-8 2,74 1.17/35 0.38/8 1.33/18 1.00/17
2017-05-12 Orleans 2-2 Clermont 38/-10 2,39 1.14/36 1.25/8 1.67/18 0.61/18   43/-3 2,47 1.17/36 1.00/8 1.06/18 1.28/18
2017-05-19 Clermont 1-0 Valenciennes 45/-3 2,51 1.16/37 0.75/8 1.06/18 1.26/19   44/1 2,35 1.22/37 1.38/8 1.53/19 0.89/18