SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Bristol Rovers' OR Away='Bristol Rovers') 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 Peterborough 2-1 Bristol Rovers 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 Bristol Rovers 1-2 Accrington 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-2 2,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-08-18 Wycombe 1-2 Bristol Rovers 0/-3 1,50 0.50/2 0.50/2 1.00/1 0.00/1   2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2018-08-21 Bristol Rovers 1-2 Portsmouth 4/-1 3,00 1.00/3 1.00/3 0.00/1 1.50/2   7/5 3,00 3.00/3 3.00/3 3.00/2 3.00/1
2018-08-25 Bristol Rovers 0-1 Southend 5/-2 3,00 0.75/4 0.75/4 0.00/2 1.50/2   5/-1 2,75 1.00/4 1.00/4 1.50/2 0.50/2
2018-09-01 Shrewsbury 1-1 Bristol Rovers 3/-3 1,80 0.40/5 0.40/5 0.50/2 0.33/3   5/-3 2,60 0.60/5 0.60/5 0.00/3 1.50/2
2018-09-08 Bristol Rovers 0-0 Plymouth 6/-3 2,50 0.67/6 0.67/6 0.00/3 1.33/3   4/-9 2,83 0.33/6 0.33/6 0.67/3 0.00/3
2018-09-15 Luton 1-0 Bristol Rovers 9/-1 2,71 1.14/7 1.14/7 2.33/3 0.25/4   6/-3 2,14 0.71/7 0.71/7 0.25/4 1.33/3
2018-09-22 Bristol Rovers 3-1 Coventry 6/-4 2,00 0.63/8 0.63/8 0.25/4 1.00/4   6/-1 1,63 1.38/8 1.38/8 1.50/4 1.25/4
2018-09-29 Bradford City 0-0 Bristol Rovers 7/-8 2,44 0.67/9 0.38/8 0.75/4 0.60/5   9/-2 2,22 0.89/9 1.00/8 0.80/5 1.00/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 Bristol Rovers 0-1 Walsall 9/-2 1,82 0.91/11 0.88/8 0.80/5 1.00/6   14/2 2,36 1.73/11 1.50/8 1.33/6 2.20/5
2018-10-13 Burton 1-0 Bristol Rovers 12/-3 2,45 1.00/11 1.00/8 1.67/6 0.20/5   9/-3 1,75 0.83/12 0.88/8 0.67/6 1.00/6
2018-10-20 Bristol Rovers 0-0 Oxford Utd 9/-4 1,69 0.77/13 0.88/8 0.67/6 0.86/7   13/-10 2,77 0.69/13 0.75/8 0.86/7 0.50/6
2018-10-23 Bristol Rovers 2-0 AFC Wimbledon 9/-4 1,57 0.79/14 0.88/8 0.71/7 0.86/7   10/-10 2,14 0.79/14 0.75/8 0.57/7 1.00/7
2018-10-27 Barnsley 1-0 Bristol Rovers 27/13 2,93 1.79/14 1.38/8 2.00/6 1.63/8   11/-2 1,60 0.93/15 1.13/8 1.00/8 0.86/7
2018-11-03 Blackpool 0-3 Bristol Rovers 17/5 2,07 1.57/14 1.88/8 1.88/8 1.17/6   11/-3 1,56 0.88/16 1.13/8 1.00/8 0.75/8
2018-11-17 Bristol Rovers 1-2 Scunthorpe 14/0 1,65 1.00/17 1.13/8 1.00/8 1.00/9   26/-11 3,71 1.06/17 0.63/8 1.11/9 1.00/8
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 Bristol Rovers 1-2 Gillingham 16/-3 1,84 0.89/19 0.88/8 0.89/9 0.90/10   27/-6 3,16 0.95/19 0.88/8 1.00/10 0.89/9
2018-12-08 Bristol Rovers 0-4 Doncaster 17/-4 1,90 0.85/20 0.88/8 0.80/10 0.90/10   30/4 2,80 1.60/20 1.38/8 1.80/10 1.40/10
2018-12-15 Sunderland 2-1 Bristol Rovers 39/21 3,00 2.11/19 2.50/8 2.11/9 2.10/10   17/-8 2,00 0.81/21 0.88/8 0.73/11 0.90/10
2018-12-22 Bristol Rovers 2-1 Fleetwood 18/-9 2,05 0.77/22 0.75/8 0.73/11 0.82/11   29/6 2,36 1.36/22 1.25/8 1.73/11 1.00/11
2018-12-26 Walsall 1-3 Bristol Rovers 24/-10 2,52 1.35/23 0.75/8 1.36/11 1.33/12   20/-8 2,09 0.87/23 0.75/8 0.92/12 0.82/11
2018-12-29 Oxford Utd 0-2 Bristol Rovers 31/-5 2,79 1.08/24 1.50/8 1.50/12 0.67/12   23/-6 2,17 0.96/24 1.13/8 0.92/12 1.00/12
2019-01-01 Bristol Rovers 0-0 Burton 25/-4 2,16 1.04/25 1.13/8 0.92/12 1.15/13   30/-3 2,63 1.29/24 1.25/8 1.77/13 0.73/11
2019-01-12 Accrington 0-0 Bristol Rovers 27/-8 2,48 1.36/25 0.75/8 1.33/12 1.38/13   25/-4 2,08 1.04/26 1.25/8 0.92/13 1.15/13
2019-01-19 Bristol Rovers 0-1 Wycombe 25/-4 2,00 1.04/27 1.38/8 0.92/13 1.14/14   37/-3 2,85 1.30/27 1.25/8 1.71/14 0.85/13
2019-01-29 Bristol Rovers 2-2 Peterborough 25/-5 1,96 1.00/28 1.38/8 0.86/14 1.14/14   47/9 2,93 1.66/29 1.13/8 1.40/15 1.93/14
2019-02-02 Southend 1-2 Bristol Rovers 38/3 2,52 1.31/29 1.50/8 1.27/15 1.36/14   27/-5 2,03 1.00/29 1.50/8 0.87/15 1.14/14
2019-02-09 Bristol Rovers 1-1 Shrewsbury 29/-4 2,07 1.07/30 1.88/8 0.87/15 1.27/15   32/-10 2,47 1.03/30 0.75/8 1.53/15 0.53/15
2019-02-19 Portsmouth 1-1 Bristol Rovers 54/19 2,78 1.88/32 1.13/8 1.87/15 1.88/17   30/-4 2,06 1.06/31 1.63/8 0.88/16 1.27/15
2019-02-23 Bristol Rovers 0-2 Sunderland 31/-4 2,06 1.06/32 1.38/8 0.88/16 1.25/16   57/25 2,78 1.94/32 1.50/8 2.06/17 1.80/15
2019-03-02 Bristol Rovers 4-0 Blackpool 31/-6 2,06 1.03/33 1.00/8 0.82/17 1.25/16   34/5 1,91 1.45/33 1.63/8 1.53/17 1.38/16
2019-03-09 Scunthorpe 0-1 Bristol Rovers 42/-18 2,91 1.17/35 1.38/8 1.24/17 1.11/18   35/-2 2,12 1.09/34 1.25/8 0.94/18 1.25/16
2019-03-12 Gillingham 0-1 Bristol Rovers 47/-11 2,92 1.19/36 1.50/8 1.17/18 1.22/18   36/-1 2,09 1.14/35 1.50/8 0.94/18 1.35/17
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-23 Plymouth 2-2 Bristol Rovers 47/-12 2,79 1.18/38 1.50/8 1.53/19 0.84/19   37/0 2,00 1.19/37 1.88/8 0.95/19 1.44/18
2019-03-26 Doncaster 4-1 Bristol Rovers 61/11 2,92 1.50/38 0.88/8 1.89/18 1.15/20   39/0 2,05 1.18/38 1.63/8 0.95/19 1.42/19
2019-03-30 Bristol Rovers 1-2 Luton 40/-3 2,13 1.15/39 1.50/8 0.95/19 1.35/20   76/45 2,74 2.13/39 2.25/8 2.50/20 1.74/19
2019-04-07 Coventry 0-0 Bristol Rovers 45/0 2,25 1.43/40 1.75/8 1.45/20 1.40/20   41/-4 2,15 1.13/40 1.38/8 0.90/20 1.35/20
2019-04-13 Bristol Rovers 3-2 Bradford City 41/-4 2,10 1.12/41 1.50/8 0.90/20 1.33/21   43/-26 2,73 0.88/41 0.38/8 1.10/21 0.65/20
2019-04-19 AFC Wimbledon 1-1 Bristol Rovers 37/-22 2,29 1.05/42 1.88/8 0.90/21 1.19/21   44/-3 2,17 1.17/42 1.50/8 1.00/21 1.33/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 Fleetwood 0-0 Bristol Rovers 56/6 2,47 1.33/43 1.00/8 1.52/21 1.14/22   45/-4 2,14 1.14/44 0.88/8 0.95/22 1.32/22
2019-05-04 Bristol Rovers 2-1 Barnsley 45/-4 2,09 1.13/45 0.88/8 0.95/22 1.30/23   79/42 2,58 2.02/45 2.13/8 2.30/23 1.73/22