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/-1 1,00 0.00/1 0.00/1 0.00/1 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/-2 2,89 1.00/9 1.13/8 1.60/5 0.25/4   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,27 1.45/11 1.25/8 1.60/5 1.33/6   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   36/21 4,25 2.17/12 2.00/8 2.67/6 1.67/6
2016-11-26 Metz 3-3 Lorient 13/-9 2,69 1.31/13 0.88/8 1.17/6 1.43/7   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/-2 2,29 1.71/14 1.75/8 2.50/8 0.67/6
2016-12-03 Angers 2-2 Lorient 13/-3 1,93 1.20/15 1.13/8 1.57/7 0.88/8   14/-13 2,73 0.73/15 0.63/8 1.25/8 0.14/7
2016-12-10 Toulouse 3-2 Lorient 18/2 2,13 1.38/16 1.00/8 2.14/7 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   17/3 1,82 1.47/17 1.50/8 1.78/9 1.13/8
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/-13 2,94 0.83/18 1.13/8 1.44/9 0.22/9
2017-01-14 Lorient 3-1 Guingamp 20/-18 3,05 0.79/19 1.00/8 1.44/9 0.20/10   25/6 2,32 1.58/19 1.25/8 2.22/9 1.00/10
2017-01-22 Monaco 4-0 Lorient 60/39 4,05 2.25/20 2.38/8 2.50/10 2.00/10   23/-16 3,10 0.90/20 1.38/8 1.60/10 0.20/10
2017-01-28 Lorient 2-3 Dijon 23/-20 3,14 0.86/21 1.38/8 1.60/10 0.18/11   27/-3 2,71 1.00/21 0.88/8 1.55/11 0.40/10
2017-02-04 Lille 0-1 Lorient 21/-6 2,18 1.18/22 1.88/8 1.55/11 0.82/11   25/-21 3,23 0.82/22 1.25/8 1.45/11 0.18/11
2017-02-08 Lorient 1-1 Toulouse 26/-20 3,13 0.91/23 1.25/8 1.45/11 0.42/12   26/0 2,26 1.26/23 0.88/8 1.83/12 0.64/11
2017-02-12 St Etienne 4-0 Lorient 26/7 1,88 1.50/24 1.75/8 1.92/12 1.08/12   27/-20 3,08 0.92/24 1.25/8 1.42/12 0.42/12
2017-02-18 Lorient 0-1 Nice 27/-24 3,12 0.88/25 1.25/8 1.42/12 0.38/13   41/21 2,44 2.12/25 1.63/8 2.54/13 1.67/12
2017-02-25 Rennes 1-0 Lorient 25/-6 2,15 1.27/26 0.75/8 1.92/13 0.62/13   27/-25 3,04 0.85/26 0.88/8 1.31/13 0.38/13
2017-03-05 Lorient 1-4 Marseille 27/-26 2,96 0.81/27 0.88/8 1.31/13 0.36/14   36/0 2,67 1.44/27 1.13/8 2.14/14 0.69/13
2017-03-12 Lorient 1-2 Paris SG 28/-29 3,04 0.79/28 0.50/8 1.21/14 0.36/14   56/37 2,68 2.21/28 2.50/8 2.29/14 2.14/14
2017-03-18 Nancy 2-3 Lorient 19/-18 1,93 0.97/29 0.50/8 1.21/14 0.73/15   29/-30 3,03 0.76/29 0.50/8 1.13/15 0.36/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 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-15 Montpellier 2-0 Lorient 45/-10 3,13 1.13/32 1.25/8 1.63/16 0.63/16   37/-25 3,09 0.97/32 1.13/8 1.25/16 0.69/16
2017-04-22 Lorient 5-1 Metz 37/-27 3,06 0.94/33 1.13/8 1.25/16 0.65/17   33/-31 2,94 1.09/33 0.75/8 1.41/17 0.75/16
2017-04-29 Nantes 1-0 Lorient 33/-14 2,35 1.32/34 1.50/8 1.29/17 1.35/17   42/-23 3,15 1.00/34 1.50/8 1.35/17 0.65/17
2017-05-06 Lorient 1-1 Angers 42/-24 3,09 0.97/35 1.50/8 1.35/17 0.61/18   35/-13 2,37 1.11/35 0.75/8 1.44/18 0.76/17
2017-05-14 Bastia 2-0 Lorient 27/-29 2,31 0.86/36 0.75/8 1.17/18 0.56/18   43/-24 3,06 0.97/36 1.63/8 1.33/18 0.61/18
2017-05-20 Lorient 1-1 Bordeaux 43/-26 3,03 0.95/37 1.63/8 1.33/18 0.58/19   52/10 2,54 1.57/37 1.88/8 1.74/19 1.39/18