SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Rochdale' OR Away='Rochdale') 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 Burton 1-2 Rochdale 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 Rochdale 1-4 Peterborough 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-18 Fleetwood 2-2 Rochdale 2/1 1,50 1.50/2 1.50/2 0.00/1 3.00/1   3/-2 4,00 1.50/2 1.50/2 0.00/1 3.00/1
2018-08-21 Rochdale 0-4 Barnsley 5/-2 4,00 1.33/3 1.33/3 0.00/1 2.00/2   6/6 2,00 2.33/3 2.33/3 2.00/2 3.00/1
2018-08-25 Rochdale 1-2 Walsall 5/-6 4,00 1.00/4 1.00/4 0.00/2 2.00/2   8/4 3,00 2.50/4 2.50/4 3.00/2 2.00/2
2018-09-01 Coventry 0-1 Rochdale 3/-2 1,60 1.00/5 1.00/5 1.50/2 0.67/3   6/-7 3,80 0.80/5 0.80/5 0.00/3 2.00/2
2018-09-08 Scunthorpe 3-3 Rochdale 6/-7 3,17 1.00/6 1.00/6 0.67/3 1.33/3   7/-6 3,33 1.17/6 1.17/6 0.00/3 2.33/3
2018-09-15 Rochdale 3-0 Gillingham 10/-6 3,71 1.14/7 1.14/7 0.00/3 2.00/4   9/-2 2,86 1.00/7 1.00/7 1.00/4 1.00/3
2018-09-22 Sunderland 4-1 Rochdale 15/7 2,88 1.88/8 1.88/8 2.00/4 1.75/4   13/-3 3,63 1.38/8 1.38/8 0.75/4 2.00/4
2018-09-29 Rochdale 1-3 Portsmouth 14/-6 3,78 1.22/9 1.00/8 0.75/4 1.60/5   17/10 2,67 2.33/9 2.25/8 2.20/5 2.50/4
2018-10-02 Rochdale 0-0 Bristol Rovers 15/-8 3,80 1.10/10 1.00/8 0.60/5 1.60/5   9/-2 2,00 0.90/10 1.13/8 0.80/5 1.00/5
2018-10-06 Blackpool 2-2 Rochdale 10/3 1,70 1.50/10 1.75/8 1.60/5 1.40/5   15/-8 3,45 1.09/11 1.00/8 0.67/6 1.60/5
2018-10-13 Rochdale 2-3 Doncaster 17/-8 3,50 1.08/12 1.13/8 0.67/6 1.50/6   18/4 2,67 1.75/12 1.75/8 1.83/6 1.67/6
2018-10-20 Bradford City 0-2 Rochdale 10/-10 2,31 0.77/13 0.50/8 0.67/6 0.86/7   19/-9 3,62 1.00/13 1.13/8 0.57/7 1.50/6
2018-10-23 Wycombe 3-0 Rochdale 17/-4 2,71 1.07/14 1.13/8 1.29/7 0.86/7   21/-7 3,50 1.14/14 1.13/8 0.57/7 1.71/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 Rochdale 0-0 Luton 22/-9 3,31 1.19/16 1.00/8 0.88/8 1.50/8   27/8 2,88 1.75/16 2.13/8 2.50/8 1.00/8
2018-11-17 Shrewsbury 3-2 Rochdale 16/-4 2,12 1.06/17 1.38/8 1.50/8 0.67/9   22/-9 3,12 1.18/17 1.13/8 0.89/9 1.50/8
2018-11-24 Rochdale 1-0 Accrington 24/-10 3,22 1.11/18 1.13/8 0.89/9 1.33/9   21/0 2,33 1.56/18 1.38/8 1.44/9 1.67/9
2018-11-27 Oxford Utd 4-2 Rochdale 21/-8 2,63 0.95/19 1.63/8 1.33/9 0.60/10   25/-9 3,11 1.21/19 1.38/8 1.10/10 1.33/9
2018-12-08 AFC Wimbledon 1-1 Rochdale 14/-16 2,20 0.70/20 0.38/8 0.70/10 0.70/10   27/-11 3,25 1.15/20 1.25/8 1.10/10 1.20/10
2018-12-15 Rochdale 1-2 Plymouth 28/-11 3,19 1.14/21 1.38/8 1.10/10 1.18/11   24/-16 3,05 0.81/21 1.25/8 1.09/11 0.50/10
2018-12-22 Southend 1-2 Rochdale 28/0 2,55 1.32/22 1.13/8 1.45/11 1.18/11   29/-12 3,18 1.09/22 1.00/8 1.00/11 1.18/11
2018-12-26 Rochdale 2-1 Blackpool 31/-11 3,17 1.17/23 1.38/8 1.00/11 1.33/12   25/3 2,14 1.55/22 1.50/8 1.75/12 1.30/10
2018-12-29 Rochdale 0-4 Bradford City 33/-10 3,17 1.25/24 1.38/8 1.17/12 1.33/12   24/-16 2,67 0.88/24 1.38/8 1.08/12 0.67/12
2019-01-01 Doncaster 5-0 Rochdale 42/10 2,96 1.68/25 2.13/8 1.83/12 1.54/13   33/-14 3,20 1.20/25 1.25/8 1.08/13 1.33/12
2019-01-05 Rochdale 0-4 Burton 33/-19 3,27 1.15/26 1.25/8 1.08/13 1.23/13   30/-3 2,52 1.28/25 1.00/8 1.77/13 0.75/12
2019-01-12 Peterborough 2-1 Rochdale 45/12 3,00 1.69/26 1.25/8 1.31/13 2.08/13   33/-23 3,30 1.11/27 0.88/8 1.00/14 1.23/13
2019-01-19 Rochdale 1-1 Fleetwood 34/-24 3,29 1.07/28 0.88/8 1.00/14 1.14/14   37/5 2,56 1.30/27 1.38/8 1.64/14 0.92/13
2019-01-26 Barnsley 2-1 Rochdale 47/24 2,59 1.93/27 2.13/8 2.23/13 1.64/14   35/-24 3,24 1.07/29 0.88/8 1.00/15 1.14/14
2019-02-02 Walsall 1-2 Rochdale 33/-12 2,69 1.21/29 0.63/8 1.14/14 1.27/15   36/-25 3,23 1.03/30 0.88/8 1.00/15 1.07/15
2019-02-09 Rochdale 0-1 Coventry 38/-24 3,23 1.10/31 0.88/8 1.00/15 1.19/16   32/-5 2,23 1.29/31 1.38/8 1.44/16 1.13/15
2019-02-19 Rochdale 3-4 AFC Wimbledon 38/-25 3,16 1.06/32 0.50/8 0.94/16 1.19/16   23/-25 2,22 0.81/32 0.63/8 0.75/16 0.88/16
2019-02-23 Plymouth 5-1 Rochdale 40/-13 2,82 1.15/33 2.13/8 1.38/16 0.94/17   41/-26 3,27 1.03/33 0.50/8 0.88/17 1.19/16
2019-03-02 Luton 2-0 Rochdale 67/38 2,82 2.12/34 2.50/8 2.53/17 1.71/17   42/-30 3,35 1.00/34 0.50/8 0.88/17 1.12/17
2019-03-09 Rochdale 2-1 Shrewsbury 42/-32 3,31 0.97/35 0.50/8 0.88/17 1.06/18   38/-7 2,37 1.14/35 1.25/8 1.56/18 0.71/17
2019-03-12 Rochdale 0-0 Oxford Utd 44/-31 3,31 1.03/36 0.88/8 1.00/18 1.06/18   43/-11 2,69 1.08/36 1.13/8 1.44/18 0.72/18
2019-03-23 Rochdale 3-1 Scunthorpe 44/-31 3,22 1.03/37 0.88/8 1.00/19 1.06/18   46/-18 2,89 1.16/38 0.88/8 1.26/19 1.05/19
2019-03-30 Gillingham 1-1 Rochdale 53/-10 2,97 1.21/39 1.75/8 1.11/19 1.30/20   47/-29 3,24 1.08/38 1.25/8 1.10/20 1.06/18
2019-04-06 Rochdale 1-2 Sunderland 48/-29 3,21 1.08/39 1.00/8 1.10/20 1.05/19   67/33 2,66 2.00/38 2.25/8 2.16/19 1.84/19
2019-04-09 Accrington 0-1 Rochdale 41/-18 2,50 1.13/40 0.50/8 1.11/19 1.14/21   49/-30 3,20 1.05/40 1.00/8 1.05/21 1.05/19
2019-04-13 Portsmouth 4-1 Rochdale 71/28 2,85 1.93/40 2.13/8 1.89/19 1.95/21   50/-29 3,15 1.10/41 1.38/8 1.05/21 1.15/20
2019-04-19 Rochdale 1-0 Wycombe 51/-32 3,19 1.07/42 1.38/8 1.05/21 1.10/21   52/-12 2,76 1.12/42 0.50/8 1.38/21 0.86/21
2019-04-22 Bristol Rovers 0-1 Rochdale 45/-3 2,16 1.16/43 1.25/8 1.00/21 1.32/22   52/-31 3,14 1.12/43 1.75/8 1.14/22 1.10/21
2019-04-27 Rochdale 1-0 Southend 53/-30 3,09 1.16/44 1.75/8 1.14/22 1.18/22   53/-13 2,70 1.07/44 0.63/8 1.05/22 1.09/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