SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Shrewsbury' OR Away='Shrewsbury') 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 Shrewsbury 0-1 Bradford City 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 Charlton 2-1 Shrewsbury 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-08-18 Shrewsbury 0-0 Blackpool 1/-2 2,00 0.00/2 0.00/2 0.00/1 0.00/1   1/-1 1,50 0.50/2 0.50/2 0.00/1 1.00/1
2018-08-21 Doncaster 0-0 Shrewsbury 6/3 3,00 2.00/3 2.00/3 3.00/1 1.50/2   1/-2 1,33 0.33/3 0.33/3 0.50/2 0.00/1
2018-08-25 Luton 3-2 Shrewsbury 4/-1 2,25 1.00/4 1.00/4 2.00/2 0.00/2   1/-2 1,00 0.50/4 0.50/4 0.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 Portsmouth 1-1 Shrewsbury 12/9 2,50 2.67/6 2.67/6 3.00/3 2.33/3   4/-3 1,83 0.50/6 0.50/6 0.67/3 0.33/3
2018-09-15 Shrewsbury 2-0 Southend 5/-3 1,86 0.57/7 0.57/7 0.67/3 0.50/4   9/-2 2,86 1.00/7 1.00/7 0.75/4 1.33/3
2018-09-22 Scunthorpe 1-0 Shrewsbury 12/-6 3,75 1.25/8 1.25/8 0.75/4 1.75/4   7/-1 1,88 0.88/8 0.88/8 1.25/4 0.50/4
2018-09-29 Shrewsbury 2-2 Gillingham 7/-2 1,78 0.78/9 0.88/8 1.25/4 0.40/5   11/-7 3,22 0.78/9 0.50/8 0.80/5 0.75/4
2018-10-02 Walsall 0-0 Shrewsbury 14/2 2,60 1.80/10 1.75/8 1.40/5 2.20/5   9/-2 2,00 0.80/10 1.00/8 1.20/5 0.40/5
2018-10-06 Shrewsbury 1-0 Accrington 9/-2 1,82 0.82/11 1.00/8 1.20/5 0.50/6   14/3 2,27 1.82/11 2.00/8 1.50/6 2.20/5
2018-10-13 Fleetwood 2-1 Shrewsbury 19/8 2,50 1.42/12 1.25/8 1.00/6 1.83/6   10/-1 1,75 1.00/12 1.25/8 1.50/6 0.50/6
2018-10-20 Shrewsbury 0-2 Sunderland 11/-2 1,85 0.92/13 1.25/8 1.50/6 0.43/7   24/11 3,08 1.92/12 1.63/8 2.00/6 1.83/6
2018-10-23 Shrewsbury 3-1 Barnsley 11/-4 1,86 0.86/14 1.13/8 1.29/7 0.43/7   26/15 2,85 1.92/13 1.75/8 2.00/6 1.86/7
2018-10-27 Oxford Utd 3-0 Shrewsbury 14/-10 2,53 0.73/15 0.88/8 0.86/7 0.63/8   14/-2 2,00 1.00/15 1.38/8 1.50/8 0.43/7
2018-11-03 AFC Wimbledon 1-2 Shrewsbury 10/-14 2,13 0.69/16 0.38/8 0.50/8 0.88/8   14/-5 2,06 0.94/16 1.00/8 1.50/8 0.38/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 Wycombe 3-2 Shrewsbury 24/-1 2,72 1.22/18 1.75/8 1.67/9 0.78/9   19/-3 2,28 1.17/18 1.63/8 1.67/9 0.67/9
2018-11-27 Shrewsbury 2-0 Plymouth 21/-4 2,42 1.11/19 1.50/8 1.67/9 0.60/10   21/-14 2,95 0.84/19 1.50/8 1.10/10 0.56/9
2018-12-08 Burton 2-1 Shrewsbury 24/-3 2,68 1.26/19 1.63/8 1.60/10 0.89/9   23/-2 2,40 1.20/20 1.50/8 1.80/10 0.60/10
2018-12-15 Shrewsbury 2-2 Peterborough 24/-3 2,43 1.14/21 1.50/8 1.80/10 0.55/11   38/12 3,05 1.86/21 1.50/8 1.45/11 2.30/10
2018-12-22 Shrewsbury 1-0 Coventry 26/-3 2,50 1.14/22 1.63/8 1.73/11 0.55/11   23/-4 2,27 1.32/22 1.00/8 1.36/11 1.27/11
2018-12-26 Accrington 2-1 Shrewsbury 25/-2 2,36 1.41/22 0.63/8 1.30/10 1.50/12   27/-2 2,43 1.22/23 1.63/8 1.83/12 0.55/11
2018-12-29 Sunderland 1-1 Shrewsbury 43/21 2,95 2.09/22 2.13/8 2.27/11 1.91/11   28/-3 2,46 1.17/24 1.63/8 1.83/12 0.50/12
2019-01-01 Shrewsbury 0-0 Fleetwood 29/-3 2,44 1.16/25 1.38/8 1.83/12 0.54/13   35/5 2,60 1.32/25 1.25/8 1.69/13 0.92/12
2019-01-12 Shrewsbury 0-3 Charlton 29/-3 2,35 1.15/26 1.13/8 1.77/13 0.54/13   43/12 2,74 1.74/27 1.63/8 2.14/14 1.31/13
2019-01-19 Blackpool 0-0 Shrewsbury 27/2 2,00 1.46/26 0.88/8 1.62/13 1.31/13   29/-6 2,37 1.11/27 1.13/8 1.64/14 0.54/13
2019-01-29 Bradford City 4-3 Shrewsbury 32/-16 2,76 0.97/29 1.63/8 1.14/14 0.80/15   29/-6 2,29 1.11/28 0.88/8 1.64/14 0.57/14
2019-02-02 Shrewsbury 0-3 Luton 32/-7 2,45 1.07/29 0.88/8 1.64/14 0.53/15   58/31 2,83 2.07/30 2.25/8 2.60/15 1.53/15
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-16 Shrewsbury 1-1 Burton 33/-10 2,45 1.03/31 0.50/8 1.53/15 0.56/16   41/2 2,58 1.32/31 1.38/8 1.56/16 1.07/15
2019-02-23 Peterborough 1-2 Shrewsbury 51/7 2,88 1.58/33 1.00/8 1.31/16 1.82/17   34/-10 2,44 1.03/32 0.63/8 1.50/16 0.56/16
2019-02-26 Shrewsbury 2-0 Doncaster 36/-9 2,45 1.09/33 0.88/8 1.50/16 0.71/17   59/19 3,09 1.69/32 1.88/8 2.00/16 1.38/16
2019-03-02 Shrewsbury 0-0 AFC Wimbledon 38/-7 2,44 1.15/34 1.13/8 1.59/17 0.71/17   28/-25 2,38 0.85/34 0.88/8 0.71/17 1.00/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 Plymouth 2-1 Shrewsbury 45/-11 2,81 1.17/36 1.50/8 1.44/18 0.89/18   39/-8 2,39 1.11/36 1.13/8 1.56/18 0.67/18
2019-03-16 Shrewsbury 2-1 Wycombe 40/-9 2,41 1.08/37 1.13/8 1.56/18 0.63/19   46/-10 2,76 1.19/37 0.38/8 1.53/19 0.83/18
2019-03-23 Shrewsbury 0-2 Portsmouth 42/-8 2,42 1.13/38 1.50/8 1.63/19 0.63/19   66/25 2,82 1.87/38 1.63/8 1.89/19 1.84/19
2019-03-30 Southend 0-2 Shrewsbury 47/-10 2,67 1.08/39 0.38/8 1.05/19 1.10/20   42/-10 2,41 1.10/39 1.38/8 1.55/20 0.63/19
2019-04-06 Shrewsbury 1-1 Scunthorpe 44/-8 2,40 1.15/40 1.63/8 1.55/20 0.75/20   48/-21 2,93 1.10/40 0.50/8 1.20/20 1.00/20
2019-04-13 Gillingham 0-2 Shrewsbury 54/-12 2,93 1.17/41 1.50/8 1.10/20 1.24/21   45/-8 2,39 1.15/41 1.38/8 1.52/21 0.75/20
2019-04-19 Barnsley 2-1 Shrewsbury 72/37 2,55 1.95/42 1.88/8 2.24/21 1.67/21   47/-6 2,38 1.19/42 1.38/8 1.52/21 0.86/21
2019-04-22 Shrewsbury 2-3 Oxford Utd 48/-7 2,40 1.16/43 1.25/8 1.52/21 0.82/22   52/-5 2,53 1.30/43 2.13/8 1.64/22 0.95/21
2019-04-28 Coventry 1-1 Shrewsbury 53/2 2,36 1.45/44 1.75/8 1.50/22 1.41/22   50/-8 2,45 1.14/44 1.25/8 1.45/22 0.82/22
2019-05-04 Shrewsbury 0-0 Walsall 51/-8 2,44 1.13/45 1.38/8 1.45/22 0.83/23   49/-22 2,67 1.02/45 0.50/8 1.13/23 0.91/22