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

2012-08-11

Rennes

0-1

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

2012-08-18

Lyon

4-1

Troyes

1/1

1,00

3.00/1

3.00/1

0.00/0

3.00/1

0/-1

1,00

0.00/1

0.00/1

0.00/1

0.00/0

2012-08-24

Thonon-Evian

1-1

Lyon

2/-2

3,00

0.00/2

0.00/2

0.00/1

0.00/1

5/4

3,00

3.00/2

3.00/2

3.00/1

3.00/1

2012-09-01

Lyon

3-2

Valenciennes

6/4

2,67

2.33/3

2.33/3

3.00/1

2.00/2

4/4

1,33

2.33/3

2.33/3

2.00/2

3.00/1

2012-09-16

Lyon

2-0

AC Ajaccio

9/5

3,25

2.50/4

2.50/4

3.00/2

2.00/2

3/0

1,50

1.75/4

1.75/4

2.00/2

1.50/2

2012-09-23

Lille

1-1

Lyon

7/0

2,80

1.20/5

1.20/5

0.50/2

1.67/3

11/7

3,00

2.60/5

2.60/5

3.00/3

2.00/2

2012-09-30

Lyon

0-2

Bordeaux

12/7

2,83

2.33/6

2.33/6

3.00/3

1.67/3

7/2

2,00

1.67/6

1.67/6

1.67/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-21

Lyon

1-0

Brest

13/5

2,63

1.88/8

1.88/8

2.25/4

1.50/4

8/-5

2,63

1.25/8

1.25/8

2.50/4

0.00/4

2012-11-04

Lyon

5-2

Bastia

14/6

2,44

2.00/9

1.88/8

2.40/5

1.50/4

15/-6

3,60

1.40/10

1.00/8

1.80/5

1.00/5

2012-11-11

Sochaux

1-1

Lyon

11/-7

2,64

0.91/11

1.25/8

1.20/5

0.67/6

19/9

2,90

2.10/10

1.88/8

2.50/6

1.50/4

2012-11-18

Lyon

3-0

Reims

20/9

2,82

2.00/11

1.88/8

2.50/6

1.40/5

13/2

2,00

1.25/12

1.38/8

1.86/7

0.40/5

2012-11-25

Toulouse

3-0

Lyon

20/4

2,77

1.46/13

1.38/8

1.50/6

1.43/7

23/12

2,83

2.08/12

1.88/8

2.57/7

1.40/5

2012-11-28

Marseille

1-4

Lyon

17/6

2,15

2.00/13

1.38/8

2.33/6

1.71/7

23/9

2,85

1.92/13

1.50/8

2.57/7

1.17/6

2012-12-01

Lyon

1-0

Montpellier

27/12

3,00

2.00/14

1.75/8

2.57/7

1.43/7

19/1

2,64

1.21/14

1.50/8

1.29/7

1.14/7

2012-12-09

St Etienne

0-1

Lyon

24/14

2,27

1.73/15

2.25/8

2.00/8

1.43/7

28/13

2,87

2.07/15

2.13/8

2.63/8

1.43/7

2012-12-12

Lyon

1-1

Nancy

29/14

2,75

2.13/16

2.38/8

2.63/8

1.63/8

11/-16

2,38

0.56/16

0.63/8

0.67/9

0.43/7

2012-12-16

PSG

1-0

Lyon

32/20

2,59

1.88/17

1.63/8

1.89/9

1.88/8

30/14

2,71

2.06/17

2.13/8

2.44/9

1.63/8

2012-12-22

Lyon

3-0

Nice

30/13

2,61

1.94/18

1.75/8

2.44/9

1.44/9

26/3

2,72

1.61/18

2.50/8

2.10/10

1.00/8

2013-01-12

Troyes

1-2

Lyon

20/-17

3,00

0.68/19

0.75/8

1.10/10

0.22/9

33/16

2,63

2.00/19

2.00/8

2.50/10

1.44/9

2013-01-18

Lyon

0-0

Thonon-Evian

35/17

2,65

2.05/20

2.00/8

2.50/10

1.60/10

22/-12

2,80

0.95/20

1.00/8

1.00/10

0.90/10

2013-01-25

Valenciennes

0-2

Lyon

32/2

2,95

1.43/21

1.00/8

2.10/10

0.82/11

35/17

2,52

2.00/21

2.13/8

2.36/11

1.60/10

2013-02-03

AC Ajaccio

3-1

Lyon

23/-8

2,45

1.09/22

0.88/8

1.30/10

0.92/12

37/19

2,50

2.05/22

2.13/8

2.36/11

1.73/11

2013-02-10

Lyon

1-3

Lille

38/17

2,57

1.96/23

1.75/8

2.36/11

1.58/12

27/3

2,22

1.35/23

1.25/8

1.73/11

1.00/12

2013-02-17

Bordeaux

0-4

Lyon

26/10

1,75

1.58/24

1.50/8

1.64/11

1.54/13

39/15

2,63

1.88/24

1.38/8

2.17/12

1.58/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-03

Brest

1-1

Lyon

27/-9

2,42

1.08/26

0.88/8

1.42/12

0.79/14

46/21

2,73

1.96/26

2.00/8

2.23/13

1.69/13

2013-03-10

Lyon

0-0

Marseille

47/21

2,70

1.93/27

1.75/8

2.23/13

1.64/14

34/2

2,44

1.81/27

1.38/8

2.00/13

1.64/14

2013-03-16

Bastia

4-1

Lyon

30/-22

2,93

1.07/28

0.63/8

1.46/13

0.73/15

47/21

2,61

1.89/28

1.50/8

2.14/14

1.64/14

2013-03-31

Lyon

1-2

Sochaux

48/18

2,69

1.83/29

1.38/8

2.14/14

1.53/15

30/-16

2,62

0.97/29

0.75/8

1.20/15

0.71/14

2013-04-07

Reims

1-0

Lyon

28/-9

2,17

1.03/30

1.38/8

1.60/15

0.47/15

49/17

2,70

1.77/30

1.00/8

2.00/15

1.53/15

2013-04-14

Lyon

3-1

Toulouse

49/16

2,65

1.71/31

1.00/8

2.00/15

1.44/16

39/1

2,48

1.32/31

1.25/8

1.38/16

1.27/15

2013-04-19

Montpellier

1-2

Lyon

49/8

2,81

1.50/32

1.63/8

2.13/16

0.88/16

52/18

2,69

1.75/32

1.38/8

2.06/16

1.44/16

2013-04-28

Lyon

1-1

St Etienne

54/19

2,70

1.79/33

1.38/8

2.06/16

1.53/17

55/28

2,48

1.73/33

2.00/8

1.94/17

1.50/16

2013-05-05

Nancy

0-3

Lyon

33/-16

2,41

1.03/34

2.13/8

1.18/17

0.88/17

55/19

2,68

1.76/34

1.13/8

2.00/17

1.53/17

2013-05-12

Lyon

0-1

PSG

58/22

2,69

1.80/35

1.38/8

2.00/17

1.61/18

62/41

2,37

2.11/35

2.50/8

2.22/18

2.00/17

2013-05-19

Nice

1-1

Lyon

54/9

2,75

1.67/36

1.50/8

2.06/18

1.28/18

58/21

2,64

1.75/36

1.25/8

1.89/18

1.61/18

2013-05-26

Lyon

2-0

Rennes

59/21

2,62

1.73/37

1.38/8

1.89/18

1.58/19

48/-9

2,84

1.24/37

0.50/8

1.21/19

1.28/18

2018-10-21

Lyon

0-1

Paris SG

61/23

2,61

1.76/38

1.75/8

1.95/19

1.58/19

16/2

1,11

1.56/27

1.50/8

0.00/13

3.00/14

2018-10-21

Evian TG

0-1

Lyon

9/2

1,00

1.69/16

1.13/8

0.00/7

3.00/9

61/22

2,56

1.72/39

1.63/8

1.85/20

1.58/19

2018-10-21

Paris SG

0-1

Lyon

12/2

1,16

1.58/19

1.50/8

0.00/9

3.00/10

62/23

2,53

1.75/40

1.63/8

1.85/20

1.65/20

2018-10-21

Lyon

0-1

Evian TG

63/24

2,49

1.78/41

1.63/8

1.85/20

1.71/21

18/0

1,00

1.50/36

1.13/8

0.00/18

3.00/18