SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Guingamp' OR Away='Guingamp') 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-12 Monaco 2-2 Guingamp 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-21 Guingamp 2-1 Marseille 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-27 Nancy 0-2 Guingamp 0/-5 2,50 0.00/2 0.00/2 0.00/1 0.00/1   4/1 3,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-09-10 Guingamp 1-1 Montpellier 6/3 3,00 2.33/3 2.33/3 3.00/1 2.00/2   3/-1 2,33 1.33/3 1.33/3 2.00/2 0.00/1
2016-09-17 Toulouse 2-1 Guingamp 5/2 2,00 1.25/4 1.25/4 3.00/1 0.67/3   7/3 2,75 2.00/4 2.00/4 2.00/2 2.00/2
2016-09-21 Guingamp 1-0 Lorient 8/2 2,80 1.60/5 1.60/5 2.00/2 1.33/3   3/-7 2,60 0.60/5 0.60/5 1.00/3 0.00/2
2016-09-24 Bastia 1-0 Guingamp 5/-1 1,57 1.00/7 1.00/7 1.00/4 1.00/3   9/3 2,50 1.83/6 1.83/6 2.33/3 1.33/3
2016-09-30 Rennes 1-0 Guingamp 8/-2 2,57 1.43/7 1.43/7 3.00/3 0.25/4   9/2 2,29 1.57/7 1.57/7 2.33/3 1.00/4
2016-10-15 Guingamp 1-0 Lille 9/1 2,13 1.38/8 1.38/8 2.33/3 0.80/5   8/-6 2,75 0.88/8 0.88/8 1.50/4 0.25/4
2016-10-22 Lyon 1-3 Guingamp 15/4 2,89 1.44/9 1.25/8 2.25/4 0.80/5   10/2 2,00 1.56/9 1.63/8 2.50/4 0.80/5
2016-10-29 Guingamp 1-0 Angers 13/4 2,20 1.70/10 1.63/8 2.50/4 1.17/6   10/0 2,00 1.40/10 1.75/8 1.60/5 1.20/5
2016-11-05 Dijon 3-3 Guingamp 13/-4 2,50 1.08/12 1.25/8 1.83/6 0.33/6   14/5 2,09 1.82/11 1.63/8 2.60/5 1.17/6
2016-11-20 Guingamp 1-1 Bordeaux 17/5 2,42 1.75/12 1.63/8 2.60/5 1.14/7   15/0 2,31 1.46/13 1.25/8 1.83/6 1.14/7
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-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-03 Guingamp 2-0 Nantes 19/4 2,27 1.53/15 1.50/8 2.00/7 1.13/8   9/-17 2,19 0.81/16 0.63/8 0.75/8 0.88/8
2016-12-11 St Etienne 1-0 Guingamp 17/2 1,88 1.35/17 1.25/8 1.63/8 1.11/9   21/6 2,25 1.63/16 1.88/8 2.13/8 1.13/8
2016-12-17 Guingamp 2-1 PSG 21/5 2,18 1.53/17 1.50/8 2.13/8 1.00/9   32/19 2,65 2.12/17 2.13/8 2.33/9 1.88/8
2016-12-17 Guingamp 2-1 Paris SG 23/6 2,22 1.61/18 1.50/8 2.22/9 1.00/9   32/19 2,65 2.12/17 2.13/8 2.33/9 1.88/8
2016-12-21 Metz 2-2 Guingamp 16/-21 2,94 1.00/18 0.63/8 1.14/7 0.91/11   25/7 2,26 1.68/19 1.50/8 2.30/10 1.00/9
2017-01-14 Lorient 3-1 Guingamp 20/-23 3,15 0.75/20 1.00/8 1.44/9 0.18/11   27/7 2,35 1.65/20 1.50/8 2.30/10 1.00/10
2017-01-21 Guingamp 1-1 Rennes 28/5 2,43 1.57/21 1.38/8 2.30/10 0.91/11   20/-9 2,23 1.27/22 0.88/8 1.92/12 0.50/10
2017-01-29 Nice 3-1 Guingamp 37/21 2,41 2.14/22 1.75/8 2.45/11 1.82/11   29/5 2,41 1.55/22 1.38/8 2.18/11 0.91/11
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-08 Marseille 2-0 Guingamp 29/1 2,38 1.42/24 1.88/8 2.18/11 0.77/13   30/2 2,42 1.42/24 1.00/8 2.00/12 0.83/12
2017-02-11 Guingamp 2-1 Lyon 30/0 2,40 1.36/25 1.00/8 2.00/12 0.77/13   45/16 3,08 1.67/24 1.88/8 1.85/13 1.45/11
2017-02-19 Bordeaux 3-0 Guingamp 29/-7 2,41 1.33/27 1.50/8 1.36/14 1.31/13   32/1 2,42 1.42/26 1.00/8 2.08/13 0.77/13
2017-02-25 Guingamp 1-2 Monaco 32/-2 2,44 1.37/27 0.63/8 2.08/13 0.71/14   80/54 3,79 2.25/28 2.25/8 2.64/14 1.86/14
2017-03-04 Montpellier 1-1 Guingamp 42/-3 3,11 1.25/28 1.25/8 2.00/14 0.50/14   33/-3 2,46 1.32/28 0.50/8 1.93/14 0.71/14
2017-03-11 Guingamp 5-0 Bastia 34/-3 2,45 1.31/29 0.63/8 1.93/14 0.73/15   24/-15 2,17 0.86/29 0.63/8 1.13/16 0.54/13
2017-03-18 Angers 3-0 Guingamp 28/-12 2,27 1.20/30 2.00/8 1.64/14 0.81/16   39/2 2,53 1.37/30 0.88/8 2.00/15 0.73/15
2017-03-31 Guingamp 1-0 Nancy 39/-1 2,55 1.32/31 0.88/8 2.00/15 0.69/16   22/-21 2,03 0.88/32 0.13/8 1.06/16 0.69/16
2017-04-09 Paris SG 4-0 Guingamp 60/39 2,70 2.27/30 2.75/8 2.33/15 2.20/15   40/0 2,50 1.38/32 1.25/8 2.06/16 0.69/16
2017-04-09 PSG 4-0 Guingamp 60/39 2,70 2.27/30 2.75/8 2.33/15 2.20/15   40/-4 2,55 1.33/33 0.88/8 2.06/16 0.65/17
2017-04-15 Guingamp 2-1 Toulouse 40/-8 2,59 1.29/34 0.88/8 2.06/16 0.61/18   35/2 2,00 1.32/34 1.13/8 1.82/17 0.82/17
2017-04-22 Lille 3-0 Guingamp 32/-12 2,17 1.06/35 1.38/8 1.06/17 1.06/18   42/-7 2,60 1.34/35 1.25/8 2.12/17 0.61/18
2017-04-29 Guingamp 0-2 St Etienne 42/-10 2,61 1.31/36 1.25/8 2.12/17 0.58/19   37/6 2,00 1.38/34 0.88/8 1.71/17 1.06/17
2017-05-06 Guingamp 4-0 Dijon 42/-12 2,59 1.27/37 1.13/8 2.00/18 0.58/19   45/-15 2,84 0.89/37 0.75/8 1.26/19 0.50/18
2017-05-14 Nantes 4-1 Guingamp 36/-18 2,37 1.26/38 1.75/8 1.32/19 1.21/19   46/-8 2,63 1.32/38 1.13/8 2.05/19 0.58/19
2017-05-20 Guingamp 1-0 Metz 47/-11 2,69 1.28/39 1.13/8 2.05/19 0.55/20   41/-36 3,03 1.10/39 1.00/8 1.40/20 0.79/19