SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='Lokeren' OR Away='Lokeren') 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-30 St. Truiden 1-0 Lokeren 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-07 Lokeren 3-0 Westerlo 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-14 Club Brugge KV 1-0 Lokeren 2/1 1,50 1.50/2 1.50/2 0.00/0 1.50/2   3/2 2,00 1.50/2 1.50/2 3.00/1 0.00/1
2016-08-21 Lokeren 0-3 Genk 3/1 1,67 1.00/3 1.00/3 3.00/1 0.00/2   6/0 3,00 1.25/4 1.25/4 1.67/3 0.00/1
2016-08-27 Lokeren 2-1 Mouscron 3/-2 2,00 0.75/4 0.75/4 1.50/2 0.00/2   4/-2 2,50 0.75/4 0.75/4 1.00/3 0.00/1
2016-09-11 Gent 3-0 Lokeren 9/3 3,00 1.80/5 1.80/5 3.00/2 1.00/3   5/-1 2,20 1.20/5 1.20/5 2.00/3 0.00/2
2016-09-18 Lokeren 0-1 St. Liege 5/-4 2,33 1.00/6 1.00/6 2.00/3 0.00/3   8/3 2,17 1.50/6 1.50/6 2.33/3 0.67/3
2016-09-24 Waasland-Beveren 1-1 Lokeren 7/-6 2,86 0.71/7 0.71/7 1.33/3 0.25/4   5/-5 2,14 0.86/7 0.86/7 1.50/4 0.00/3
2016-09-24 Beveren 1-1 Lokeren 7/-6 2,86 0.71/7 0.71/7 1.33/3 0.25/4   6/-5 2,13 0.88/8 1.00/8 1.50/4 0.25/4
2016-10-01 Lokeren 2-1 Kortrijk 7/-5 2,11 0.89/9 1.00/8 1.50/4 0.40/5   15/3 3,38 1.75/8 1.75/8 2.50/4 1.00/4
2016-10-16 Anderlecht 1-0 Lokeren 18/8 3,11 2.00/9 1.88/8 1.75/4 2.20/5   9/-4 2,20 1.10/10 1.00/8 1.80/5 0.40/5
2016-10-22 Waregem 2-0 Lokeren 20/10 2,73 2.09/11 1.75/8 2.20/5 2.00/6   9/-5 2,09 1.00/11 1.00/8 1.80/5 0.33/6
2016-10-25 Lokeren 1-2 Oostende 9/-7 2,08 0.92/12 1.00/8 1.80/5 0.29/7   19/3 2,92 1.75/12 1.75/8 2.43/7 0.80/5
2016-10-29 Eupen 2-2 Lokeren 19/-14 4,00 0.85/13 0.88/8 1.40/5 0.50/8   10/-8 2,15 0.85/13 0.63/8 1.50/6 0.29/7
2016-11-05 Lokeren 0-0 KV Mechelen 12/-8 2,29 0.86/14 0.75/8 1.50/6 0.38/8   19/2 2,57 1.36/14 1.25/8 1.43/7 1.29/7
2016-11-20 Charleroi 2-1 Lokeren 18/5 2,07 1.80/15 1.63/8 2.50/8 1.00/7   12/-8 2,13 0.87/15 0.88/8 1.43/7 0.38/8
2016-11-26 Lokeren 1-0 St. Truiden 13/-9 2,19 0.81/16 0.75/8 1.43/7 0.33/9   20/-6 2,88 0.81/16 0.38/8 1.33/9 0.14/7
2016-12-04 Genk 1-2 Lokeren 22/-5 2,88 1.47/17 1.75/8 2.22/9 0.63/8   14/-8 2,12 0.94/17 1.00/8 1.63/8 0.33/9
2016-12-09 Lokeren 1-1 Waregem 16/-7 2,17 1.06/18 1.00/8 1.63/8 0.60/10   32/13 2,68 2.00/19 1.88/8 2.00/10 2.00/9
2016-12-17 Westerlo 1-3 Lokeren 20/-22 3,26 0.74/19 0.38/8 1.00/9 0.50/10   17/-7 2,16 1.05/19 1.13/8 1.56/9 0.60/10
2016-12-21 St. Liege 1-1 Lokeren 38/18 2,90 1.60/20 1.25/8 2.50/10 0.70/10   20/-5 2,25 1.15/20 1.50/8 1.56/9 0.82/11
2016-12-26 Lokeren 0-0 Waasland-Beveren 21/-5 2,24 1.14/21 1.63/8 1.56/9 0.83/12   19/-12 2,63 0.95/19 1.13/8 1.60/10 0.22/9
2016-12-26 Lokeren 0-0 Beveren 21/-5 2,14 1.14/22 1.63/8 1.50/10 0.83/12   19/-12 2,63 0.95/19 1.13/8 1.60/10 0.22/9
2017-01-21 Mouscron 2-1 Lokeren 18/-25 2,77 0.59/22 0.13/8 0.50/10 0.67/12   21/-5 2,04 1.13/23 1.63/8 1.45/11 0.83/12
2017-01-25 Lokeren 0-0 Gent 22/-6 2,08 1.08/24 1.63/8 1.45/11 0.77/13   34/11 2,48 1.65/23 1.38/8 2.58/12 0.64/11
2017-01-28 Kortrijk 2-1 Lokeren 32/-15 3,29 1.04/24 0.00/8 1.36/11 0.77/13   22/-6 2,00 1.08/25 1.38/8 1.42/12 0.77/13
2017-02-03 Lokeren 0-0 Anderlecht 23/-7 2,04 1.04/26 1.00/8 1.42/12 0.71/14   53/27 3,16 1.92/25 2.50/8 2.08/12 1.77/13
2017-02-12 Lokeren 1-0 Club Brugge KV 23/-7 1,96 1.04/27 1.00/8 1.38/13 0.71/14   48/28 2,52 2.04/27 2.63/8 2.71/14 1.31/13
2017-02-18 KV Mechelen 3-0 Lokeren 37/6 2,43 1.61/28 1.63/8 2.00/14 1.21/14   24/-6 1,93 1.11/28 1.00/8 1.50/14 0.71/14
2017-02-25 Lokeren 1-2 Eupen 24/-9 1,97 1.07/29 0.88/8 1.50/14 0.67/15   38/-26 3,52 0.93/29 1.25/8 1.13/15 0.71/14
2017-03-04 Oostende 0-0 Lokeren 53/17 2,97 1.80/30 1.88/8 2.00/15 1.60/15   25/-10 2,00 1.03/30 0.75/8 1.40/15 0.67/15
2017-03-12 Lokeren 0-0 Charleroi 25/-10 1,94 1.03/31 0.75/8 1.40/15 0.69/16   35/9 1,97 1.74/31 1.75/8 2.25/16 1.20/15