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
2018-10-21 Lens 0-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
2018-10-21 Strasbourg 0-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
2018-10-21 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
2018-10-21 Lens 0-1 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
2018-10-21 Auxerre 0-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
2018-10-21 Lens 0-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
2018-10-21 Brest 0-1 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
2018-10-21 Lens 0-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
2018-10-21 Sochaux 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Valenciennes 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Clermont 0-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
2018-10-21 Lens 0-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
2018-10-21 Troyes 0-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
2018-10-21 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
2018-10-21 Nimes 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Lens 0-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
2018-10-21 Tours 0-1 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
2018-10-21 GFC Ajaccio 0-1 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
2018-10-21 Lens 0-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
2018-10-21 Lens 0-1 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
2018-10-21 Le Havre 0-1 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
2018-10-21 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
2018-10-21 AC Ajaccio 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Reims 0-1 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
2018-10-21 Lens 0-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
2018-10-21 Red Star 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Orleans 0-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
2018-10-21 Lens 0-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
2018-10-21 Bourg en Bresse 0-1 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
2018-10-21 Lens 0-1 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
2018-10-21 Amiens 0-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
2018-10-21 Lens 0-1 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
2018-10-21 Niort 0-1 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