SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='Waregem' OR Away='Waregem') 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 Waregem 3-0 Eupen 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 Beveren 0-2 Waregem / /0 / / /   / /0 / / /
2016-08-06 Waasland-Beveren 0-2 Waregem 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-14 Waregem 1-0 St. Liege 5/5 2,50 3.00/2 3.00/2 3.00/1 3.00/1   4/2 3,00 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-20 Waregem 1-1 Oostende 6/6 2,00 3.00/3 3.00/3 3.00/2 3.00/1   4/1 2,33 2.00/3 2.00/3 3.00/2 0.00/1
2016-08-28 Genk 1-0 Waregem 7/3 2,75 1.75/4 1.75/4 2.00/2 1.50/2   7/6 2,00 2.50/4 2.50/4 2.33/3 3.00/1
2016-09-10 Mouscron 1-5 Waregem 5/-3 2,60 0.60/5 0.60/5 1.00/3 0.00/2   7/5 1,80 2.00/5 2.00/5 2.33/3 1.50/2
2016-09-17 Waregem 2-1 Kortrijk 12/9 2,50 2.17/6 2.17/6 2.33/3 2.00/3   10/1 3,17 1.83/6 1.83/6 2.33/3 1.33/3
2016-09-24 KV Mechelen 2-3 Waregem 8/3 1,86 1.71/7 1.71/7 1.33/3 2.00/4   14/10 2,57 2.29/7 2.29/7 2.50/4 2.00/3
2016-10-01 Waregem 1-1 Charleroi 17/11 2,88 2.38/8 2.38/8 2.50/4 2.25/4   10/3 2,13 1.88/8 1.88/8 2.20/5 1.33/3
2016-10-16 Gent 3-0 Waregem 14/5 2,56 1.67/9 1.75/8 3.00/4 0.60/5   18/11 2,78 2.22/9 2.13/8 2.20/5 2.25/4
2016-10-22 Waregem 2-0 Lokeren 18/8 2,80 2.00/10 1.75/8 2.20/5 1.80/5   8/-5 2,10 1.00/10 0.88/8 1.80/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 Waregem 0-0 Club Brugge KV 22/12 2,67 2.17/12 2.00/8 2.33/6 2.00/6   19/9 2,42 1.83/12 2.00/8 2.67/6 1.00/6
2016-11-05 Westerlo 1-2 Waregem 14/-15 3,31 0.69/13 1.00/8 0.83/6 0.57/7   22/12 2,46 2.08/13 2.13/8 2.14/7 2.00/6
2016-11-20 Waregem 3-2 Anderlecht 24/13 2,50 2.14/14 2.13/8 2.14/7 2.14/7   24/9 2,79 1.79/14 1.63/8 2.00/7 1.57/7
2016-11-27 St. Liege 4-1 Waregem 24/8 2,67 1.47/15 1.25/8 2.29/7 0.75/8   27/14 2,67 2.20/15 2.13/8 2.25/8 2.14/7
2016-12-03 Waregem 1-1 Waasland-Beveren 28/11 2,81 2.06/16 1.75/8 2.25/8 1.88/8   15/-12 2,63 0.88/16 1.00/8 1.44/9 0.14/7
2016-12-03 Waregem 1-1 Beveren / /0 / / /   / /0 / / /
2016-12-09 Lokeren 1-1 Waregem 15/-7 2,18 1.06/17 1.00/8 1.63/8 0.56/9   29/11 2,76 2.00/17 1.75/8 2.11/9 1.88/8
2016-12-17 Oostende 1-1 Waregem 35/14 3,11 1.78/18 1.88/8 2.56/9 1.00/9   30/11 2,72 1.94/18 1.88/8 2.11/9 1.78/9
2016-12-21 Waregem 1-0 Genk 31/11 2,68 1.89/19 1.63/8 2.11/9 1.70/10   23/-6 2,89 1.39/18 1.38/8 2.00/10 0.63/8
2016-12-26 Waregem 0-0 KV Mechelen 32/12 2,60 1.95/20 1.63/8 2.20/10 1.70/10   28/5 2,55 1.70/20 2.38/8 2.00/11 1.33/9
2017-01-21 Kortrijk 2-3 Waregem 29/-11 3,29 1.14/21 0.50/8 1.50/10 0.82/11   32/12 2,48 1.90/21 1.63/8 2.09/11 1.70/10
2017-01-24 Waregem 1-0 Mouscron 35/13 2,59 1.95/22 1.63/8 2.09/11 1.82/11   20/-24 2,91 0.68/22 0.50/8 0.73/11 0.64/11
2017-01-27 Charleroi 2-1 Waregem 26/5 2,04 1.61/23 1.25/8 2.09/11 1.17/12   36/14 2,52 2.00/23 1.63/8 2.17/12 1.82/11
2017-02-05 Waregem 1-1 Gent 37/13 2,54 1.92/24 1.63/8 2.17/12 1.67/12   34/11 2,38 1.63/24 1.13/8 2.58/12 0.67/12
2017-02-12 Anderlecht 4-2 Waregem 52/28 3,04 1.96/25 2.25/8 2.08/12 1.85/13   38/13 2,52 1.88/25 1.63/8 2.08/13 1.67/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-24 Club Brugge KV 5-0 Waregem 48/28 2,52 2.04/27 2.25/8 2.69/13 1.43/14   44/14 2,74 1.85/27 1.75/8 2.14/14 1.54/13
2017-03-04 Waregem 2-2 Westerlo 44/9 2,82 1.79/28 1.38/8 2.14/14 1.43/14   31/-28 3,21 0.79/28 1.25/8 0.86/14 0.71/14
2017-03-12 Eupen 1-3 Waregem 39/-22 3,45 1.03/29 1.25/8 1.21/14 0.87/15   46/9 2,86 1.76/29 1.38/8 2.07/15 1.43/14