SELECT * FROM 1_Kampe WHERE LigaID = '286' AND (Home='Charleroi' OR Away='Charleroi') 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 Charleroi 1-0 Beveren 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 Mouscron 0-1 Charleroi 1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-13 Charleroi 1-1 Gent 2/2 1,00 3.00/2 3.00/2 3.00/1 3.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2016-08-19 St. Liege 0-0 Charleroi 4/1 2,33 1.33/3 1.33/3 3.00/1 0.50/2   3/2 1,33 2.33/3 2.33/3 2.00/2 3.00/1
2016-08-26 Charleroi 3-2 Eupen 3/2 1,00 2.00/4 2.00/4 2.00/2 2.00/2   4/-4 3,00 1.00/4 1.00/4 0.50/2 1.50/2
2016-09-11 Anderlecht 3-2 Charleroi 11/5 3,40 1.80/5 1.80/5 2.00/2 1.67/3   6/3 1,80 2.20/5 2.20/5 2.33/3 2.00/2
2016-09-16 Charleroi 0-0 KV Mechelen 8/2 2,33 1.83/6 1.83/6 2.33/3 1.33/3   8/3 2,17 1.83/6 1.83/6 1.33/3 2.33/3
2016-09-24 Charleroi 2-1 Oostende 8/2 2,00 1.71/7 1.71/7 2.00/4 1.33/3   9/2 2,29 1.86/7 1.86/7 3.00/4 0.33/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-14 Charleroi 1-0 Club Brugge KV 11/3 2,11 1.78/9 1.63/8 2.20/5 1.25/4   13/5 2,33 1.78/9 1.63/8 2.50/4 1.20/5
2016-10-22 Westerlo 0-0 Charleroi 13/-10 3,60 0.80/10 0.88/8 0.80/5 0.80/5   12/4 2,00 1.90/10 1.63/8 2.33/6 1.25/4
2016-10-26 Charleroi 2-1 Genk 12/4 1,82 1.82/11 1.63/8 2.33/6 1.20/5   14/-1 2,64 1.55/11 1.63/8 2.17/6 0.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-04 Kortrijk 2-1 Charleroi 23/3 3,31 1.54/13 1.50/8 2.00/6 1.14/7   16/5 2,08 1.85/13 1.63/8 2.43/7 1.17/6
2016-11-20 Charleroi 2-1 Lokeren 17/4 2,14 1.71/14 1.63/8 2.43/7 1.00/7   11/-8 2,14 0.86/14 0.75/8 1.43/7 0.29/7
2016-11-26 Beveren 0-1 Charleroi 15/-11 2,73 0.93/15 1.13/8 1.63/8 0.14/7   19/5 2,20 1.80/15 1.88/8 2.50/8 1.00/7
2016-12-04 Charleroi 0-0 St. Liege 20/6 2,13 1.88/16 1.88/8 2.50/8 1.25/8   28/11 2,81 1.56/16 1.25/8 2.38/8 0.75/8
2016-12-10 Eupen 2-2 Charleroi 26/-13 3,82 0.94/17 1.13/8 1.50/8 0.44/9   20/6 2,00 1.76/17 1.75/8 2.22/9 1.25/8
2016-12-17 Charleroi 2-0 Mouscron 22/6 2,11 1.72/18 1.50/8 2.22/9 1.22/9   17/-22 3,11 0.61/18 0.13/8 0.44/9 0.78/9
2016-12-20 KV Mechelen 1-0 Charleroi 27/4 2,63 1.63/19 2.00/8 1.90/10 1.33/9   24/8 2,11 1.79/19 1.75/8 2.30/10 1.22/9
2016-12-26 Charleroi 0-2 Anderlecht 24/7 2,05 1.70/20 1.38/8 2.30/10 1.10/10   43/22 3,20 1.90/20 1.75/8 2.10/10 1.70/10
2017-01-20 Gent 1-0 Charleroi 31/8 2,57 1.52/21 1.38/8 2.50/10 0.64/11   24/5 2,05 1.62/21 1.25/8 2.09/11 1.10/10
2017-01-24 Oostende 1-2 Charleroi 40/15 2,95 1.77/22 1.75/8 2.18/11 1.36/11   24/4 2,00 1.55/22 1.25/8 2.09/11 1.00/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 Club Brugge KV 1-0 Charleroi 45/27 2,63 2.04/24 2.38/8 2.67/12 1.42/12   28/6 2,08 1.67/24 1.25/8 2.17/12 1.17/12
2017-02-11 Charleroi 2-1 Westerlo 28/5 2,04 1.60/25 1.25/8 2.17/12 1.08/13   29/-22 3,20 0.88/25 1.38/8 1.00/12 0.77/13
2017-02-19 Genk 1-1 Charleroi 33/2 2,46 1.58/26 2.00/8 2.23/13 0.92/13   30/6 2,08 1.65/26 1.50/8 2.23/13 1.08/13
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 Charleroi 1-1 Kortrijk 32/7 2,04 1.68/28 1.63/8 2.29/14 1.07/14   37/-15 3,18 1.07/28 0.75/8 1.29/14 0.86/14
2017-03-12 Lokeren 0-0 Charleroi 24/-10 2,00 1.03/29 0.75/8 1.43/14 0.67/15   33/7 2,03 1.66/29 1.75/8 2.20/15 1.07/14
2018-10-21 Charleroi 1-3 Waasland-Beveren 33/7 1,97 1.63/30 1.88/8 2.20/15 1.07/15   57/-2 4,00 1.45/29 1.50/8 0.00/15 3.00/14
2018-10-21 Waasland-Beveren 1-3 Charleroi 29/-2 4,00 1.40/15 1.50/8 0.00/8 3.00/7   34/5 2,03 1.58/31 1.50/8 2.06/16 1.07/15