SELECT * FROM 1_Kampe WHERE LigaID = '84' 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
2012-08-11 PSG 2-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
2012-08-18 Lorient 2-1 Montpellier 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2012-08-25 Troyes 2-2 Lorient 1/-4 3,00 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
2012-09-01 Lorient 3-0 Nancy 6/1 3,67 1.67/3 1.67/3 3.00/1 1.00/2   2/0 1,33 1.33/3 1.33/3 1.50/2 1.00/1
2012-09-16 Rennes 1-2 Lorient 4/-3 2,75 0.75/4 0.75/4 1.50/2 0.00/2   9/4 3,50 2.00/4 2.00/4 3.00/2 1.00/2
2012-09-22 Lorient 1-1 Nice 11/5 3,40 2.20/5 2.20/5 3.00/2 1.67/3   7/1 2,60 1.20/5 1.20/5 1.33/3 1.00/2
2012-09-29 Thonon-Evian 1-1 Lorient 6/-2 2,33 0.67/6 0.67/6 1.33/3 0.00/3   12/5 3,17 2.00/6 2.00/6 2.33/3 1.67/3
2012-10-07 Lorient 1-1 Lyon 13/5 3,00 1.86/7 1.86/7 2.33/3 1.50/4   12/5 2,71 2.00/7 2.00/7 2.25/4 1.67/3
2012-10-20 Valenciennes 6-1 Lorient 13/5 2,63 1.50/8 1.50/8 2.00/4 1.00/4   14/5 2,88 1.75/8 1.75/8 2.00/4 1.50/4
2012-10-28 Lorient 4-4 AC Ajaccio 15/0 3,33 1.56/9 1.63/8 2.00/4 1.20/5   6/-3 1,67 1.33/9 1.13/8 2.00/4 0.80/5
2012-11-02 Brest 2-0 Lorient 9/-8 2,60 1.00/10 0.88/8 2.50/4 0.00/6   19/0 3,80 1.50/10 1.38/8 1.80/5 1.20/5
2012-11-11 Lorient 0-4 Bordeaux 19/-2 3,64 1.36/11 1.25/8 1.80/5 1.00/6   13/3 2,09 1.64/11 1.38/8 1.80/5 1.50/6
2012-11-16 Lorient 2-0 Lille 19/-6 3,67 1.25/12 0.88/8 1.50/6 1.00/6   16/4 2,33 1.67/12 1.88/8 1.83/6 1.50/6
2012-11-24 Bastia 2-1 Lorient 19/-13 3,92 1.08/13 1.00/8 1.50/6 0.71/7   21/-4 3,54 1.38/13 0.88/8 1.71/7 1.00/6
2012-12-02 Lorient 1-0 Toulouse 22/-5 3,50 1.29/14 0.75/8 1.71/7 0.86/7   23/7 2,79 1.57/14 1.63/8 1.71/7 1.43/7
2012-12-09 Marseille 0-3 Lorient 20/4 2,40 1.93/15 1.38/8 2.00/7 1.88/8   23/-4 3,33 1.40/15 1.00/8 1.88/8 0.86/7
2012-12-12 Lorient 2-0 Sochaux 26/-1 3,31 1.50/16 1.25/8 1.88/8 1.13/8   16/-7 2,44 1.00/16 1.25/8 1.00/8 1.00/8
2012-12-16 St Etienne 0-2 Lorient 24/13 2,06 1.59/17 1.88/8 1.78/9 1.38/8   28/1 3,24 1.59/17 1.63/8 2.00/9 1.13/8
2012-12-22 Lorient 2-2 Reims 30/3 3,17 1.67/18 1.88/8 2.00/9 1.33/9   14/-4 1,78 1.00/18 0.38/8 1.60/10 0.25/8
2013-01-12 Montpellier 2-0 Lorient 29/5 2,79 1.37/19 1.75/8 1.67/9 1.10/10   32/3 3,21 1.63/19 2.00/8 1.90/10 1.33/9
2013-01-19 Lorient 3-2 Troyes 32/1 3,15 1.55/20 2.00/8 1.90/10 1.20/10   21/-18 3,00 0.65/20 0.75/8 1.00/11 0.22/9
2013-01-26 Nancy 2-1 Lorient 18/-19 2,62 0.57/21 0.75/8 0.73/11 0.40/10   35/2 3,24 1.62/21 2.00/8 2.00/11 1.20/10
2013-02-02 Lorient 2-2 Rennes 36/1 3,23 1.55/22 2.00/8 2.00/11 1.09/11   33/5 2,77 1.64/22 1.75/8 1.55/11 1.73/11
2013-02-09 Nice 1-1 Lorient 35/8 2,70 1.65/23 2.00/8 2.00/12 1.27/11   38/1 3,26 1.52/23 1.75/8 1.92/12 1.09/11
2013-02-16 Lorient 2-1 Thonon-Evian 39/1 3,21 1.50/24 1.50/8 1.92/12 1.08/12   24/-12 2,50 0.96/24 0.88/8 1.00/12 0.92/12
2013-02-24 Lyon 3-1 Lorient 43/19 2,68 1.92/25 1.63/8 2.17/12 1.69/13   41/2 3,20 1.56/25 1.50/8 2.00/13 1.08/12
2013-03-02 Lorient 1-1 Valenciennes 42/0 3,23 1.50/26 1.13/8 2.00/13 1.00/13   34/-2 2,69 1.31/26 1.00/8 1.92/13 0.69/13
2013-03-09 AC Ajaccio 1-0 Lorient 29/-8 2,44 1.15/27 1.25/8 1.46/13 0.86/14   43/0 3,19 1.48/27 1.13/8 1.93/14 1.00/13
2013-03-16 Lorient 4-0 Brest 43/-1 3,11 1.43/28 1.13/8 1.93/14 0.93/14   28/-10 2,36 1.04/28 0.63/8 1.29/14 0.79/14
2013-03-30 Bordeaux 1-1 Lorient 28/4 1,79 1.45/29 1.25/8 1.50/14 1.40/15   47/3 3,14 1.48/29 1.13/8 2.00/15 0.93/14
2013-04-07 Lille 5-0 Lorient 43/12 2,47 1.63/30 2.38/8 1.79/14 1.50/16   48/3 3,10 1.47/30 1.25/8 2.00/15 0.93/15
2013-04-13 Lorient 4-1 Bastia 48/-2 3,16 1.42/31 1.13/8 2.00/15 0.88/16   42/-14 3,16 1.26/31 1.63/8 1.67/15 0.88/16
2013-04-21 Toulouse 0-1 Lorient 40/-1 2,53 1.28/32 1.25/8 1.38/16 1.19/16   52/1 3,22 1.47/32 1.38/8 2.06/16 0.88/16
2013-04-27 Lorient 0-1 Marseille 53/2 3,15 1.52/33 1.38/8 2.06/16 1.00/17   37/5 2,09 1.85/33 1.88/8 2.06/16 1.65/17
2013-05-04 Sochaux 1-0 Lorient 37/-18 2,71 1.00/34 0.88/8 1.18/17 0.82/17   53/1 3,09 1.47/34 1.38/8 1.94/17 1.00/17
2013-05-12 Lorient 3-1 St Etienne 53/0 3,03 1.43/35 1.25/8 1.94/17 0.94/18   56/28 2,40 1.69/35 1.50/8 1.89/18 1.47/17
2013-05-18 Reims 1-0 Lorient 32/-10 2,06 1.08/36 1.50/8 1.56/18 0.61/18   56/2 3,06 1.47/36 1.63/8 2.00/18 0.94/18
2013-05-26 Lorient 1-3 PSG 56/1 3,00 1.43/37 1.25/8 2.00/18 0.89/19   66/44 2,38 2.16/37 2.75/8 2.26/19 2.06/18
2018-10-21 Paris SG 0-1 Lorient 9/3 1,25 1.75/12 1.50/8 0.00/5 3.00/7   57/-1 3,03 1.39/38 1.13/8 1.89/19 0.89/19
2018-10-21 Lorient 0-1 Paris SG 58/0 2,97 1.44/39 1.13/8 1.89/19 1.00/20   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Lorient 0-1 Evian TG 58/-1 2,93 1.40/40 1.13/8 1.80/20 1.00/20   16/0 1,00 1.50/32 1.13/8 0.00/16 3.00/16
2018-10-21 Evian TG 0-1 Lorient 7/2 1,00 1.75/12 1.13/8 0.00/5 3.00/7   58/-2 2,88 1.37/41 1.13/8 1.71/21 1.00/20