| 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 |
SELECT * FROM 1_Kampe WHERE LigaID = '89' AND (Home='Lens' OR Away='Lens') ORDER BY Dato ASC;
| 2017-07-31 |
Auxerre |
1-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 |
| 2017-08-04 |
Lens |
1-2 |
Nimes |
0/-1 |
1,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 |
| 2017-08-12 |
Sochaux |
3-2 |
Lens |
3/2 |
2,00 |
2.00/2 |
2.00/2 |
3.00/1 |
1.00/1 |
|
1/-2 |
2,00 |
0.00/2 |
0.00/2 |
0.00/1 |
0.00/1 |
| 2017-08-19 |
Lens |
2-4 |
Brest |
3/-3 |
3,00 |
0.00/3 |
0.00/3 |
0.00/1 |
0.00/2 |
|
3/-2 |
2,67 |
0.33/3 |
0.33/3 |
0.50/2 |
0.00/1 |
| 2017-08-28 |
Orleans |
2-0 |
Lens |
6/2 |
2,50 |
1.75/4 |
1.75/4 |
2.00/2 |
1.50/2 |
|
5/-5 |
3,75 |
0.00/4 |
0.00/4 |
0.00/2 |
0.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 |
Valenciennes |
1-0 |
Lens |
6/0 |
2,00 |
1.33/6 |
1.33/6 |
1.67/3 |
1.00/3 |
|
7/-8 |
3,67 |
0.00/6 |
0.00/6 |
0.00/3 |
0.00/3 |
| 2017-09-18 |
Lens |
2-0 |
Quevilly Rouen |
7/-9 |
3,29 |
0.00/7 |
0.00/7 |
0.00/3 |
0.00/4 |
|
7/-5 |
2,71 |
0.71/7 |
0.71/7 |
1.00/4 |
0.33/3 |
| 2017-09-25 |
Clermont |
1-0 |
Lens |
11/6 |
2,00 |
1.75/8 |
1.75/8 |
2.00/3 |
1.60/5 |
|
9/-7 |
3,13 |
0.38/8 |
0.38/8 |
0.75/4 |
0.00/4 |
| 2017-09-29 |
Lens |
2-0 |
GFC Ajaccio |
9/-8 |
2,89 |
0.33/9 |
0.38/8 |
0.75/4 |
0.00/5 |
|
6/-5 |
1,89 |
1.33/9 |
1.38/8 |
2.00/5 |
0.50/4 |
| 2017-10-13 |
Bourg en Bresse |
0-6 |
Lens |
14/-3 |
3,10 |
1.20/10 |
1.50/8 |
2.25/4 |
0.50/6 |
|
11/-6 |
2,80 |
0.60/10 |
0.75/8 |
1.20/5 |
0.00/5 |
| 2017-10-21 |
Lens |
0-1 |
Reims |
17/0 |
3,09 |
0.82/11 |
1.13/8 |
1.20/5 |
0.50/6 |
|
21/12 |
2,73 |
2.18/11 |
1.88/8 |
2.40/5 |
2.00/6 |
| 2017-10-30 |
Chateauroux |
0-0 |
Lens |
18/-4 |
3,33 |
1.33/12 |
1.25/8 |
1.80/5 |
1.00/7 |
|
17/-1 |
2,92 |
0.75/12 |
1.13/8 |
1.00/6 |
0.50/6 |
| 2017-11-04 |
Nancy |
1-1 |
Lens |
16/-2 |
2,62 |
1.08/13 |
1.38/8 |
2.00/6 |
0.29/7 |
|
17/-1 |
2,69 |
0.77/13 |
1.25/8 |
1.00/6 |
0.57/7 |
| 2017-11-20 |
Lens |
3-1 |
Niort |
18/-1 |
2,64 |
0.79/14 |
1.38/8 |
1.00/6 |
0.63/8 |
|
17/0 |
2,43 |
1.36/14 |
1.38/8 |
1.75/8 |
0.83/6 |
| 2017-11-25 |
Le Havre |
1-0 |
Lens |
21/8 |
2,27 |
1.67/15 |
1.50/8 |
2.14/7 |
1.25/8 |
|
21/1 |
2,73 |
0.93/15 |
1.75/8 |
1.29/7 |
0.63/8 |
| 2017-11-28 |
Lens |
2-0 |
AC Ajaccio |
21/0 |
2,63 |
0.88/16 |
1.38/8 |
1.29/7 |
0.56/9 |
|
26/11 |
2,56 |
1.75/16 |
1.75/8 |
1.88/8 |
1.63/8 |
| 2017-12-08 |
Paris FC |
2-2 |
Lens |
19/5 |
1,94 |
1.76/17 |
1.63/8 |
2.22/9 |
1.25/8 |
|
23/2 |
2,59 |
1.00/17 |
1.75/8 |
1.50/8 |
0.56/9 |
| 2017-12-18 |
Lens |
2-0 |
Tours |
25/2 |
2,67 |
1.00/18 |
1.50/8 |
1.50/8 |
0.60/10 |
|
10/-27 |
2,61 |
0.28/18 |
0.38/8 |
0.33/9 |
0.22/9 |
| 2018-01-12 |
Nimes |
0-1 |
Lens |
40/22 |
3,22 |
2.06/18 |
2.63/8 |
2.20/10 |
1.88/8 |
|
27/4 |
2,63 |
1.11/19 |
1.50/8 |
1.67/9 |
0.60/10 |
| 2018-01-19 |
Brest |
1-1 |
Lens |
32/6 |
2,76 |
1.67/21 |
1.75/8 |
1.50/10 |
1.82/11 |
|
28/5 |
2,55 |
1.20/20 |
1.88/8 |
1.67/9 |
0.82/11 |
| 2018-01-26 |
Lens |
0-1 |
Orleans |
29/5 |
2,52 |
1.19/21 |
1.88/8 |
1.67/9 |
0.83/12 |
|
28/-6 |
2,82 |
1.09/22 |
0.63/8 |
1.25/12 |
0.90/10 |
| 2018-01-30 |
Lens |
0-1 |
Sochaux |
29/4 |
2,45 |
1.14/22 |
1.75/8 |
1.50/10 |
0.83/12 |
|
30/-4 |
2,91 |
1.55/22 |
1.63/8 |
1.91/11 |
1.18/11 |
| 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-10 |
Lens |
1-1 |
Valenciennes |
30/3 |
2,38 |
1.08/24 |
1.50/8 |
1.36/11 |
0.85/13 |
|
30/-9 |
2,88 |
1.21/24 |
0.63/8 |
1.31/13 |
1.09/11 |
| 2018-02-19 |
Quevilly Rouen |
1-2 |
Lens |
27/-15 |
2,76 |
0.88/25 |
1.38/8 |
0.83/12 |
0.92/13 |
|
31/3 |
2,36 |
1.08/25 |
1.25/8 |
1.33/12 |
0.85/13 |
| 2018-02-23 |
Lens |
0-1 |
Clermont |
33/4 |
2,38 |
1.15/26 |
1.50/8 |
1.33/12 |
1.00/14 |
|
33/12 |
2,08 |
1.62/26 |
1.63/8 |
1.85/13 |
1.38/13 |
| 2018-03-02 |
GFC Ajaccio |
1-1 |
Lens |
22/-18 |
2,30 |
1.11/27 |
0.88/8 |
1.46/13 |
0.79/14 |
|
33/3 |
2,33 |
1.11/27 |
1.13/8 |
1.23/13 |
1.00/14 |
| 2018-03-12 |
Lens |
0-1 |
Bourg en Bresse |
34/3 |
2,32 |
1.11/28 |
0.88/8 |
1.23/13 |
1.00/15 |
|
38/-24 |
3,57 |
0.96/28 |
1.25/8 |
1.43/14 |
0.50/14 |
| 2018-03-17 |
Reims |
3-1 |
Lens |
53/36 |
2,41 |
2.28/29 |
2.00/8 |
2.43/14 |
2.13/15 |
|
34/2 |
2,28 |
1.07/29 |
0.75/8 |
1.14/14 |
1.00/15 |
| 2018-04-02 |
Lens |
2-1 |
Chateauroux |
35/0 |
2,33 |
1.03/30 |
0.75/8 |
1.14/14 |
0.94/16 |
|
42/2 |
2,73 |
1.70/30 |
2.13/8 |
2.07/15 |
1.33/15 |
| 2018-04-09 |
Lens |
1-1 |
Nancy |
37/1 |
2,35 |
1.10/31 |
1.13/8 |
1.27/15 |
0.94/16 |
|
29/-15 |
2,35 |
0.90/31 |
0.75/8 |
1.13/16 |
0.67/15 |
| 2018-04-13 |
Niort |
2-2 |
Lens |
37/-12 |
2,69 |
1.16/32 |
1.00/8 |
1.19/16 |
1.13/16 |
|
38/1 |
2,34 |
1.09/32 |
1.13/8 |
1.25/16 |
0.94/16 |
| 2018-04-20 |
Lens |
3-3 |
Le Havre |
40/1 |
2,39 |
1.09/33 |
1.13/8 |
1.25/16 |
0.94/17 |
|
41/10 |
2,25 |
1.56/32 |
1.25/8 |
2.19/16 |
0.94/16 |
| 2018-04-23 |
AC Ajaccio |
2-0 |
Lens |
57/19 |
2,79 |
1.85/34 |
2.25/8 |
2.35/17 |
1.35/17 |
|
43/1 |
2,50 |
1.09/34 |
0.88/8 |
1.24/17 |
0.94/17 |
| 2018-04-30 |
Lens |
1-0 |
Paris FC |
43/-1 |
2,49 |
1.06/35 |
0.88/8 |
1.24/17 |
0.89/18 |
|
42/10 |
2,11 |
1.63/35 |
1.38/8 |
1.78/18 |
1.47/17 |
| 2018-05-04 |
Tours |
4-2 |
Lens |
30/-34 |
2,61 |
0.56/36 |
0.75/8 |
0.67/18 |
0.44/18 |
|
44/0 |
2,44 |
1.11/36 |
1.13/8 |
1.33/18 |
0.89/18 |
| 2018-05-11 |
Lens |
2-1 |
Auxerre |
46/-2 |
2,54 |
1.08/37 |
1.13/8 |
1.33/18 |
0.84/19 |
|
50/-3 |
2,78 |
1.27/37 |
0.88/8 |
1.42/19 |
1.11/18 |