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-07-30 Charleroi 1-0 Waasland-Beveren 1/1 1,00 3.00/1 3.00/2 3.00/1 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   2/2 1,00 3.00/2 3.00/2 3.00/2 0.00/0
2016-08-13 Charleroi 1-1 Gent 3/3 1,00 3.00/3 3.00/3 3.00/2 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   4/3 1,25 2.50/4 2.50/4 2.33/3 3.00/1
2016-08-26 Charleroi 3-2 Eupen 4/3 1,00 2.20/5 2.20/5 2.33/3 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   7/4 1,67 2.33/6 2.33/6 2.50/4 2.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 Charleroi 2-1 Oostende 9/3 1,88 1.88/8 1.88/8 2.20/5 1.33/3   11/3 2,38 2.00/8 2.00/8 3.00/5 0.33/3
2016-10-01 Waregem 1-1 Charleroi 19/13 2,78 2.44/9 2.38/8 2.50/4 2.40/5   11/4 2,00 2.00/9 1.88/8 2.33/6 1.33/3
2016-10-14 Charleroi 1-0 Club Brugge KV 12/4 2,00 1.90/10 1.63/8 2.33/6 1.25/4   13/4 2,20 1.60/10 1.63/8 2.50/4 1.00/6
2016-10-22 Westerlo 0-0 Charleroi 14/-9 3,36 1.00/11 1.25/8 1.17/6 0.80/5   13/5 1,91 2.00/11 1.63/8 2.43/7 1.25/4
2016-10-26 Charleroi 2-1 Genk 13/5 1,75 1.92/12 1.63/8 2.43/7 1.20/5   16/-1 2,75 1.50/12 1.63/8 2.00/7 0.80/5
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-04 Kortrijk 2-1 Charleroi 23/3 3,31 1.54/13 1.50/8 2.00/6 1.14/7   17/6 2,00 1.93/14 1.63/8 2.50/8 1.17/6
2016-11-20 Charleroi 2-1 Lokeren 18/5 2,07 1.80/15 1.63/8 2.50/8 1.00/7   12/-8 2,13 0.87/15 0.88/8 1.43/7 0.38/8
2016-11-26 Waasland-Beveren 0-1 Charleroi 15/-11 2,73 0.93/15 1.13/8 1.63/8 0.14/7   20/6 2,13 1.88/16 1.88/8 2.56/9 1.00/7
2016-11-26 Beveren 0-1 Charleroi 15/-11 2,73 0.93/15 1.13/8 1.63/8 0.14/7   21/7 2,06 1.94/17 2.13/8 2.56/9 1.25/8
2016-12-04 Charleroi 0-0 St. Liege 22/8 2,00 2.00/18 2.13/8 2.56/9 1.44/9   33/16 2,94 1.65/17 1.63/8 2.44/9 0.75/8
2016-12-10 Eupen 2-2 Charleroi 28/-15 3,94 0.89/18 1.13/8 1.50/8 0.40/10   22/8 1,89 1.89/19 1.75/8 2.30/10 1.44/9
2016-12-17 Charleroi 2-0 Mouscron 24/8 2,00 1.85/20 1.75/8 2.30/10 1.40/10   17/-22 2,95 0.63/19 0.25/8 0.44/9 0.80/10
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 Charleroi 0-2 Anderlecht 26/9 1,95 1.82/22 1.63/8 2.36/11 1.27/11   44/21 3,19 1.81/21 1.75/8 2.10/10 1.55/11
2017-01-20 Gent 1-0 Charleroi 33/10 2,55 1.59/22 1.38/8 2.55/11 0.64/11   26/7 1,96 1.74/23 1.63/8 2.17/12 1.27/11
2017-01-24 Oostende 1-2 Charleroi 43/17 2,88 1.88/24 1.75/8 2.25/12 1.50/12   26/6 1,92 1.67/24 1.25/8 2.17/12 1.17/12
2017-01-27 Charleroi 2-1 Waregem 28/7 1,96 1.72/25 1.25/8 2.17/12 1.31/13   39/16 2,48 2.00/25 1.75/8 2.08/13 1.92/12
2017-02-05 Club Brugge KV 1-0 Charleroi 47/27 2,58 2.00/26 2.38/8 2.69/13 1.31/13   30/8 2,00 1.77/26 1.25/8 2.23/13 1.31/13
2017-02-11 Charleroi 2-1 Westerlo 30/7 1,96 1.70/27 1.25/8 2.23/13 1.21/14   30/-21 3,00 0.96/27 1.50/8 1.15/13 0.79/14
2017-02-19 Genk 1-1 Charleroi 35/2 2,43 1.54/28 2.13/8 2.14/14 0.93/14   32/8 2,00 1.75/28 1.50/8 2.29/14 1.21/14
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 Charleroi 1-1 Kortrijk 34/9 1,97 1.77/30 1.63/8 2.33/15 1.20/15   39/-16 3,13 1.03/30 0.75/8 1.20/15 0.87/15
2017-03-12 Lokeren 0-0 Charleroi 25/-10 1,94 1.03/31 0.75/8 1.40/15 0.69/16   35/9 1,97 1.74/31 1.75/8 2.25/16 1.20/15