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 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-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-17 St. Truiden 4-1 Waasland-Beveren 7/-2 2,29 1.00/7 1.25/8 1.75/4 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   11/1 2,63 1.25/8 1.25/8 2.00/5 0.00/3
2016-09-30 Oostende 2-2 St. Truiden 12/2 2,44 1.78/9 2.00/8 3.00/5 0.25/4   12/0 2,67 1.11/9 0.88/8 2.00/5 0.00/4
2016-10-15 St. Truiden 2-2 Westerlo 14/0 2,80 1.10/10 1.00/8 2.00/5 0.20/5   12/-9 3,30 1.00/10 1.13/8 1.17/6 0.75/4
2016-10-23 Genk 1-0 St. Truiden 15/-2 2,91 1.36/11 1.38/8 1.83/6 0.80/5   16/0 2,91 1.09/11 1.00/8 1.83/6 0.20/5
2016-10-26 St. Truiden 0-2 Waregem 16/-1 2,75 1.00/12 1.00/8 1.83/6 0.17/6   22/12 2,67 2.17/12 1.75/8 2.33/6 2.00/6
2016-10-29 St. Truiden 2-2 Charleroi 16/-3 2,69 0.92/13 1.00/8 1.57/7 0.17/6   15/6 1,85 2.00/13 1.88/8 2.50/8 1.20/5
2016-11-05 Eupen 4-2 St. Truiden 21/-14 4,00 0.86/14 0.63/8 1.33/6 0.50/8   18/-3 2,79 0.93/14 1.13/8 1.50/8 0.17/6
2016-11-18 St. Truiden 0-1 Club Brugge KV 20/-5 3,00 0.87/15 0.75/8 1.50/8 0.14/7   20/8 2,13 1.60/15 2.13/8 2.43/7 0.88/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-03 St. Truiden 1-0 Mouscron 20/-7 2,76 0.76/17 0.38/8 1.33/9 0.13/8   16/-18 2,94 0.71/17 0.38/8 0.50/8 0.89/9
2016-12-10 Kortrijk 0-1 St. Truiden 28/-1 3,17 1.39/18 1.25/8 1.88/8 1.00/10   21/-6 2,67 0.89/18 0.63/8 1.50/10 0.13/8
2016-12-17 St. Truiden 3-1 Gent 22/-5 2,58 1.00/19 0.88/8 1.50/10 0.44/9   30/15 2,37 1.84/19 2.13/8 2.80/10 0.78/9
2016-12-20 Waasland-Beveren 3-1 St. Truiden 16/-14 2,56 0.83/18 0.75/8 1.44/9 0.22/9   25/-3 2,65 1.10/20 1.25/8 1.64/11 0.44/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   26/-5 2,71 1.05/21 1.13/8 1.64/11 0.40/10
2016-12-27 St. Truiden 2-2 St. Liege 27/-7 2,77 1.00/22 1.13/8 1.64/11 0.36/11   39/18 2,86 1.57/21 1.38/8 2.36/11 0.70/10
2017-01-22 Anderlecht 3-1 St. Truiden 46/23 3,14 1.86/22 2.13/8 2.10/10 1.67/12   29/-7 2,83 1.00/23 1.25/8 1.58/12 0.36/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 St. Truiden 3-0 Oostende 32/-8 2,88 1.04/25 1.63/8 1.69/13 0.33/12   44/16 2,88 1.80/25 1.38/8 2.08/13 1.50/12
2017-02-05 Westerlo 1-0 St. Truiden 29/-22 3,08 0.88/26 1.13/8 1.00/12 0.79/14   35/-5 2,88 1.12/26 1.63/8 1.79/14 0.33/12
2017-02-10 St. Truiden 0-3 Genk 35/-6 2,81 1.07/27 1.25/8 1.79/14 0.31/13   32/-1 2,41 1.48/27 1.75/8 2.14/14 0.77/13
2017-02-18 Waregem 4-1 St. Truiden 43/13 2,61 1.82/28 1.50/8 2.00/14 1.64/14   35/-9 2,82 1.04/28 0.88/8 1.67/15 0.31/13
2017-02-25 Charleroi 1-0 St. Truiden 33/8 2,00 1.72/29 1.25/8 2.29/14 1.20/15   36/-12 2,90 1.00/29 0.88/8 1.67/15 0.29/14
2017-03-04 St. Truiden 2-1 Eupen 36/-13 2,83 0.97/30 0.88/8 1.67/15 0.27/15   40/-25 3,50 1.00/30 1.25/8 1.13/15 0.87/15
2017-03-12 Club Brugge KV 2-2 St. Truiden 56/32 2,58 1.97/31 1.88/8 2.73/15 1.25/16   38/-12 2,84 1.03/31 1.13/8 1.75/16 0.27/15