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/2 2,00 1.50/2 1.50/2 0.00/1 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-21 Angers 2-1 Caen 4/-1 1,80 1.20/5 1.20/5 1.50/2 1.00/3   5/-7 3,40 1.20/5 1.20/5 2.00/3 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/-8 3,33 1.00/6 1.00/6 2.00/3 0.00/3
2016-10-01 Caen 1-0 Toulouse 6/-8 2,86 1.00/7 1.00/7 2.00/3 0.25/4   11/6 2,29 2.00/7 2.00/7 3.00/3 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/-7 2,63 1.25/8 1.25/8 2.25/4 0.25/4
2016-10-23 Caen 0-2 St Etienne 9/-8 2,89 1.11/9 0.88/8 2.25/4 0.20/5   11/2 2,22 1.44/9 1.63/8 2.20/5 0.50/4
2016-10-29 Nancy 2-0 Caen 5/-8 1,80 0.60/10 0.75/8 0.20/5 1.00/5   9/-10 2,80 1.00/10 0.88/8 1.80/5 0.20/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 Marseille 1-0 Caen 12/-1 2,08 1.17/12 1.25/8 2.00/6 0.33/6   10/-11 2,58 1.08/12 0.88/8 2.00/6 0.17/6
2016-11-26 Caen 1-1 Guingamp 10/-12 2,46 1.00/13 0.88/8 2.00/6 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/-9 2,07 0.79/14 0.88/8 1.29/7 0.29/7   11/-12 2,43 1.00/14 1.00/8 1.86/7 0.14/7
2016-12-02 Caen 3-3 Dijon 13/-14 2,67 0.93/15 0.88/8 1.86/7 0.13/8   19/-3 2,73 1.00/15 1.00/8 1.63/8 0.29/7
2016-12-18 Caen 3-0 Metz 16/-14 2,88 0.94/16 0.63/8 1.75/8 0.13/8   16/-15 2,94 1.13/16 0.63/8 1.14/7 1.11/9
2016-12-21 Monaco 2-1 Caen 54/35 4,06 2.17/18 2.13/8 2.44/9 1.89/9   19/-11 2,88 1.06/17 1.00/8 1.89/9 0.13/8
2017-01-15 Caen 3-2 Lyon 20/-12 2,89 1.00/18 1.00/8 1.89/9 0.11/9   34/15 2,94 1.89/18 2.63/8 2.00/9 1.78/9
2017-01-18 Nantes 1-0 Caen 13/-13 2,05 1.16/19 1.38/8 1.00/9 1.30/10   23/-11 3,00 1.11/19 1.38/8 2.00/10 0.11/9
2017-01-28 Bastia 1-1 Caen 18/-7 2,05 1.00/21 1.13/8 1.27/11 0.70/10   23/-12 2,90 1.05/20 1.00/8 2.00/10 0.10/10
2017-02-04 Guingamp 0-1 Caen 28/2 2,45 1.41/22 1.00/8 2.10/10 0.83/12   24/-12 2,86 1.05/21 1.13/8 2.00/10 0.18/11
2017-02-07 Caen 0-4 Bordeaux 25/-11 2,77 1.14/22 1.38/8 2.00/10 0.42/12   25/-3 2,30 1.43/23 1.13/8 1.58/12 1.27/11
2017-02-11 Dijon 2-0 Caen 32/-5 2,88 1.00/24 1.00/8 1.42/12 0.58/12   25/-15 2,83 1.09/23 1.38/8 1.82/11 0.42/12
2017-02-18 Caen 0-1 Lille 25/-17 2,79 1.04/24 1.25/8 1.82/11 0.38/13   23/-9 2,20 1.04/25 0.75/8 1.31/13 0.75/12
2017-02-21 Caen 1-0 Nancy 25/-18 2,72 1.00/25 0.88/8 1.67/12 0.38/13   18/-15 2,04 1.08/25 1.00/8 1.33/12 0.85/13
2017-02-26 St Etienne 0-1 Caen 31/10 2,00 1.50/26 1.75/8 2.00/13 1.00/13   26/-17 2,65 1.08/26 1.25/8 1.77/13 0.38/13
2017-03-04 Caen 2-3 Angers 27/-16 2,59 1.15/27 1.25/8 1.77/13 0.57/14   25/-8 2,15 1.22/27 1.75/8 1.64/14 0.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-19 Caen 0-3 Monaco 31/-17 2,72 1.10/29 1.25/8 1.64/14 0.60/15   84/58 3,79 2.34/29 2.50/8 2.67/15 2.00/14
2017-04-02 Lorient 1-0 Caen 32/-29 3,10 0.83/30 0.88/8 1.13/15 0.53/15   31/-20 2,73 1.07/30 0.88/8 1.53/15 0.60/15
2017-04-08 Caen 0-2 Montpellier 31/-21 2,68 1.03/31 0.88/8 1.53/15 0.56/16   43/-12 3,16 1.06/31 0.88/8 1.63/16 0.47/15
2017-04-15 Metz 2-2 Caen 29/-30 2,84 1.13/31 0.75/8 1.53/15 0.75/16   31/-23 2,66 1.00/32 0.88/8 1.44/16 0.56/16
2017-04-22 Caen 0-2 Nantes 33/-23 2,70 1.00/33 1.00/8 1.44/16 0.59/17   31/-16 2,36 1.27/33 1.50/8 1.29/17 1.25/16
2017-04-30 Caen 1-5 Marseille 33/-25 2,68 0.97/34 0.63/8 1.35/17 0.59/17   48/10 2,53 1.53/34 1.63/8 2.18/17 0.88/17
2017-05-06 Toulouse 0-1 Caen 36/-3 2,14 1.20/35 0.88/8 1.71/17 0.72/18   34/-29 2,77 0.94/35 0.25/8 1.28/18 0.59/17
2017-05-14 Caen 0-1 Rennes 35/-28 2,72 1.00/36 0.63/8 1.28/18 0.72/18   33/-6 2,00 1.31/36 1.25/8 2.00/18 0.61/18
2017-05-20 PSG 1-1 Caen 82/56 2,92 2.32/37 2.63/8 2.44/18 2.21/19   35/-29 2,68 0.97/37 0.50/8 1.21/19 0.72/18
2018-10-21 Caen 0-1 Paris SG 36/-29 2,66 0.97/38 0.63/8 1.21/19 0.74/19   6/-2 1,00 1.29/14 1.88/8 0.00/8 3.00/6
2018-10-21 Paris SG 0-1 Caen 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   36/-30 2,62 0.95/39 1.00/8 1.15/20 0.74/19