SELECT * FROM 1_Kampe WHERE LigaID = '14' AND (Home='Accrington' OR Away='Accrington') 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
2019-08-03 Lincoln 2-0 Accrington 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
2019-08-17 AFC Wimbledon 1-1 Accrington 2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1   0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1
2019-08-20 Accrington 2-3 Shrewsbury 1/-2 2,00 0.50/2 0.50/2 0.00/0 0.50/2   1/0 0,67 1.33/3 1.33/3 2.00/2 0.00/1
2019-08-24 Fleetwood 2-0 Accrington 8/2 3,50 1.75/4 1.75/4 2.00/2 1.50/2   3/-3 3,00 0.33/3 0.33/3 0.00/1 0.50/2
2019-08-31 Accrington 2-1 MK Dons 3/-5 2,75 0.25/4 0.25/4 0.00/1 0.33/3   5/-3 3,25 1.50/4 1.50/4 2.00/3 0.00/1
2019-09-07 Bristol Rovers 3-3 Accrington 5/-2 2,00 1.17/6 1.17/6 2.33/3 0.00/3   5/-4 2,80 0.80/5 0.80/5 1.50/2 0.33/3
2019-09-14 Accrington 1-3 Sunderland 8/-4 3,33 0.83/6 0.83/6 1.50/2 0.50/4   9/1 2,83 1.83/6 1.83/6 2.33/3 1.33/3
2019-09-17 Wycombe 1-1 Accrington 13/4 2,75 1.88/8 1.88/8 3.00/4 0.75/4   9/-6 3,43 0.71/7 0.71/7 1.00/3 0.50/4
2019-09-21 Accrington 1-1 Blackpool 10/-6 3,25 0.75/8 0.75/8 1.00/3 0.60/5   13/2 2,67 1.67/9 1.50/8 1.75/4 1.60/5
2019-09-28 Southend 0-1 Accrington 11/-13 3,89 0.44/9 0.50/8 0.25/4 0.60/5   11/-6 3,11 0.78/9 0.88/8 1.00/4 0.60/5
2019-10-05 Accrington 2-2 Oxford Utd 12/-5 2,90 1.00/10 1.13/8 1.00/4 1.00/6   22/7 3,36 1.36/11 1.38/8 2.00/5 0.83/6
2019-10-12 Rochdale 2-1 Accrington 12/-8 2,91 0.91/11 0.63/8 0.60/5 1.17/6   14/-5 3,00 1.00/11 1.25/8 1.00/5 1.00/6
2019-10-20 Accrington 2-0 Ipswich 15/-6 3,00 0.92/12 1.25/8 1.00/5 0.86/7   21/16 2,36 2.45/11 2.75/8 2.20/5 2.67/6
2019-10-23 Peterborough 4-0 Accrington 30/14 3,54 1.85/13 2.13/8 2.17/6 1.57/7   17/-4 2,92 1.08/13 1.25/8 1.33/6 0.86/7
2019-10-26 Accrington 0-1 Gillingham 17/-8 3,00 1.00/14 1.13/8 1.33/6 0.75/8   19/2 2,57 1.07/14 1.13/8 1.43/7 0.71/7
2019-11-02 Coventry 0-0 Accrington 20/2 2,53 1.67/15 1.25/8 2.38/8 0.86/7   17/-9 2,87 0.93/15 1.13/8 1.14/7 0.75/8
2019-11-16 Rotherham 1-0 Accrington 24/11 2,47 1.60/15 1.63/8 1.14/7 2.00/8   17/-9 2,69 0.94/16 1.13/8 1.14/7 0.78/9
2019-11-23 Accrington 7-1 Bolton 17/-10 2,59 0.88/17 1.00/8 1.14/7 0.70/10   8/-21 2,64 0.93/14 1.50/8 1.25/8 0.50/6
2019-12-07 Tranmere 1-1 Accrington 21/-11 3,12 0.94/17 0.88/8 1.13/8 0.78/9   24/-4 2,89 1.00/18 1.00/8 1.38/8 0.70/10
2019-12-14 Accrington 4-1 Portsmouth 25/-4 2,84 1.00/19 1.00/8 1.38/8 0.73/11   28/8 2,67 1.56/18 1.88/8 2.00/10 1.00/8
2019-12-21 Doncaster 1-1 Accrington 26/6 2,71 1.41/17 1.00/8 1.80/10 0.86/7   29/-1 2,95 1.10/20 1.38/8 1.56/9 0.73/11
2019-12-26 Blackpool 0-1 Accrington 30/6 2,57 1.57/21 1.63/8 1.82/11 1.30/10   30/-1 2,90 1.10/21 1.13/8 1.56/9 0.75/12
2019-12-29 Accrington 2-0 Burton 31/0 2,82 1.18/22 1.50/8 1.56/9 0.92/13   28/3 2,52 1.43/21 1.38/8 1.50/10 1.36/11
2020-01-01 Accrington 1-2 Rochdale 33/2 2,78 1.26/23 1.88/8 1.70/10 0.92/13   25/-15 2,83 0.96/23 0.38/8 0.82/11 1.08/12
2020-01-11 Ipswich 4-1 Accrington 33/11 2,39 1.65/23 0.63/8 1.40/10 1.85/13   34/1 2,79 1.21/24 1.75/8 1.55/11 0.92/13
2020-01-18 Accrington 1-2 Southend 35/-2 2,88 1.16/25 1.75/8 1.55/11 0.86/14   27/-38 3,68 0.40/25 0.63/8 0.33/12 0.46/13
2020-01-25 Burton 1-1 Accrington 34/4 2,56 1.56/25 1.88/8 1.75/12 1.38/13   36/-3 2,88 1.12/26 1.38/8 1.42/12 0.86/14
2020-01-28 Accrington 0-2 Peterborough 37/-3 2,85 1.11/27 1.38/8 1.42/12 0.87/15   50/14 3,07 1.54/28 1.00/8 2.14/14 0.93/14
2020-02-01 Accrington 2-1 AFC Wimbledon 37/-5 2,82 1.07/28 1.00/8 1.31/13 0.87/15   33/-7 2,70 1.04/27 1.38/8 1.50/14 0.54/13
2020-02-11 Shrewsbury 0-2 Accrington 25/-7 2,04 1.25/28 0.50/8 1.54/13 1.00/15   39/-4 2,83 1.14/29 1.25/8 1.43/14 0.87/15
2020-02-15 Accrington 4-3 Lincoln 41/-2 2,80 1.20/30 1.25/8 1.43/14 1.00/16   38/-2 2,44 1.19/32 1.00/8 1.93/15 0.53/17
2020-02-22 Accrington 1-2 Rotherham 45/-1 2,94 1.26/31 1.25/8 1.53/15 1.00/16   56/24 2,84 1.84/31 2.38/8 1.75/16 1.93/15
2020-02-25 Oxford Utd 3-0 Accrington 53/19 2,72 1.59/32 1.50/8 2.00/15 1.24/17   46/-2 2,94 1.22/32 1.25/8 1.44/16 1.00/16
2020-02-29 Bolton 0-0 Accrington 25/-39 2,87 0.74/31 0.50/8 1.19/16 0.27/15   46/-5 2,94 1.18/33 1.25/8 1.44/16 0.94/17
2020-03-07 Accrington 1-2 Tranmere 46/-5 2,85 1.18/34 1.38/8 1.44/16 0.94/18   32/-26 2,81 0.81/32 0.50/8 0.88/17 0.73/15
2020-03-14 Portsmouth 0-0 Accrington 53/17 2,54 1.71/35 1.63/8 2.33/18 1.06/17   47/-6 2,86 1.14/35 1.25/8 1.35/17 0.94/18
2020-03-21 Accrington 0-0 Doncaster 47/-6 2,78 1.11/36 1.25/8 1.35/17 0.89/19   51/18 2,33 1.50/36 1.25/8 1.75/20 1.19/16
2020-03-28 Accrington 0-0 Coventry 47/-6 2,70 1.08/37 0.88/8 1.28/18 0.89/19   48/18 2,11 1.81/37 1.63/8 2.00/19 1.61/18
2020-04-04 Gillingham 0-0 Accrington 42/8 2,00 1.34/38 1.00/8 1.67/18 1.05/20   47/-6 2,63 1.05/38 0.50/8 1.21/19 0.89/19
2020-04-10 Accrington 0-0 Fleetwood 47/-6 2,56 1.03/39 0.13/8 1.21/19 0.85/20   51/13 2,28 1.54/39 0.75/8 1.85/20 1.21/19
2020-04-13 MK Dons 0-0 Accrington 36/-11 2,08 0.93/40 0.13/8 1.40/20 0.45/20   47/-6 2,50 1.00/40 0.13/8 1.15/20 0.85/20
2020-04-18 Accrington 0-0 Bristol Rovers 47/-6 2,44 0.98/41 0.13/8 1.15/20 0.81/21   38/-11 2,18 1.13/40 0.38/8 1.29/21 0.95/19
2020-04-25 Sunderland 0-0 Accrington 48/16 1,90 1.40/42 0.13/8 1.81/21 1.00/21   47/-6 2,38 0.95/42 0.00/8 1.10/21 0.81/21
2020-05-03 Accrington 0-0 Wycombe 47/-6 2,33 0.93/43 0.00/8 1.10/21 0.77/22   45/5 1,98 1.37/43 0.00/8 1.91/22 0.81/21