SELECT * FROM 1_Kampe WHERE LigaID = '80' AND (Home='Lorient' OR Away='Lorient') 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-20 Lorient 0-3 Bastia 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-2 1,00 0.00/2 0.00/2 0.00/2 0.00/0
2016-08-26 Marseille 2-0 Lorient 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   2/-4 4,00 0.00/2 0.00/2 0.00/1 0.00/1
2016-09-10 Lorient 0-2 Nancy 2/-6 3,33 0.00/3 0.00/3 0.00/1 0.00/2   0/-7 2,33 0.00/3 0.00/3 0.00/2 0.00/1
2016-09-17 Lorient 1-0 Lille 2/-8 3,00 0.00/4 0.00/4 0.00/2 0.00/2   5/-3 3,25 1.00/4 1.00/4 1.50/2 0.50/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 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 Nice 2-1 Lorient 12/8 2,29 2.43/7 2.43/7 2.50/4 2.33/3   4/-7 2,14 0.86/7 0.86/7 1.50/4 0.00/3
2016-10-15 Lorient 1-2 Nantes 5/-8 2,25 0.75/8 0.75/8 1.50/4 0.00/4   4/-4 1,50 1.00/8 1.00/8 1.00/4 1.00/4
2016-10-22 Dijon 1-0 Lorient 12/-5 2,90 0.90/10 1.13/8 1.60/5 0.20/5   6/-9 2,33 0.67/9 0.75/8 1.20/5 0.00/4
2016-10-29 Lorient 2-2 Montpellier 6/-10 2,20 0.60/10 0.75/8 1.20/5 0.00/5   14/-9 3,70 1.00/10 0.88/8 1.60/5 0.40/5
2016-11-05 Bordeaux 2-1 Lorient 13/-1 2,25 1.33/12 0.88/8 1.60/5 1.14/7   8/-10 2,36 0.64/11 0.88/8 1.17/6 0.00/5
2016-11-18 Lorient 0-3 Monaco 9/-11 2,42 0.58/12 0.88/8 1.17/6 0.00/6   39/23 4,23 2.23/13 2.00/8 2.71/7 1.67/6
2016-11-26 Metz 3-3 Lorient 13/-12 2,71 1.21/14 0.88/8 1.17/6 1.25/8   9/-14 2,46 0.54/13 0.50/8 1.00/7 0.00/6
2016-11-29 Lorient 2-1 Rennes 12/-14 2,71 0.57/14 0.63/8 1.00/7 0.14/7   15/-6 2,40 1.60/15 1.75/8 2.50/8 0.57/7
2016-12-03 Angers 2-2 Lorient 13/-5 1,94 1.13/16 1.00/8 1.57/7 0.78/9   14/-13 2,73 0.73/15 0.63/8 1.25/8 0.14/7
2016-12-10 Toulouse 3-2 Lorient 20/4 2,12 1.47/17 1.00/8 2.25/8 0.78/9   16/-13 2,81 0.75/16 0.75/8 1.25/8 0.25/8
2016-12-17 Lorient 2-1 St Etienne 18/-14 2,94 0.71/17 0.75/8 1.25/8 0.22/9   18/3 1,83 1.44/18 1.50/8 1.78/9 1.11/9
2016-12-21 PSG 5-0 Lorient 33/18 2,67 2.00/18 2.00/8 2.33/9 1.67/9   20/-13 2,94 0.83/18 1.13/8 1.44/9 0.22/9
2016-12-21 Paris SG 5-0 Lorient 33/18 2,67 2.00/18 2.00/8 2.33/9 1.67/9   20/-18 3,05 0.79/19 1.00/8 1.44/9 0.20/10
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-22 Monaco 4-0 Lorient 63/41 4,05 2.29/21 2.38/8 2.55/11 2.00/10   23/-21 3,19 0.86/21 1.38/8 1.60/10 0.18/11
2017-01-28 Lorient 2-3 Dijon 23/-25 3,23 0.82/22 1.25/8 1.60/10 0.17/12   27/-6 2,73 0.95/22 0.88/8 1.55/11 0.36/11
2017-02-04 Lille 0-1 Lorient 21/-7 2,13 1.13/23 1.88/8 1.42/12 0.82/11   25/-26 3,30 0.78/23 0.88/8 1.45/11 0.17/12
2017-02-08 Lorient 1-1 Toulouse 26/-25 3,21 0.88/24 1.13/8 1.45/11 0.38/13   28/2 2,25 1.33/24 0.88/8 1.92/13 0.64/11
2017-02-12 St Etienne 4-0 Lorient 27/7 1,88 1.48/25 1.75/8 1.92/12 1.08/13   27/-25 3,16 0.88/25 1.25/8 1.42/12 0.38/13
2017-02-18 Lorient 0-1 Nice 27/-29 3,19 0.85/26 0.88/8 1.42/12 0.36/14   43/21 2,50 2.08/26 1.63/8 2.54/13 1.62/13
2017-02-25 Rennes 1-0 Lorient 25/-11 2,18 1.18/28 0.63/8 1.79/14 0.57/14   27/-30 3,11 0.81/27 0.88/8 1.31/13 0.36/14
2017-03-05 Lorient 1-4 Marseille 27/-31 3,04 0.79/28 0.88/8 1.31/13 0.33/15   37/-4 2,69 1.38/29 1.13/8 2.00/15 0.71/14
2017-03-12 Lorient 1-2 Paris SG 28/-34 3,10 0.76/29 0.50/8 1.21/14 0.33/15   56/37 2,68 2.21/28 2.50/8 2.29/14 2.14/14
2017-03-12 Lorient 1-2 PSG 29/-35 3,10 0.73/30 0.50/8 1.13/15 0.33/15   56/37 2,68 2.21/28 2.50/8 2.29/14 2.14/14
2017-03-18 Nancy 2-3 Lorient 20/-20 1,94 0.90/31 0.13/8 1.13/15 0.69/16   30/-36 3,10 0.71/31 0.50/8 1.06/16 0.33/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 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-15 Montpellier 2-0 Lorient 48/-7 3,12 1.18/33 1.25/8 1.71/17 0.63/16   38/-31 3,15 0.91/34 1.13/8 1.18/17 0.65/17
2017-04-22 Lorient 5-1 Metz 38/-33 3,11 0.89/35 1.13/8 1.18/17 0.61/18   35/-35 3,00 1.03/35 0.75/8 1.33/18 0.71/17
2017-04-29 Nantes 1-0 Lorient 33/-18 2,33 1.25/36 1.50/8 1.22/18 1.28/18   43/-29 3,19 0.94/36 1.50/8 1.28/18 0.61/18
2017-05-06 Lorient 1-1 Angers 43/-30 3,14 0.92/37 1.50/8 1.28/18 0.58/19   35/-17 2,35 1.05/37 0.38/8 1.37/19 0.72/18
2017-05-14 Bastia 2-0 Lorient 27/-35 2,34 0.82/38 0.75/8 1.11/19 0.53/19   44/-30 3,11 0.92/38 1.63/8 1.26/19 0.58/19
2017-05-20 Lorient 1-1 Bordeaux 44/-32 3,08 0.90/39 1.63/8 1.26/19 0.55/20   52/5 2,54 1.49/39 1.88/8 1.65/20 1.32/19