SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='KV Mechelen' OR Away='KV Mechelen') 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 KV Mechelen 0-2 Club Brugge KV 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-06 Eupen 0-2 KV Mechelen 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-2 2,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-13 KV Mechelen 0-0 Kortrijk 2/0 2,00 1.50/2 1.50/2 0.00/1 3.00/1   2/-4 4,00 0.50/2 0.50/2 1.00/1 0.00/1
2016-08-20 Beveren 2-2 KV Mechelen 2/-3 2,33 0.33/3 0.33/3 0.00/1 0.50/2   2/0 1,33 1.33/3 1.33/3 0.50/2 3.00/1
2016-08-20 Waasland-Beveren 2-2 KV Mechelen 2/-3 2,33 0.33/3 0.33/3 0.00/1 0.50/2   4/0 2,00 1.25/4 1.20/5 0.50/2 2.00/2
2016-08-27 Westerlo 1-2 KV Mechelen 5/-6 4,00 0.25/4 0.25/4 0.50/2 0.00/2   6/0 2,40 1.20/5 1.20/5 0.50/2 1.67/3
2016-09-10 KV Mechelen 2-0 St. Truiden 8/1 2,50 1.50/6 1.50/6 0.50/2 2.00/4   3/-3 1,80 0.80/5 0.80/5 1.33/3 0.00/2
2016-09-16 Charleroi 0-0 KV Mechelen 9/3 2,14 2.00/7 2.00/7 2.50/4 1.33/3   10/3 2,43 1.71/7 1.71/7 1.33/3 2.00/4
2016-09-24 KV Mechelen 2-3 Waregem 10/3 2,13 1.63/8 1.63/8 1.33/3 1.80/5   16/12 2,50 2.38/8 2.38/8 2.50/4 2.25/4
2016-10-02 Genk 2-1 KV Mechelen 11/-3 2,78 1.22/9 1.00/8 1.60/5 0.75/4   12/2 2,44 1.44/9 1.63/8 1.00/4 1.80/5
2016-10-16 KV Mechelen 2-3 Oostende 13/1 2,50 1.30/10 1.25/8 1.00/4 1.50/6   14/2 2,60 1.70/10 1.75/8 2.67/6 0.25/4
2016-10-22 KV Mechelen 2-0 Mouscron 15/0 2,73 1.18/11 1.13/8 0.80/5 1.50/6   15/-5 3,50 1.00/10 1.25/8 0.67/6 1.50/4
2016-10-26 Anderlecht 2-0 KV Mechelen 20/8 2,91 1.91/11 1.75/8 2.00/5 1.83/6   17/2 2,67 1.33/12 1.38/8 1.17/6 1.50/6
2016-10-30 KV Mechelen 2-0 Gent 17/0 2,62 1.23/13 1.25/8 1.17/6 1.29/7   20/8 2,67 1.75/12 1.63/8 3.00/6 0.50/6
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 KV Mechelen 2-1 St. Liege 19/2 2,40 1.33/15 1.00/8 1.43/7 1.25/8   28/14 2,80 1.67/15 1.63/8 2.38/8 0.86/7
2016-11-25 Club Brugge KV 6-1 KV Mechelen 21/9 2,06 1.69/16 2.13/8 2.43/7 1.11/9   21/3 2,44 1.44/16 1.25/8 1.63/8 1.25/8
2016-12-02 KV Mechelen 1-0 Eupen 22/-2 2,71 1.35/17 1.25/8 1.63/8 1.11/9   28/-14 4,12 0.94/17 1.13/8 1.50/8 0.44/9
2016-12-10 Mouscron 1-4 KV Mechelen 16/-19 2,83 0.67/18 0.25/8 0.50/8 0.80/10   23/-1 2,61 1.44/18 1.63/8 1.78/9 1.11/9
2016-12-17 KV Mechelen 2-0 Waasland-Beveren 27/2 2,74 1.53/19 2.00/8 1.78/9 1.30/10   16/-12 2,59 0.88/17 1.13/8 1.44/9 0.25/8
2016-12-17 KV Mechelen 2-0 Beveren 29/4 2,70 1.60/20 2.38/8 1.90/10 1.30/10   16/-12 2,59 0.88/17 1.13/8 1.44/9 0.25/8
2016-12-20 KV Mechelen 1-0 Charleroi 31/6 2,67 1.67/21 2.38/8 2.00/11 1.30/10   26/10 2,00 1.90/21 1.75/8 2.36/11 1.40/10
2016-12-26 Waregem 0-0 KV Mechelen 35/14 2,55 1.95/22 1.63/8 2.09/11 1.82/11   32/7 2,59 1.73/22 2.38/8 2.08/12 1.30/10
2017-01-22 KV Mechelen 1-2 Westerlo 32/7 2,48 1.70/23 2.38/8 2.08/12 1.27/11   25/-21 3,23 0.82/22 0.75/8 1.09/11 0.55/11
2017-01-25 St. Truiden 2-1 KV Mechelen 30/-9 2,88 0.96/24 1.25/8 1.58/12 0.33/12   33/6 2,50 1.63/24 2.00/8 1.92/13 1.27/11
2017-01-28 KV Mechelen 1-0 Genk 34/5 2,52 1.56/25 2.00/8 1.92/13 1.17/12   31/-1 2,74 1.52/23 1.63/8 2.08/13 0.80/10
2017-02-04 Oostende 2-0 KV Mechelen 44/13 2,88 1.73/26 1.38/8 2.08/13 1.38/13   35/6 2,46 1.62/26 2.00/8 2.00/14 1.17/12
2017-02-11 Kortrijk 0-2 KV Mechelen 37/-11 3,27 1.19/26 0.75/8 1.50/12 0.93/14   35/4 2,44 1.56/27 1.63/8 2.00/14 1.08/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-26 St. Liege 2-2 KV Mechelen 46/14 2,69 1.48/29 1.25/8 1.93/14 1.07/15   40/9 2,45 1.66/29 1.63/8 2.07/15 1.21/14
2017-03-04 KV Mechelen 3-2 Anderlecht 42/9 2,50 1.63/30 1.38/8 2.07/15 1.20/15   63/34 3,17 2.00/29 2.50/8 2.21/14 1.80/15
2017-03-12 Gent 3-0 KV Mechelen 47/16 2,52 1.71/31 1.88/8 2.47/15 1.00/16   45/10 2,58 1.68/31 1.63/8 2.13/16 1.20/15