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   10/4 2,29 1.71/7 1.71/7 2.50/4 0.67/3
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 14/7 2,10 1.80/10 1.75/8 3.00/4 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/-2 1,64 1.00/11 1.00/8 1.33/6 0.60/5
2016-11-18 Lille 0-1 Lyon 10/-8 2,33 0.83/12 0.75/8 1.50/6 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 PSG 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-30 Nantes 0-6 Lyon 9/-9 1,93 0.93/14 1.00/8 0.86/7 1.00/7   22/4 2,86 1.57/14 1.50/8 1.71/7 1.43/7
2016-12-11 Lyon 1-0 Rennes 28/10 3,07 1.67/15 1.88/8 1.71/7 1.63/8   18/-1 2,31 1.69/16 1.75/8 2.56/9 0.57/7
2016-12-18 Monaco 1-3 Lyon 53/37 4,06 2.29/17 2.50/8 2.75/8 1.89/9   29/11 2,94 1.75/16 1.88/8 1.88/8 1.63/8
2016-12-21 Lyon 2-0 Angers 32/13 3,00 1.82/17 2.25/8 1.88/8 1.78/9   15/-7 2,06 1.06/18 0.63/8 1.33/9 0.78/9
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-22 Lyon 3-1 Marseille 36/14 3,05 1.79/19 2.25/8 2.00/9 1.60/10   23/0 2,30 1.50/20 2.00/8 2.10/10 0.90/10
2017-01-28 Lyon 1-2 Lille 39/16 3,10 1.85/20 2.25/8 2.10/10 1.60/10   19/-7 2,14 1.10/21 1.63/8 1.55/11 0.60/10
2017-02-05 St Etienne 2-0 Lyon 24/6 1,91 1.50/22 1.50/8 1.82/11 1.18/11   40/15 3,10 1.76/21 1.88/8 1.91/11 1.60/10
2017-02-08 Lyon 4-0 Nancy 40/13 3,05 1.68/22 1.88/8 1.91/11 1.45/11   18/-7 1,95 1.23/22 1.75/8 1.45/11 1.00/11
2017-02-11 Guingamp 2-1 Lyon 28/-1 2,38 1.29/24 0.63/8 1.91/11 0.77/13   44/17 3,09 1.74/23 1.88/8 2.00/12 1.45/11
2017-02-19 Lyon 4-2 Dijon 45/16 3,08 1.67/24 1.50/8 2.00/12 1.33/12   34/-3 2,84 1.08/25 1.38/8 1.54/13 0.58/12
2017-02-26 Lyon 5-0 Metz 49/18 3,20 1.72/25 1.50/8 2.08/13 1.33/12   25/-20 2,80 1.20/25 1.50/8 1.58/12 0.85/13
2017-03-03 Bordeaux 1-1 Lyon 35/2 2,52 1.56/27 2.13/8 1.57/14 1.54/13   54/23 3,27 1.77/26 1.50/8 2.14/14 1.33/12
2017-03-12 Lyon 4-0 Toulouse 55/23 3,22 1.74/27 1.63/8 2.14/14 1.31/13   32/3 2,18 1.29/28 1.25/8 1.86/14 0.71/14
2017-03-19 PSG 2-1 Lyon 58/38 2,69 2.24/29 2.50/8 2.29/14 2.20/15   59/27 3,25 1.79/28 1.63/8 2.20/15 1.31/13
2017-04-02 Rennes 1-1 Lyon 28/-5 2,03 1.30/30 1.13/8 1.93/15 0.67/15   60/26 3,24 1.72/29 1.63/8 2.20/15 1.21/14
2017-04-05 Metz 0-3 Lyon 29/-24 2,83 1.21/29 1.50/8 1.64/14 0.80/15   61/26 3,20 1.70/30 1.75/8 2.20/15 1.20/15
2017-04-08 Lyon 1-4 Lorient 64/29 3,19 1.74/31 1.75/8 2.20/15 1.31/16   33/-28 3,03 0.90/31 0.88/8 1.25/16 0.53/15
2017-04-16 Bastia 0-3 Lyon 26/-20 2,25 0.88/32 0.75/8 1.13/16 0.63/16   65/26 3,25 1.69/32 1.75/8 2.06/16 1.31/16
2017-04-23 Lyon 1-2 Monaco 68/29 3,24 1.73/33 1.75/8 2.06/16 1.41/17   90/63 3,66 2.41/32 2.75/8 2.69/16 2.13/16
2017-04-28 Angers 1-2 Lyon 34/-12 2,35 1.15/34 1.13/8 1.53/17 0.76/17   69/28 3,24 1.68/34 1.38/8 1.94/17 1.41/17
2017-05-07 Lyon 3-2 Nantes 71/29 3,23 1.71/35 1.63/8 1.94/17 1.50/18   34/-13 2,31 1.37/35 1.75/8 1.39/18 1.35/17
2017-05-14 Montpellier 1-3 Lyon 47/-14 3,00 1.08/36 0.75/8 1.61/18 0.56/18   74/30 3,28 1.75/36 1.63/8 2.00/18 1.50/18
2017-05-20 Lyon 3-3 Nice 77/32 3,30 1.78/37 2.00/8 2.00/18 1.58/19   60/27 2,51 2.08/37 1.75/8 2.42/19 1.72/18
2018-10-21 Lyon 0-1 Paris SG 80/32 3,37 1.76/38 2.00/8 1.95/19 1.58/19   2/-1 1,00 1.20/5 1.88/8 0.00/3 3.00/2
2018-10-21 Paris SG 0-1 Lyon 13/-1 1,00 1.44/27 1.88/8 0.00/14 3.00/13   80/31 3,31 1.72/39 2.00/8 1.85/20 1.58/19