SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Lyon' OR Away='Lyon') 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-14 Nancy 0-3 Lyon 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 Dijon 4-2 Lyon 0/-2 1,00 0.00/2 0.00/2 0.00/1 0.00/1   5/5 2,50 3.00/2 3.00/2 3.00/1 3.00/1
2016-09-10 Lyon 1-3 Bordeaux 7/3 3,67 2.00/3 2.00/3 3.00/1 1.50/2   5/-1 3,67 2.00/3 2.00/3 3.00/2 0.00/1
2016-09-18 Marseille 0-0 Lyon 5/0 2,50 1.00/4 1.00/4 2.00/2 0.00/2   8/1 3,75 1.50/4 1.50/4 1.50/2 1.50/2
2016-09-21 Lyon 5-1 Montpellier 8/1 3,00 1.40/5 1.40/5 1.50/2 1.33/3   5/-1 2,20 1.20/5 1.20/5 1.67/3 0.50/2
2016-09-24 Lorient 1-0 Lyon 3/-8 2,33 0.50/6 0.50/6 1.00/3 0.00/3   13/5 3,50 1.67/6 1.67/6 2.00/3 1.33/3
2016-10-02 Lyon 2-0 St Etienne 13/4 3,14 1.43/7 1.43/7 2.00/3 1.00/4   11/4 2,25 1.63/8 1.63/8 2.50/4 0.75/4
2016-10-14 Nice 2-0 Lyon 14/9 2,38 2.50/8 2.50/8 2.60/5 2.33/3   15/6 3,00 1.63/8 1.63/8 2.25/4 1.00/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 Toulouse 1-2 Lyon 16/9 2,09 1.91/11 2.00/8 3.00/5 1.00/6   16/2 3,00 1.30/10 0.88/8 1.80/5 0.80/5
2016-11-05 Lyon 2-1 Bastia 18/3 3,00 1.45/11 1.25/8 1.80/5 1.17/6   8/-3 1,58 0.92/12 1.00/8 1.14/7 0.60/5
2016-11-18 Lille 0-1 Lyon 10/-9 2,23 0.77/13 0.75/8 1.29/7 0.17/6   20/4 3,00 1.58/12 1.63/8 2.00/6 1.17/6
2016-11-27 Lyon 1-2 Paris SG 21/5 2,85 1.69/13 1.88/8 2.00/6 1.43/7   26/19 2,54 2.23/13 2.38/8 2.43/7 2.00/6
2016-11-27 Lyon 1-2 PSG 22/4 2,86 1.57/14 1.50/8 1.71/7 1.43/7   26/19 2,54 2.23/13 2.38/8 2.43/7 2.00/6
2016-11-30 Nantes 0-6 Lyon 9/-11 1,93 0.87/15 1.00/8 0.86/7 0.88/8   23/3 2,87 1.47/15 1.50/8 1.50/8 1.43/7
2016-12-11 Lyon 1-0 Rennes 29/9 3,06 1.56/16 1.50/8 1.50/8 1.63/8   18/-5 2,41 1.59/17 1.63/8 2.56/9 0.50/8
2016-12-18 Monaco 1-3 Lyon 56/39 4,06 2.33/18 2.50/8 2.78/9 1.89/9   30/10 2,94 1.65/17 1.88/8 1.67/9 1.63/8
2016-12-21 Lyon 2-0 Angers 33/12 3,00 1.72/18 2.25/8 1.67/9 1.78/9   15/-9 2,05 1.00/19 0.63/8 1.33/9 0.70/10
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-22 Lyon 3-1 Marseille 37/13 3,05 1.70/20 1.88/8 1.80/10 1.60/10   23/0 2,19 1.48/21 2.00/8 2.10/10 0.91/11
2017-01-28 Lyon 1-2 Lille 40/15 3,10 1.76/21 1.88/8 1.91/11 1.60/10   19/-8 2,09 1.05/22 1.63/8 1.42/12 0.60/10
2017-02-05 St Etienne 2-0 Lyon 25/6 1,91 1.48/23 1.50/8 1.82/11 1.17/12   41/14 3,09 1.68/22 1.88/8 1.75/12 1.60/10
2017-02-08 Lyon 4-0 Nancy 41/12 3,04 1.61/23 1.88/8 1.75/12 1.45/11   19/-8 2,00 1.17/23 1.75/8 1.33/12 1.00/11
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 Lyon 4-2 Dijon 46/15 3,08 1.60/25 1.50/8 1.85/13 1.33/12   35/-8 2,89 1.00/27 1.38/8 1.43/14 0.54/13
2017-02-26 Lyon 5-0 Metz 50/17 3,19 1.65/26 1.50/8 1.93/14 1.33/12   25/-23 2,81 1.15/26 1.50/8 1.58/12 0.79/14
2017-03-03 Bordeaux 1-1 Lyon 35/-3 2,52 1.45/29 2.00/8 1.47/15 1.43/14   55/22 3,26 1.70/27 1.50/8 2.00/15 1.33/12
2017-03-12 Lyon 4-0 Toulouse 56/22 3,21 1.68/28 1.63/8 2.00/15 1.31/13   34/5 2,10 1.33/30 1.38/8 1.93/15 0.73/15
2017-03-19 PSG 2-1 Lyon 58/38 2,69 2.24/29 2.50/8 2.29/14 2.20/15   60/26 3,24 1.72/29 1.63/8 2.06/16 1.31/13
2017-03-19 Paris SG 2-1 Lyon 58/38 2,69 2.24/29 2.50/8 2.29/14 2.20/15   61/25 3,23 1.67/30 1.63/8 2.06/16 1.21/14
2017-04-02 Rennes 1-1 Lyon 28/-10 2,06 1.22/32 1.13/8 1.81/16 0.63/16   62/24 3,23 1.61/31 1.63/8 2.06/16 1.13/15
2017-04-05 Metz 0-3 Lyon 29/-27 2,83 1.17/30 1.50/8 1.64/14 0.75/16   63/24 3,19 1.59/32 1.38/8 2.06/16 1.13/16
2017-04-08 Lyon 1-4 Lorient 66/27 3,18 1.64/33 1.75/8 2.06/16 1.24/17   34/-34 3,09 0.85/33 0.75/8 1.18/17 0.50/16
2017-04-16 Bastia 0-3 Lyon 26/-21 2,21 0.85/33 0.75/8 1.06/17 0.63/16   67/24 3,24 1.59/34 1.38/8 1.94/17 1.24/17
2017-04-23 Lyon 1-2 Monaco 70/27 3,23 1.63/35 1.38/8 1.94/17 1.33/18   94/65 3,62 2.38/34 2.75/8 2.71/17 2.06/17
2017-04-28 Angers 1-2 Lyon 34/-16 2,33 1.08/36 0.75/8 1.44/18 0.72/18   71/26 3,22 1.58/36 1.25/8 1.83/18 1.33/18
2017-05-07 Lyon 3-2 Nantes 73/27 3,22 1.62/37 1.25/8 1.83/18 1.42/19   34/-17 2,30 1.30/37 1.75/8 1.32/19 1.28/18
2017-05-14 Montpellier 1-3 Lyon 50/-13 2,97 1.11/38 0.75/8 1.68/19 0.53/19   76/28 3,26 1.66/38 1.63/8 1.89/19 1.42/19
2017-05-20 Lyon 3-3 Nice 79/30 3,28 1.69/39 2.00/8 1.89/19 1.50/20   65/29 2,59 2.08/39 2.00/8 2.45/20 1.68/19