SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='St. Truiden' OR Away='St. Truiden') 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-06 St. Liege 2-0 St. Truiden 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-12 St. Truiden 0-0 Anderlecht 1/-1 1,50 1.50/2 1.50/2 3.00/1 0.00/1   7/5 4,50 3.00/2 3.00/2 3.00/1 3.00/1
2016-08-20 Mouscron 2-1 St. Truiden 2/-3 2,33 0.00/3 0.00/3 0.00/2 0.00/1   1/-1 1,00 1.33/3 1.33/3 2.00/2 0.00/1
2016-08-27 St. Truiden 1-2 Kortrijk 2/-2 1,50 1.00/4 1.00/4 2.00/2 0.00/2   4/-3 2,75 1.25/4 1.25/4 2.00/2 0.50/2
2016-09-10 KV Mechelen 2-0 St. Truiden 6/1 2,20 1.60/5 1.60/5 0.50/2 2.33/3   3/-3 1,80 0.80/5 0.80/5 1.33/3 0.00/2
2016-09-17 St. Truiden 4-1 Beveren 3/-5 1,83 0.67/6 0.67/6 1.33/3 0.00/3   6/-3 2,50 0.83/6 0.83/6 1.33/3 0.33/3
2016-09-24 Gent 2-1 St. Truiden 12/5 2,71 1.71/7 1.71/7 3.00/3 0.75/4   7/-2 2,29 1.00/7 1.00/7 1.75/4 0.00/3
2016-09-30 Oostende 2-2 St. Truiden 10/1 2,38 1.63/8 1.63/8 3.00/4 0.25/4   8/-3 2,38 0.88/8 0.88/8 1.75/4 0.00/4
2016-10-15 St. Truiden 2-2 Westerlo 10/-3 2,56 0.89/9 0.63/8 1.75/4 0.20/5   11/-10 3,56 0.78/9 0.75/8 0.80/5 0.75/4
2016-10-23 Genk 1-0 St. Truiden 13/-2 2,80 1.40/10 1.38/8 2.00/5 0.80/5   12/-3 2,70 0.90/10 0.75/8 1.60/5 0.20/5
2016-10-26 St. Truiden 0-2 Waregem 12/-4 2,55 0.82/11 0.63/8 1.60/5 0.17/6   20/10 2,73 2.09/11 1.75/8 2.33/6 1.80/5
2016-10-29 St. Truiden 2-2 Charleroi 12/-6 2,50 0.75/12 0.63/8 1.33/6 0.17/6   14/5 1,92 1.92/12 1.88/8 2.43/7 1.20/5
2016-11-05 Eupen 4-2 St. Truiden 19/-12 3,85 0.92/13 1.00/8 1.33/6 0.57/7   14/-6 2,62 0.77/13 0.75/8 1.29/7 0.17/6
2016-11-18 St. Truiden 0-1 Club Brugge KV 16/-8 2,86 0.71/14 0.75/8 1.29/7 0.14/7   20/9 2,21 1.71/14 2.13/8 2.43/7 1.00/7
2016-11-26 Lokeren 1-0 St. Truiden 12/-9 2,20 0.80/15 0.75/8 1.43/7 0.25/8   16/-9 2,73 0.67/15 0.38/8 1.13/8 0.14/7
2016-12-03 St. Truiden 1-0 Mouscron 16/-10 2,63 0.63/16 0.38/8 1.13/8 0.13/8   16/-18 3,13 0.69/16 0.63/8 0.50/8 0.88/8
2016-12-10 Kortrijk 0-1 St. Truiden 27/-1 3,24 1.41/17 1.25/8 1.88/8 1.00/9   17/-9 2,53 0.76/17 0.63/8 1.33/9 0.13/8
2016-12-17 St. Truiden 3-1 Gent 18/-8 2,44 0.89/18 0.88/8 1.33/9 0.44/9   28/13 2,39 1.78/18 1.75/8 2.78/9 0.78/9
2016-12-20 Beveren 3-1 St. Truiden 16/-14 2,56 0.83/18 0.75/8 1.44/9 0.22/9   21/-6 2,53 1.00/19 1.25/8 1.50/10 0.44/9
2016-12-27 St. Truiden 2-2 St. Liege 22/-8 2,60 0.95/20 1.25/8 1.50/10 0.40/10   34/13 2,75 1.50/20 1.38/8 2.30/10 0.70/10
2017-01-22 Anderlecht 3-1 St. Truiden 45/24 3,14 1.95/21 2.13/8 2.10/10 1.82/11   24/-8 2,67 0.95/21 1.25/8 1.45/11 0.40/10
2017-01-25 St. Truiden 2-1 KV Mechelen 25/-10 2,73 0.91/22 1.25/8 1.45/11 0.36/11   29/4 2,45 1.59/22 2.00/8 1.83/12 1.30/10
2017-01-28 St. Truiden 3-0 Oostende 27/-9 2,74 1.00/23 1.63/8 1.58/12 0.36/11   41/14 2,96 1.70/23 1.38/8 2.00/12 1.36/11
2017-02-05 Westerlo 1-0 St. Truiden 28/-23 3,29 0.79/24 1.13/8 0.82/11 0.77/13   30/-6 2,75 1.08/24 2.00/8 1.69/13 0.36/11
2017-02-10 St. Truiden 0-3 Genk 30/-7 2,68 1.04/25 1.63/8 1.69/13 0.33/12   30/-1 2,44 1.52/25 1.75/8 2.23/13 0.75/12
2017-02-18 Waregem 4-1 St. Truiden 40/11 2,65 1.81/26 1.50/8 2.08/13 1.54/13   30/-10 2,69 1.00/26 1.25/8 1.57/14 0.33/12
2017-02-25 Charleroi 1-0 St. Truiden 31/6 2,07 1.63/27 1.25/8 2.23/13 1.07/14   31/-13 2,78 0.96/27 0.88/8 1.57/14 0.31/13
2017-03-04 St. Truiden 2-1 Eupen 31/-14 2,71 0.93/28 0.88/8 1.57/14 0.29/14   38/-21 3,46 1.07/28 1.63/8 1.21/14 0.93/14
2017-03-12 Club Brugge KV 2-2 St. Truiden 54/32 2,62 2.00/29 1.88/8 2.71/14 1.33/15   33/-13 2,72 1.00/29 1.13/8 1.67/15 0.29/14
2018-10-21 Waasland-Beveren 1-3 St. Truiden 50/-4 4,00 1.38/26 1.50/8 0.00/14 3.00/12   35/-13 2,77 1.00/30 1.25/8 1.67/15 0.33/15
2018-10-21 St. Truiden 1-3 Waasland-Beveren 38/-11 2,81 1.06/31 0.88/8 1.67/15 0.50/16   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4