SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Walsall' OR Away='Walsall') 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 Walsall 2-1 Plymouth 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 Scunthorpe 1-1 Walsall 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 Walsall 2-1 Gillingham 3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1   5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1
2018-08-21 AFC Wimbledon 1-3 Walsall 1/1 0,33 1.67/3 1.67/3 1.00/1 2.00/2   5/2 2,67 2.33/3 2.33/3 3.00/2 1.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 Walsall 0-0 Blackpool 10/5 3,00 2.60/5 2.60/5 3.00/2 2.33/3   4/1 1,40 1.20/5 1.20/5 1.33/3 1.00/2
2018-09-08 Barnsley 1-1 Walsall 14/11 2,83 2.33/6 2.33/6 2.33/3 2.33/3   10/5 2,50 2.33/6 2.33/6 2.33/3 2.33/3
2018-09-15 Walsall 1-4 Doncaster 11/5 2,43 2.14/7 2.14/7 2.33/3 2.00/4   9/4 2,00 1.71/7 1.71/7 2.00/4 1.33/3
2018-09-22 Oxford Utd 1-2 Walsall 8/-9 3,13 0.63/8 0.63/8 0.75/4 0.50/4   12/2 2,75 1.88/8 1.88/8 1.75/4 2.00/4
2018-09-29 Walsall 0-1 Accrington 14/3 2,78 2.00/9 1.88/8 1.75/4 2.20/5   12/1 2,56 1.56/9 1.75/8 1.20/5 2.00/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 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-20 Luton 2-0 Walsall 19/1 2,85 1.46/13 1.50/8 2.33/6 0.71/7   15/3 2,25 1.83/12 1.50/8 1.33/6 2.33/6
2018-10-23 Southend 3-0 Walsall 18/0 2,57 1.43/14 1.63/8 1.00/7 1.86/7   15/1 2,23 1.69/13 1.13/8 1.33/6 2.00/7
2018-10-27 Walsall 3-2 Wycombe 15/-2 2,29 1.57/14 1.00/8 1.33/6 1.75/8   20/-1 2,73 1.20/15 1.50/8 1.50/8 0.86/7
2018-11-03 Walsall 1-3 Burton 18/-1 2,47 1.67/15 1.25/8 1.57/7 1.75/8   19/-2 2,67 1.20/15 1.38/8 1.63/8 0.71/7
2018-11-06 Walsall 0-2 Charlton 19/-3 2,56 1.56/16 1.25/8 1.38/8 1.75/8   24/4 2,75 1.56/16 1.38/8 1.89/9 1.14/7
2018-11-17 Fleetwood 0-0 Walsall 24/5 2,53 1.35/17 1.25/8 1.50/8 1.22/9   19/-5 2,53 1.47/17 0.88/8 1.22/9 1.75/8
2018-11-24 Walsall 2-2 Sunderland 19/-5 2,39 1.44/18 1.00/8 1.22/9 1.67/9   33/19 2,76 2.12/17 2.25/8 2.00/8 2.22/9
2018-11-27 Portsmouth 2-0 Walsall 30/15 2,50 2.28/18 2.13/8 1.88/8 2.60/10   21/-5 2,47 1.42/19 1.00/8 1.20/10 1.67/9
2018-12-08 Walsall 2-1 Coventry 21/-7 2,45 1.35/20 0.63/8 1.20/10 1.50/10   21/-2 2,20 1.45/20 1.75/8 1.50/10 1.40/10
2018-12-15 Bradford City 4-0 Walsall 18/-21 2,71 0.71/21 0.63/8 0.70/10 0.73/11   23/-6 2,48 1.43/21 1.00/8 1.36/11 1.50/10
2018-12-22 Peterborough 1-1 Walsall 40/12 3,09 1.82/22 1.63/8 1.45/11 2.18/11   23/-10 2,55 1.36/22 1.00/8 1.36/11 1.36/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 Walsall 2-2 Luton 25/-12 2,58 1.29/24 0.75/8 1.25/12 1.33/12   47/25 2,88 2.08/24 2.75/8 2.67/12 1.50/12
2019-01-01 Charlton 2-1 Walsall 40/11 2,76 1.72/25 1.88/8 2.17/12 1.31/13   27/-12 2,64 1.28/25 0.88/8 1.23/13 1.33/12
2019-01-12 Walsall 1-2 Scunthorpe 28/-13 2,65 1.23/26 0.75/8 1.23/13 1.23/13   34/-18 3,19 1.11/27 1.13/8 1.14/14 1.08/13
2019-01-19 Gillingham 0-3 Walsall 39/-6 3,11 1.15/27 1.63/8 1.08/13 1.21/14   29/-14 2,67 1.19/27 0.63/8 1.14/14 1.23/13
2019-01-22 Plymouth 2-1 Walsall 36/-14 3,07 1.07/28 1.75/8 1.29/14 0.86/14   32/-11 2,68 1.25/28 1.00/8 1.14/14 1.36/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 Blackpool 2-0 Walsall 31/4 2,00 1.48/29 1.13/8 1.53/15 1.43/14   34/-13 2,70 1.17/30 0.63/8 1.07/15 1.27/15
2019-02-12 Walsall 0-1 AFC Wimbledon 34/-15 2,68 1.13/31 0.50/8 1.07/15 1.19/16   22/-26 2,26 0.74/31 0.63/8 0.75/16 0.73/15
2019-02-16 Coventry 3-0 Walsall 33/-4 2,19 1.34/32 1.38/8 1.44/16 1.25/16   34/-16 2,63 1.09/32 0.50/8 1.00/16 1.19/16
2019-02-23 Walsall 3-2 Bradford City 34/-19 2,64 1.06/33 0.38/8 1.00/16 1.12/17   36/-16 2,67 1.00/33 1.13/8 1.18/17 0.81/16
2019-03-02 Burton 0-0 Walsall 42/1 2,44 1.26/34 1.00/8 1.47/17 1.06/17   37/-18 2,71 1.12/34 0.75/8 1.12/17 1.12/17
2019-03-09 Walsall 2-0 Fleetwood 37/-18 2,63 1.11/35 0.88/8 1.12/17 1.11/18   46/9 2,37 1.40/35 1.75/8 1.50/18 1.29/17
2019-03-12 Walsall 2-3 Portsmouth 39/-16 2,61 1.17/36 0.88/8 1.22/18 1.11/18   61/22 2,78 1.81/36 1.00/8 1.83/18 1.78/18
2019-03-16 Sunderland 2-1 Walsall 62/29 2,64 1.94/36 1.75/8 2.11/18 1.78/18   41/-17 2,68 1.14/37 0.88/8 1.16/19 1.11/18
2019-03-23 Walsall 0-1 Barnsley 42/-18 2,68 1.11/38 0.88/8 1.16/19 1.05/19   64/36 2,42 1.97/38 2.00/8 2.26/19 1.68/19
2019-03-30 Doncaster 3-1 Walsall 65/14 2,97 1.54/39 0.88/8 1.95/19 1.15/20   42/-19 2,64 1.08/39 0.88/8 1.10/20 1.05/19
2019-04-06 Walsall 1-3 Oxford Utd 43/-21 2,68 1.05/40 0.88/8 1.10/20 1.00/20   47/-8 2,55 1.23/40 2.00/8 1.60/20 0.85/20
2019-04-13 Accrington 2-1 Walsall 41/-19 2,46 1.10/41 0.50/8 1.05/20 1.14/21   44/-23 2,71 1.02/41 0.88/8 1.05/21 1.00/20
2019-04-19 Walsall 1-1 Southend 45/-24 2,71 1.00/42 0.50/8 1.05/21 0.95/21   49/-14 2,67 1.02/42 0.25/8 0.95/21 1.10/21
2019-04-22 Wycombe 1-0 Walsall 52/-13 2,72 1.09/43 0.50/8 1.38/21 0.82/22   46/-24 2,70 1.00/43 0.50/8 1.05/22 0.95/21
2019-04-27 Walsall 3-0 Peterborough 46/-25 2,66 0.98/44 0.13/8 1.05/22 0.91/22   65/9 2,81 1.53/43 1.38/8 1.41/22 1.67/21
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