SELECT * FROM 1_Kampe WHERE LigaID = '90' AND (Home='Lens' OR Away='Lens') 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-07-29

Niort

0-0

Lens

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-05

Lens

2-2

Tours

0/0

0,00

1.00/1

1.00/1

0.00/0

1.00/1

0/0

0,00

1.00/1

1.00/1

1.00/1

0.00/0

2016-08-15

Nimes

0-2

Lens

0/-1

0,50

0.50/2

0.50/2

1.00/1

0.00/1

2/0

2,00

1.00/2

1.00/2

1.00/1

1.00/1

2016-08-20

Lens

0-1

Amiens

4/2

2,00

1.67/3

1.67/3

1.00/1

2.00/2

3/1

1,67

1.33/3

1.33/3

2.00/2

0.00/1

2016-08-26

Troyes

1-1

Lens

6/0

3,00

1.50/4

1.50/4

1.50/2

1.50/2

4/1

1,75

1.25/4

1.25/4

0.50/2

2.00/2

2016-09-09

Lens

1-1

Bourg en Bresse

5/1

1,80

1.20/5

1.20/5

0.50/2

1.67/3

5/-5

3,00

0.40/5

0.40/5

0.67/3

0.00/2

2016-09-16

Clermont

1-1

Lens

6/1

1,83

1.67/6

1.67/6

1.33/3

2.00/3

6/1

1,83

1.17/6

1.17/6

0.67/3

1.67/3

2016-09-20

Lens

4-2

Orleans

7/1

1,86

1.14/7

1.14/7

0.67/3

1.50/4

7/0

2,00

1.14/7

1.14/7

1.75/4

0.33/3

2016-09-24

Valenciennes

1-2

Lens

9/3

1,88

1.38/8

1.38/8

2.00/4

0.75/4

11/3

2,38

1.38/8

1.38/8

1.25/4

1.50/4

2016-09-30

Lens

2-0

Red Star

13/4

2,44

1.56/9

1.63/8

1.25/4

1.80/5

4/-3

1,22

1.11/9

1.13/8

1.00/5

1.25/4

2016-10-17

Sochaux

1-0

Lens

11/3

1,90

1.50/10

1.38/8

1.40/5

1.60/5

15/6

2,40

1.70/10

1.88/8

1.60/5

1.80/5

2016-10-22

Lens

1-1

Reims

15/5

2,27

1.55/11

1.50/8

1.60/5

1.50/6

14/6

2,00

1.73/11

1.75/8

3.00/5

0.67/6

2016-10-31

Brest

1-2

Lens

18/7

2,42

2.08/12

1.88/8

2.50/6

1.67/6

16/5

2,25

1.50/12

1.63/8

1.50/6

1.50/6

2016-11-07

Lens

1-1

AC Ajaccio

18/6

2,31

1.62/13

1.88/8

1.50/6

1.71/7

13/-3

2,23

1.15/13

1.00/8

1.86/7

0.33/6

2016-11-18

Auxerre

1-1

Lens

8/-10

1,86

0.71/14

0.50/8

0.67/6

0.75/8

19/6

2,29

1.57/14

1.88/8

1.43/7

1.71/7

2016-11-25

Lens

1-0

Le Havre

20/6

2,27

1.53/15

1.88/8

1.43/7

1.63/8

18/6

2,00

1.73/15

2.13/8

1.71/7

1.75/8

2016-11-29

Laval

0-1

Lens

11/-5

1,69

0.88/16

1.00/8

0.86/7

0.89/9

21/7

2,19

1.63/16

1.88/8

1.63/8

1.63/8

2016-12-10

Strasbourg

3-1

Lens

19/1

2,18

1.53/17

1.50/8

1.75/8

1.33/9

22/8

2,12

1.71/17

1.88/8

1.63/8

1.78/9

2016-12-17

Lens

2-1

GFC Ajaccio

23/6

2,22

1.61/18

1.50/8

1.63/8

1.60/10

18/2

1,89

1.33/18

1.25/8

1.44/9

1.22/9

2017-01-13

Tours

2-3

Lens

22/-8

2,74

0.95/19

1.38/8

0.90/10

1.00/9

25/7

2,26

1.68/19

1.88/8

1.78/9

1.60/10

2017-01-21

Lens

1-3

Nimes

28/8

2,40

1.75/20

2.13/8

1.78/9

1.73/11

27/3

2,55

1.30/20

1.38/8

0.90/10

1.70/10

2017-01-28

Amiens

2-1

Lens

28/8

2,29

1.52/21

1.25/8

1.60/10

1.45/11

29/6

2,48

1.67/21

1.75/8

1.60/10

1.73/11

2017-02-03

Lens

0-0

Troyes

30/5

2,50

1.59/22

1.63/8

1.60/10

1.58/12

27/3

2,32

1.59/22

1.25/8

2.00/12

1.10/10

2017-02-07

Bourg en Bresse

0-0

Lens

30/2

2,52

1.35/23

1.88/8

1.67/12

1.00/11

30/5

2,39

1.57/23

1.63/8

1.55/11

1.58/12

2017-02-13

Lens

3-1

Clermont

30/5

2,29

1.54/24

1.38/8

1.55/11

1.54/13

28/2

2,25

1.25/24

1.25/8

1.42/12

1.08/12

2017-02-20

Orleans

2-1

Lens

22/-10

2,16

0.96/25

1.25/8

1.46/13

0.42/12

33/7

2,36

1.60/25

1.38/8

1.67/12

1.54/13

2017-02-25

Lens

2-0

Valenciennes

34/6

2,38

1.54/26

1.38/8

1.67/12

1.43/14

33/1

2,50

1.19/26

1.00/8

1.38/13

1.00/13

2017-03-03

Red Star

2-3

Lens

26/-8

2,22

1.15/27

1.50/8

1.21/14

1.08/13

36/8

2,37

1.59/27

1.38/8

1.77/13

1.43/14

2017-03-13

Lens

2-1

Sochaux

39/9

2,46

1.64/28

1.38/8

1.77/13

1.53/15

26/1

1,82

1.36/28

0.75/8

1.36/14

1.36/14

2017-03-18

Reims

0-2

Lens

33/10

1,93

1.69/29

1.88/8

2.14/14

1.27/15

41/10

2,48

1.69/29

1.75/8

1.86/14

1.53/15

2017-04-01

Lens

0-2

Brest

43/12

2,47

1.73/30

2.13/8

1.86/14

1.63/16

40/7

2,43

1.73/30

1.38/8

1.87/15

1.60/15

2017-04-10

AC Ajaccio

3-6

Lens

33/-7

2,35

1.26/31

1.13/8

1.87/15

0.69/16

43/10

2,45

1.68/31

2.00/8

1.73/15

1.63/16

2017-04-15

Lens

0-1

Auxerre

49/13

2,66

1.72/32

2.25/8

1.73/15

1.71/17

22/-14

1,81

1.00/32

1.25/8

1.13/16

0.88/16

2017-04-24

Le Havre

1-0

Lens

30/2

1,76

1.33/33

1.38/8

1.44/16

1.24/17

49/12

2,61

1.67/33

1.88/8

1.63/16

1.71/17

2017-05-01

Lens

2-0

Laval

49/11

2,56

1.62/34

1.88/8

1.63/16

1.61/18

31/-11

2,15

0.88/34

0.75/8

1.00/17

0.76/17

2017-05-08

Lens

1-1

Strasbourg

51/13

2,54

1.66/35

1.88/8

1.71/17

1.61/18

58/15

2,89

1.77/35

2.38/8

2.28/18

1.24/17

2017-05-12

GFC Ajaccio

0-4

Lens

45/4

2,39

1.42/36

1.75/8

1.61/18

1.22/18

52/13

2,53

1.64/36

1.63/8

1.67/18

1.61/18

2017-05-19

Lens

3-1

Niort

56/17

2,57

1.68/37

1.63/8

1.67/18

1.68/19

44/-10

2,65

1.32/37

1.13/8

1.58/19

1.06/18