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
2016-08-06 Accrington 3-2 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
2016-08-13 Barnet 2-0 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
2016-08-16 Wycombe 1-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
2016-08-20 Accrington 1-2 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
2016-08-27 Accrington 2-3 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
2016-09-03 Carlisle 1-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
2016-09-10 Notts Co 0-2 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
2016-09-17 Accrington 1-0 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
2016-09-24 Colchester 1-2 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
2016-09-27 Accrington 1-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
2016-10-01 Cambridge Utd 2-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
2016-10-08 Accrington 1-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
2016-10-15 Accrington 2-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
2016-10-22 Crawley 0-0 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
2016-10-29 Accrington 1-3 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
2016-11-12 Luton 1-0 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
2016-11-19 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
2016-11-22 Hartlepool 2-0 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
2016-11-26 Accrington 1-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
2016-12-10 Leyton Orient 1-0 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
2016-12-17 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
2016-12-26 Grimsby 2-0 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
2016-12-31 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
2017-01-02 Accrington 2-2 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
2017-01-14 Cheltenham 3-0 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
2017-01-21 Accrington 1-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
2017-02-04 Accrington 2-0 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
2017-02-11 Portsmouth 2-0 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
2017-02-14 Mansfield 4-4 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
2017-02-18 Accrington 2-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
2017-02-25 Doncaster 2-2 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
2017-02-28 Accrington 2-2 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
2017-03-04 Accrington 1-0 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
2017-03-11 Exeter 0-2 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
2017-03-14 Accrington 5-0 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
2017-03-18 Yeovil 1-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
2017-03-21 Morecambe 1-2 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
2017-03-25 Accrington 1-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
2017-03-28 Accrington 2-0 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
2017-04-01 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
2017-04-08 Accrington 3-2 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
2017-04-14 Blackpool 0-0 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
2017-04-17 Accrington 1-0 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
2017-04-22 Newport 1-0 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
2017-04-29 Accrington 1-4 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
2017-05-06 Stevenage 0-3 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