SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Caen' OR Away='Caen') 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-13 Caen 3-2 Lorient 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-19 Lyon 2-0 Caen 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-27 Caen 2-0 Bastia 3/-1 3,50 1.50/2 1.50/2 3.00/1 0.00/1   3/1 1,67 1.00/3 1.00/3 0.00/2 3.00/1
2016-09-11 Rennes 2-0 Caen 3/1 1,67 1.33/3 1.33/3 3.00/1 0.50/2   5/1 3,00 2.00/3 2.00/3 3.00/2 0.00/1
2016-09-16 Caen 0-6 PSG 5/-1 2,75 1.50/4 1.50/4 3.00/2 0.00/2   6/2 2,50 1.75/4 1.75/4 2.00/2 1.50/2
2016-09-16 Caen 0-6 Paris SG 5/-7 3,40 1.20/5 1.00/6 2.00/3 0.00/2   6/2 2,50 1.75/4 1.75/4 2.00/2 1.50/2
2016-09-21 Angers 2-1 Caen 4/-1 1,80 1.20/5 1.20/5 1.50/2 1.00/3   5/-13 3,83 1.00/6 1.00/6 1.50/4 0.00/2
2016-09-24 Bordeaux 0-0 Caen 11/3 3,17 2.00/6 2.00/6 2.00/3 2.00/3   6/-14 3,71 0.86/7 0.86/7 1.50/4 0.00/3
2016-10-01 Caen 1-0 Toulouse 6/-14 3,25 0.88/8 0.88/8 1.50/4 0.25/4   13/8 2,25 2.13/8 2.13/8 3.00/4 1.25/4
2016-10-15 Montpellier 3-2 Caen 9/-6 3,00 0.88/8 0.88/8 1.25/4 0.50/4   7/-13 3,00 1.11/9 0.88/8 1.80/5 0.25/4
2016-10-23 Caen 0-2 St Etienne 9/-14 3,20 1.00/10 0.88/8 1.80/5 0.20/5   12/2 2,20 1.40/10 1.38/8 2.20/5 0.60/5
2016-10-29 Nancy 2-0 Caen 6/-9 1,91 0.55/11 0.75/8 0.17/6 1.00/5   9/-16 3,09 0.91/11 0.50/8 1.50/6 0.20/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 Marseille 1-0 Caen 12/-1 1,92 1.15/13 1.25/8 2.00/6 0.43/7   10/-17 2,85 1.00/13 0.88/8 1.71/7 0.17/6
2016-11-26 Caen 1-1 Guingamp 10/-18 2,71 0.93/14 0.88/8 1.71/7 0.14/7   18/5 2,38 1.69/13 1.75/8 2.33/6 1.14/7
2016-11-29 Lille 4-2 Caen 10/-10 2,00 0.73/15 0.88/8 1.13/8 0.29/7   11/-18 2,67 0.93/15 1.00/8 1.63/8 0.14/7
2016-12-02 Caen 3-3 Dijon 13/-20 2,88 0.88/16 0.88/8 1.63/8 0.13/8   19/-6 2,75 0.94/16 1.00/8 1.63/8 0.25/8
2016-12-18 Caen 3-0 Metz 16/-20 3,06 0.88/17 0.63/8 1.56/9 0.13/8   16/-18 2,94 1.06/17 0.63/8 1.14/7 1.00/10
2016-12-21 Monaco 2-1 Caen 57/37 4,05 2.21/19 2.13/8 2.50/10 1.89/9   19/-17 3,06 1.00/18 1.00/8 1.70/10 0.13/8
2017-01-15 Caen 3-2 Lyon 20/-18 3,05 0.95/19 1.00/8 1.70/10 0.11/9   35/14 2,95 1.79/19 2.25/8 1.80/10 1.78/9
2017-01-18 Nantes 1-0 Caen 13/-15 2,05 1.10/20 1.25/8 1.00/9 1.18/11   23/-17 3,15 1.05/20 1.38/8 1.82/11 0.11/9
2017-01-28 Bastia 1-1 Caen 18/-8 2,00 0.95/22 1.13/8 1.17/12 0.70/10   23/-18 3,05 1.00/21 1.00/8 1.82/11 0.10/10
2017-02-04 Guingamp 0-1 Caen 30/3 2,48 1.48/23 1.38/8 2.18/11 0.83/12   24/-18 3,00 1.00/22 1.13/8 1.82/11 0.18/11
2017-02-07 Caen 0-4 Bordeaux 25/-17 2,91 1.09/23 1.38/8 1.82/11 0.42/12   25/-5 2,29 1.38/24 1.13/8 1.58/12 1.17/12
2017-02-11 Dijon 2-0 Caen 33/-10 2,92 0.92/26 1.00/8 1.31/13 0.54/13   25/-21 2,96 1.04/24 1.38/8 1.67/12 0.42/12
2017-02-18 Caen 0-1 Lille 25/-23 2,92 1.00/25 1.25/8 1.67/12 0.38/13   24/-11 2,19 0.96/27 0.75/8 1.21/14 0.69/13
2017-02-21 Caen 1-0 Nancy 25/-24 2,85 0.96/26 0.88/8 1.54/13 0.38/13   19/-16 2,08 1.04/26 1.00/8 1.23/13 0.85/13
2017-02-26 St Etienne 0-1 Caen 32/10 2,00 1.48/27 1.75/8 2.00/13 1.00/14   26/-23 2,78 1.04/27 1.25/8 1.64/14 0.38/13
2017-03-04 Caen 2-3 Angers 27/-22 2,71 1.11/28 1.25/8 1.64/14 0.57/14   25/-10 2,14 1.18/28 1.75/8 1.64/14 0.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-19 Caen 0-3 Monaco 31/-23 2,83 1.07/30 1.25/8 1.53/15 0.60/15   88/60 3,74 2.32/31 2.50/8 2.69/16 1.93/15
2017-04-02 Lorient 1-0 Caen 33/-35 3,16 0.78/32 0.50/8 1.06/16 0.50/16   31/-26 2,84 1.03/31 0.88/8 1.44/16 0.60/15
2017-04-08 Caen 0-2 Montpellier 31/-27 2,78 1.00/32 0.88/8 1.44/16 0.56/16   46/-9 3,16 1.13/32 0.88/8 1.71/17 0.47/15
2017-04-15 Metz 2-2 Caen 29/-33 2,84 1.09/32 0.75/8 1.53/15 0.71/17   31/-29 2,76 0.97/33 0.88/8 1.35/17 0.56/16
2017-04-22 Caen 0-2 Nantes 33/-29 2,79 0.97/34 1.00/8 1.35/17 0.59/17   31/-20 2,34 1.20/35 1.50/8 1.22/18 1.18/17
2017-04-30 Caen 1-5 Marseille 33/-31 2,77 0.94/35 0.63/8 1.28/18 0.59/17   49/6 2,56 1.47/36 1.63/8 2.06/18 0.89/18
2017-05-06 Toulouse 0-1 Caen 38/-1 2,08 1.24/37 0.88/8 1.78/18 0.74/19   34/-35 2,86 0.92/36 0.25/8 1.21/19 0.59/17
2017-05-14 Caen 0-1 Rennes 35/-34 2,81 0.97/37 0.63/8 1.21/19 0.72/18   33/-11 2,03 1.24/38 1.25/8 1.89/19 0.58/19
2017-05-20 PSG 1-1 Caen 82/56 2,92 2.32/37 2.63/8 2.44/18 2.21/19   35/-35 2,76 0.95/38 0.50/8 1.15/20 0.72/18
2017-05-20 Paris SG 1-1 Caen 82/56 2,92 2.32/37 2.63/8 2.44/18 2.21/19   36/-35 2,74 0.95/39 0.75/8 1.15/20 0.74/19