SELECT * FROM 1_Kampe WHERE LigaID = '89' 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

2017-07-29

Lorient

1-1

Quevilly Rouen

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

2017-08-04

GFC Ajaccio

0-0

Lorient

1/0

2,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

2017-08-14

Lorient

3-0

Chateauroux

1/0

1,00

1.00/2

1.00/2

1.00/1

1.00/1

3/0

3,00

1.50/2

1.50/2

0.00/1

3.00/1

2017-08-18

Clermont

0-2

Lorient

2/2

0,67

1.67/3

1.67/3

3.00/1

1.00/2

4/3

1,67

1.67/3

1.67/3

2.00/2

1.00/1

2017-08-26

Lorient

2-1

Reims

6/5

1,75

2.00/4

2.00/4

2.00/2

2.00/2

7/7

1,75

3.00/4

3.00/4

3.00/2

3.00/2

2017-09-09

Lens

2-3

Lorient

5/-7

3,40

0.00/5

0.00/5

0.00/2

0.00/3

8/6

2,00

2.20/5

2.20/5

2.33/3

2.00/2

2017-09-15

Lorient

2-0

AC Ajaccio

11/7

2,50

2.33/6

2.33/6

2.33/3

2.33/3

8/2

2,33

1.83/6

1.83/6

2.00/3

1.67/3

2017-09-19

Auxerre

1-0

Lorient

5/-10

2,86

0.57/7

0.57/7

1.33/3

0.00/4

13/9

2,43

2.43/7

2.43/7

2.50/4

2.33/3

2017-09-23

Lorient

0-0

Nancy

13/8

2,25

2.13/8

2.13/8

2.50/4

1.75/4

9/-1

2,38

1.13/8

1.13/8

2.00/4

0.25/4

2017-10-02

Le Havre

3-2

Lorient

14/8

2,22

1.78/9

1.63/8

2.50/4

1.20/5

13/8

2,00

2.00/9

2.13/8

2.20/5

1.75/4

2017-10-16

Lorient

0-0

Niort

15/7

2,30

1.80/10

2.00/8

2.20/5

1.40/5

13/-1

2,70

1.40/10

1.50/8

1.67/6

1.00/4

2017-10-20

Orleans

1-2

Lorient

17/1

3,00

1.36/11

1.38/8

1.83/6

0.80/5

15/7

2,09

1.73/11

1.75/8

2.00/6

1.40/5

2017-10-28

Lorient

2-0

Tours

17/8

2,17

1.83/12

1.75/8

2.00/6

1.67/6

5/-19

2,42

0.17/12

0.25/8

0.00/6

0.33/6

2017-11-03

Paris FC

1-1

Lorient

15/3

2,08

1.85/13

2.13/8

2.29/7

1.33/6

19/10

2,15

1.92/13

1.75/8

2.14/7

1.67/6

2017-11-18

Lorient

4-2

Brest

20/10

2,14

1.86/14

1.50/8

2.14/7

1.57/7

17/1

2,36

1.57/14

1.50/8

1.29/7

1.86/7

2017-11-24

Valenciennes

4-2

Lorient

19/-1

2,60

1.40/15

1.25/8

1.50/8

1.29/7

24/12

2,40

1.93/15

1.50/8

2.25/8

1.57/7

2017-11-28

Lorient

1-2

Nimes

26/10

2,63

1.81/16

1.50/8

2.25/8

1.38/8

35/19

3,19

1.94/16

1.88/8

2.11/9

1.71/7

2017-12-08

Lorient

2-1

Sochaux

27/9

2,65

1.71/17

1.38/8

2.00/9

1.38/8

25/-5

3,24

1.59/17

2.00/8

2.00/9

1.13/8

2017-12-15

Bourg en Bresse

2-2

Lorient

22/-17

3,39

0.89/18

0.50/8

1.63/8

0.30/10

29/10

2,67

1.78/18

1.75/8

2.10/10

1.38/8

2018-01-13

Lorient

4-1

GFC Ajaccio

31/10

2,74

1.74/19

1.75/8

2.10/10

1.33/9

12/-10

1,89

1.28/18

1.38/8

1.67/9

0.89/9

2018-01-16

Chateauroux

3-1

Lorient

26/-1

2,65

1.55/20

1.88/8

1.67/9

1.45/11

35/13

2,85

1.80/20

1.75/8

2.18/11

1.33/9

2018-01-19

Lorient

1-1

Clermont

36/11

2,90

1.71/21

1.38/8

2.18/11

1.20/10

27/9

2,14

1.57/21

1.38/8

1.90/10

1.27/11

2018-01-29

Reims

0-1

Lorient

41/29

2,41

2.41/22

2.75/8

2.50/10

2.33/12

37/11

2,86

1.68/22

1.38/8

2.08/12

1.20/10

2018-02-03

Lorient

1-1

Lens

38/12

2,78

1.74/23

1.38/8

2.08/12

1.36/11

29/3

2,39

1.09/23

1.38/8

1.36/11

0.83/12

2018-02-09

AC Ajaccio

3-2

Lorient

38/13

2,63

1.75/24

1.75/8

2.08/12

1.42/12

39/12

2,75

1.71/24

1.50/8

2.00/13

1.36/11

2018-02-17

Lorient

1-3

Auxerre

41/11

2,84

1.64/25

1.50/8

2.00/13

1.25/12

29/-3

2,44

1.24/25

1.50/8

1.54/13

0.92/12

2018-02-26

Nancy

0-2

Lorient

28/-9

2,50

0.96/26

0.63/8

1.15/13

0.77/13

42/9

2,88

1.58/26

1.13/8

1.86/14

1.25/12

2018-03-05

Lorient

1-0

Le Havre

44/11

2,85

1.63/27

1.38/8

1.86/14

1.38/13

36/12

2,22

1.63/27

1.25/8

2.23/13

1.07/14

2018-03-09

Niort

1-2

Lorient

32/-12

2,71

1.14/28

0.75/8

1.29/14

1.00/14

45/12

2,79

1.68/28

1.38/8

1.93/15

1.38/13

2018-03-16

Lorient

3-1

Orleans

47/13

2,79

1.72/29

1.75/8

1.93/15

1.50/14

38/-5

2,79

1.31/29

1.75/8

1.27/15

1.36/14

2018-03-30

Tours

3-1

Lorient

20/-31

2,45

0.52/29

1.13/8

0.57/14

0.47/15

50/15

2,83

1.77/30

2.00/8

2.00/16

1.50/14

2018-04-06

Lorient

2-0

Paris FC

51/13

2,87

1.71/31

1.63/8

2.00/16

1.40/15

38/11

2,10

1.71/31

1.38/8

1.94/16

1.47/15

2018-04-16

Brest

3-0

Lorient

45/7

2,59

1.59/32

1.63/8

1.44/16

1.75/16

53/15

2,84

1.75/32

1.88/8

2.06/17

1.40/15

2018-04-20

Lorient

0-1

Valenciennes

53/12

2,85

1.70/33

1.88/8

2.06/17

1.31/16

40/-14

2,85

1.12/33

0.88/8

1.24/17

1.00/16

2018-04-24

Nimes

1-0

Lorient

67/33

2,97

1.91/34

2.38/8

1.94/17

1.88/17

53/11

2,79

1.65/34

1.88/8

1.94/18

1.31/16

2018-04-27

Sochaux

0-2

Lorient

49/-6

2,97

1.51/35

1.25/8

1.88/17

1.17/18

53/10

2,74

1.60/35

1.50/8

1.94/18

1.24/17

2018-05-04

Lorient

6-0

Bourg en Bresse

55/12

2,72

1.64/36

1.50/8

1.94/18

1.33/18

48/-32

3,56

0.92/36

0.75/8

1.22/18

0.61/18

2018-05-11

Quevilly Rouen

3-0

Lorient

42/-24

2,92

0.81/37

1.00/8

0.78/18

0.84/19

61/18

2,81

1.68/37

1.50/8

2.00/19

1.33/18