SELECT * FROM 1_Kampe WHERE LigaID = '36' 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
2018-10-21 Accrington 0-1 Doncaster 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-10-21 Crawley 0-1 Accrington 15/-1 2,38 1.46/13 1.38/8 1.83/6 1.14/7   18/1 2,69 1.46/13 1.88/8 1.57/7 1.33/6
2018-10-21 Accrington 0-1 Newport 18/1 2,50 1.43/14 1.88/8 1.57/7 1.29/7   13/-8 2,62 0.62/13 0.38/8 0.50/6 0.71/7
2018-10-21 Luton 0-1 Accrington 24/9 2,60 1.60/15 1.38/8 1.71/7 1.50/8   19/-1 2,60 1.33/15 1.50/8 1.38/8 1.29/7
2018-10-21 Accrington 0-1 Stevenage 19/-2 2,50 1.25/16 1.13/8 1.38/8 1.13/8   22/-2 3,07 1.20/15 1.00/8 1.25/8 1.14/7
2018-10-21 Hartlepool 0-1 Accrington 26/-4 3,29 1.12/17 1.00/8 1.00/8 1.22/9   19/-3 2,41 1.18/17 0.75/8 1.22/9 1.13/8
2018-10-21 Accrington 0-1 Yeovil 19/-5 2,39 1.11/18 0.63/8 1.22/9 1.00/9   18/-4 2,35 1.41/17 1.75/8 1.78/9 1.00/8
2018-10-21 Leyton Orient 0-1 Accrington 21/-5 2,47 0.95/19 0.75/8 0.30/10 1.67/9   20/-5 2,37 1.11/19 0.75/8 1.20/10 1.00/9
2018-10-21 Accrington 0-1 Plymouth 20/-6 2,30 1.05/20 0.63/8 1.20/10 0.90/10   31/10 2,60 2.05/20 1.63/8 1.82/11 2.33/9
2018-10-21 Grimsby 0-1 Accrington 27/0 2,57 1.24/21 0.75/8 1.10/10 1.36/11   20/-7 2,24 1.00/21 0.25/8 1.09/11 0.90/10
2018-10-21 Accrington 0-1 Blackpool 16/0 2,67 1.33/12 1.50/8 1.33/6 1.33/6   16/3 2,42 1.17/12 1.13/8 1.50/6 0.83/6
2018-10-21 Accrington 0-1 Cheltenham 15/0 2,73 1.36/11 1.38/8 1.40/5 1.33/6   12/-3 2,45 0.82/11 0.75/8 1.00/6 0.60/5
2018-10-21 Cambridge Utd 0-1 Accrington 8/-6 2,20 0.90/10 1.00/8 1.00/5 0.80/5   14/1 2,70 1.50/10 1.50/8 1.40/5 1.60/5
2018-10-21 Barnet 0-1 Accrington 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Wycombe 0-1 Accrington 2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1   3/-1 3,50 1.50/2 1.50/2 3.00/1 0.00/1
2018-10-21 Accrington 0-1 Exeter 4/-1 3,00 1.33/3 1.33/3 3.00/1 0.50/2   1/-4 2,00 0.00/3 0.00/3 0.00/2 0.00/1
2018-10-21 Accrington 0-1 Morecambe 5/-2 3,00 1.00/4 1.00/4 1.50/2 0.50/2   5/2 2,00 2.25/4 2.25/4 3.00/2 1.50/2
2018-10-21 Carlisle 0-1 Accrington 6/2 2,00 1.80/5 1.80/5 2.00/2 1.67/3   7/-3 3,40 0.80/5 0.80/5 1.00/3 0.50/2
2018-10-21 Notts Co 0-1 Accrington 9/0 3,00 1.33/6 1.33/6 0.67/3 2.00/3   8/-3 3,17 0.83/6 0.83/6 1.00/3 0.67/3
2018-10-21 Accrington 0-1 Portsmouth 10/-1 3,00 1.14/7 1.14/7 1.00/3 1.25/4   11/6 2,29 2.00/7 2.00/7 2.50/4 1.33/3
2018-10-21 Colchester 0-1 Accrington 14/3 3,13 1.75/8 1.75/8 2.25/4 1.25/4   11/0 2,75 1.38/8 1.38/8 1.50/4 1.25/4
2018-10-21 Accrington 0-1 Mansfield 13/1 2,78 1.56/9 1.38/8 1.50/4 1.60/5   7/-1 1,67 1.33/9 1.13/8 1.00/5 1.75/4
2018-10-21 Crewe 0-1 Accrington 24/-6 2,45 1.23/22 1.00/8 1.27/11 1.18/11   20/-9 2,23 0.95/22 0.13/8 1.09/11 0.82/11
2018-10-21 Accrington 0-1 Hartlepool 21/-8 2,17 1.04/23 0.50/8 1.09/11 1.00/12   31/-9 3,09 1.13/23 1.25/8 1.17/12 1.09/11
2018-10-21 Morecambe 0-1 Accrington 44/-12 2,70 1.24/37 1.00/8 1.06/18 1.42/19   45/-2 2,56 1.25/36 2.00/8 1.50/18 1.00/18
2018-10-21 Accrington 0-1 Grimsby 47/-1 2,57 1.30/37 2.25/8 1.50/18 1.11/19   45/-2 2,42 1.34/38 1.38/8 1.37/19 1.32/19
2018-10-21 Accrington 0-1 Cambridge Utd 48/-1 2,55 1.29/38 2.00/8 1.47/19 1.11/19   48/6 2,37 1.42/38 1.75/8 1.15/20 1.72/18
2018-10-21 Plymouth 0-1 Accrington 59/19 2,54 1.92/39 1.75/8 1.80/20 2.05/19   50/1 2,54 1.33/39 2.25/8 1.55/20 1.11/19
2018-10-21 Accrington 0-1 Crewe 51/2 2,50 1.38/40 2.50/8 1.55/20 1.20/20   46/-10 2,55 1.20/40 1.50/8 1.20/20 1.20/20
2018-10-21 Blackpool 0-1 Accrington 62/18 2,59 1.46/41 2.00/8 1.60/20 1.33/21   54/3 2,56 1.41/41 2.50/8 1.62/21 1.20/20
2018-10-21 Accrington 0-1 Crawley 54/3 2,50 1.40/42 2.25/8 1.62/21 1.19/21   48/-15 2,64 1.17/42 0.75/8 1.38/21 0.95/21
2018-10-21 Newport 0-1 Accrington 47/-23 2,72 0.98/43 1.63/8 0.95/21 1.00/22   55/4 2,47 1.44/43 2.25/8 1.68/22 1.19/21
2018-10-21 Accrington 0-1 Luton 55/3 2,43 1.41/44 2.13/8 1.68/22 1.14/22   63/22 2,36 1.61/44 1.63/8 1.68/22 1.55/22
2018-10-21 Yeovil 0-1 Accrington 38/-9 2,30 1.19/37 1.00/8 1.42/19 0.94/18   44/-2 2,57 1.26/35 1.88/8 1.50/18 1.00/17
2018-10-21 Accrington 0-1 Leyton Orient 39/-7 2,50 1.21/34 1.88/8 1.41/17 1.00/17   40/-18 2,72 0.89/36 0.88/8 0.53/19 1.29/17
2018-10-21 Exeter 0-1 Accrington 56/15 2,77 1.54/35 1.50/8 1.19/16 1.84/19   37/-9 2,52 1.15/33 1.63/8 1.41/17 0.88/16
2018-10-21 Cheltenham 0-1 Accrington 24/-13 2,54 0.88/24 0.50/8 0.85/13 0.91/11   23/-8 2,25 1.04/24 0.63/8 1.08/12 1.00/12
2018-10-21 Accrington 0-1 Carlisle 23/-11 2,28 1.00/25 0.63/8 1.08/12 0.92/13   47/11 3,19 1.81/26 1.50/8 2.15/13 1.46/13
2018-10-21 Accrington 0-1 Notts Co 24/-11 2,27 1.00/26 0.75/8 1.08/13 0.92/13   30/-21 2,89 0.93/28 0.50/8 0.73/15 1.15/13
2018-10-21 Portsmouth 0-1 Accrington 40/12 2,43 1.61/28 1.38/8 1.77/13 1.47/15   26/-9 2,26 1.07/27 1.00/8 1.21/14 0.92/13
2018-10-21 Mansfield 0-1 Accrington 37/7 2,23 1.53/30 2.50/8 1.63/16 1.43/14   26/-11 2,25 1.04/28 1.00/8 1.21/14 0.86/14
2018-10-21 Accrington 0-1 Colchester 30/-11 2,45 1.03/29 1.13/8 1.21/14 0.87/15   46/7 2,83 1.47/30 1.75/8 1.86/14 1.13/16
2018-10-21 Doncaster 0-1 Accrington 61/23 3,09 2.00/32 1.88/8 2.38/16 1.63/16   32/-10 2,47 1.10/30 1.50/8 1.33/15 0.87/15
2018-10-21 Accrington 0-1 Wycombe 34/-10 2,52 1.10/31 1.25/8 1.33/15 0.88/16   40/-2 2,48 1.39/33 0.50/8 1.88/16 0.94/17
2018-10-21 Accrington 0-1 Barnet 36/-10 2,56 1.09/32 1.25/8 1.31/16 0.88/16   43/-3 2,62 1.35/34 0.88/8 1.12/17 1.59/17
2018-10-21 Stevenage 0-1 Accrington 67/7 2,82 1.49/45 1.13/8 1.55/22 1.43/23   56/0 2,49 1.38/45 1.75/8 1.61/23 1.14/22