SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Charlton' OR Away='Charlton') 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
2018-08-04 Sunderland 2-1 Charlton 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
2018-08-11 Charlton 2-1 Shrewsbury 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-08-18 Accrington 1-1 Charlton 2/-1 2,50 1.50/2 1.50/2 0.00/1 3.00/1   3/0 3,00 1.50/2 1.50/2 3.00/1 0.00/1
2018-08-21 Charlton 0-1 Peterborough 4/0 2,67 1.33/3 1.33/3 3.00/1 0.50/2   9/6 4,00 3.00/3 3.00/3 3.00/2 3.00/1
2018-08-25 Charlton 0-0 Fleetwood 4/-1 2,25 1.00/4 1.00/4 1.50/2 0.50/2   9/6 3,00 1.75/4 1.75/4 0.50/2 3.00/2
2018-09-01 Southend 1-2 Charlton 6/0 2,40 1.40/5 1.40/5 1.50/2 1.33/3   4/-1 1,80 1.00/5 1.00/5 1.33/3 0.50/2
2018-09-08 Charlton 3-2 Wycombe 6/0 2,00 1.33/6 1.33/6 1.33/3 1.33/3   5/-3 2,17 1.00/6 1.00/6 0.67/3 1.33/3
2018-09-15 Bradford City 0-2 Charlton 6/-5 2,43 0.86/7 0.86/7 1.00/3 0.75/4   9/1 2,43 1.57/7 1.57/7 1.75/4 1.33/3
2018-09-22 Charlton 2-1 Plymouth 11/3 2,38 1.75/8 1.75/8 1.75/4 1.75/4   4/-10 2,25 0.38/8 0.38/8 0.50/4 0.25/4
2018-09-29 Luton 2-2 Charlton 10/0 2,22 1.33/9 1.50/8 2.50/4 0.40/5   13/4 2,44 1.89/9 2.13/8 2.00/5 1.75/4
2018-10-02 Scunthorpe 5-3 Charlton 13/-5 3,10 1.40/10 1.25/8 1.20/5 1.60/5   15/4 2,60 1.80/10 1.88/8 2.00/5 1.60/5
2018-10-06 Charlton 1-2 Coventry 18/2 3,09 1.64/11 1.75/8 2.00/5 1.33/6   8/-4 1,82 1.09/11 1.00/8 1.17/6 1.00/5
2018-10-20 Charlton 2-0 Barnsley 19/1 3,08 1.50/12 1.75/8 1.67/6 1.33/6   26/17 2,92 2.08/12 1.88/8 2.00/6 2.17/6
2018-10-23 Charlton 1-1 Oxford Utd 21/3 3,00 1.62/13 2.00/8 1.86/7 1.33/6   13/-10 2,57 0.71/14 0.75/8 0.86/7 0.57/7
2018-10-27 Rochdale 1-0 Charlton 21/-10 3,47 1.07/15 1.00/8 0.57/7 1.50/8   22/3 2,93 1.57/14 1.75/8 1.75/8 1.33/6
2018-11-03 Charlton 2-0 Doncaster 22/2 2,80 1.47/15 1.38/8 1.75/8 1.14/7   25/3 2,94 1.56/16 1.25/8 1.50/8 1.63/8
2018-11-06 Walsall 0-2 Charlton 19/-3 2,56 1.56/16 1.25/8 1.38/8 1.75/8   24/4 2,75 1.56/16 1.38/8 1.89/9 1.14/7
2018-11-24 Charlton 3-1 Bristol Rovers 26/6 2,71 1.65/17 1.38/8 1.89/9 1.38/8   15/-1 1,72 0.94/18 1.00/8 0.89/9 1.00/9
2018-11-27 Burton 1-2 Charlton 23/-2 2,67 1.33/18 1.63/8 1.78/9 0.89/9   29/8 2,78 1.72/18 1.63/8 2.00/10 1.38/8
2018-12-08 Blackpool 2-1 Charlton 23/5 2,16 1.63/19 1.88/8 1.80/10 1.44/9   31/9 2,79 1.79/19 2.00/8 2.00/10 1.56/9
2018-12-11 Portsmouth 1-2 Charlton 34/19 2,45 2.35/20 2.50/8 2.10/10 2.60/10   32/8 2,80 1.70/20 2.00/8 2.00/10 1.40/10
2018-12-15 Charlton 2-0 AFC Wimbledon 34/9 2,81 1.76/21 2.00/8 2.00/10 1.55/11   15/-16 2,19 0.71/21 0.50/8 0.73/11 0.70/10
2018-12-22 Charlton 2-0 Gillingham 36/11 2,77 1.82/22 2.25/8 2.09/11 1.55/11   33/-3 3,14 1.14/22 1.63/8 1.00/11 1.27/11
2018-12-26 Coventry 2-1 Charlton 23/-5 2,22 1.26/23 0.63/8 1.36/11 1.17/12   38/13 2,74 1.87/23 2.63/8 2.17/12 1.55/11
2018-12-29 Barnsley 2-1 Charlton 38/17 2,57 1.83/23 1.75/8 2.09/11 1.58/12   39/12 2,75 1.79/24 2.25/8 2.17/12 1.42/12
2019-01-01 Charlton 2-1 Walsall 40/11 2,76 1.72/25 1.88/8 2.17/12 1.31/13   27/-12 2,64 1.28/25 0.88/8 1.23/13 1.33/12
2019-01-05 Charlton 1-1 Sunderland 42/12 2,77 1.77/26 1.88/8 2.23/13 1.31/13   45/22 2,83 2.08/24 1.88/8 2.17/12 2.00/12
2019-01-12 Shrewsbury 0-3 Charlton 29/-3 2,35 1.15/26 1.13/8 1.77/13 0.54/13   43/12 2,74 1.74/27 1.63/8 2.14/14 1.31/13
2019-01-19 Charlton 1-0 Accrington 46/15 2,75 1.79/28 2.00/8 2.14/14 1.43/14   27/-8 2,38 1.35/26 0.88/8 1.31/13 1.38/13
2019-01-26 Peterborough 0-0 Charlton 47/9 3,04 1.68/28 1.13/8 1.43/14 1.93/14   47/16 2,69 1.83/29 2.00/8 2.20/15 1.43/14
2019-02-02 Fleetwood 1-0 Charlton 41/7 2,50 1.30/30 1.13/8 1.53/15 1.07/15   47/16 2,60 1.80/30 1.75/8 2.20/15 1.40/15
2019-02-09 Charlton 1-1 Southend 47/15 2,55 1.74/31 1.38/8 2.20/15 1.31/16   39/2 2,53 1.27/30 1.13/8 1.19/16 1.36/14
2019-02-16 Charlton 0-0 Blackpool 48/15 2,53 1.72/32 1.50/8 2.13/16 1.31/16   34/6 2,00 1.52/31 1.63/8 1.63/16 1.40/15
2019-02-23 AFC Wimbledon 1-2 Charlton 27/-24 2,36 0.88/33 0.88/8 0.75/16 1.00/17   48/15 2,45 1.70/33 1.63/8 2.06/17 1.31/16
2019-03-02 Doncaster 1-1 Charlton 59/17 3,06 1.64/33 1.50/8 2.00/16 1.29/17   50/16 2,47 1.74/34 1.63/8 2.06/17 1.41/17
2019-03-09 Charlton 2-1 Portsmouth 51/16 2,46 1.71/35 1.63/8 2.06/17 1.39/18   60/23 2,77 1.86/35 1.00/8 1.83/18 1.88/17
2019-03-12 Charlton 2-1 Burton 53/17 2,47 1.75/36 1.63/8 2.11/18 1.39/18   44/2 2,39 1.31/36 1.38/8 1.44/18 1.17/18
2019-03-16 Bristol Rovers 0-0 Charlton 37/0 2,06 1.19/36 1.88/8 0.94/18 1.44/18   55/18 2,49 1.78/37 1.63/8 2.16/19 1.39/18
2019-03-30 Charlton 1-0 Bradford City 55/18 2,42 1.76/38 1.63/8 2.16/19 1.37/19   43/-24 2,82 0.92/39 0.50/8 1.15/20 0.68/19
2019-04-06 Plymouth 0-2 Charlton 51/-12 2,85 1.18/40 1.25/8 1.50/20 0.85/20   56/19 2,38 1.79/39 2.00/8 2.20/20 1.37/19
2019-04-09 Wycombe 0-1 Charlton 50/-13 2,83 1.10/40 0.13/8 1.45/20 0.75/20   58/21 2,38 1.83/40 2.25/8 2.20/20 1.45/20
2019-04-13 Charlton 3-1 Luton 59/22 2,34 1.85/41 2.50/8 2.20/20 1.52/21   80/46 2,78 2.12/41 2.00/8 2.43/21 1.80/20
2019-04-19 Oxford Utd 2-1 Charlton 50/-6 2,52 1.26/42 2.13/8 1.57/21 0.95/21   62/24 2,38 1.88/42 2.50/8 2.24/21 1.52/21
2019-04-22 Charlton 4-0 Scunthorpe 63/23 2,40 1.84/43 2.38/8 2.24/21 1.45/22   49/-24 2,84 1.07/43 0.63/8 1.14/22 1.00/21
2019-04-27 Gillingham 0-2 Charlton 58/-12 2,91 1.18/44 1.13/8 1.14/22 1.23/22   67/27 2,43 1.86/44 2.38/8 2.27/22 1.45/22
2019-05-04 Charlton 4-0 Rochdale 69/29 2,42 1.89/45 2.38/8 2.27/22 1.52/23   54/-29 3,04 1.20/45 2.00/8 1.22/23 1.18/22