SELECT * FROM 1_Kampe WHERE LigaID = '5' AND (Home='Sunderland' OR Away='Sunderland') 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 Sunderland 2-1 Charlton 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 Luton 1-1 Sunderland 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-19 Sunderland 3-0 Scunthorpe 3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2018-08-22 Gillingham 1-4 Sunderland 6/3 3,00 2.00/3 2.00/3 3.00/1 1.50/2   6/4 2,67 2.33/3 2.33/3 3.00/2 1.00/1
2018-08-25 AFC Wimbledon 1-2 Sunderland 2/-1 1,25 1.25/4 1.25/4 0.50/2 2.00/2   10/7 3,25 2.50/4 2.50/4 3.00/2 2.00/2
2018-09-01 Sunderland 1-1 Oxford Utd 12/8 3,20 2.60/5 2.60/5 3.00/2 2.33/3   6/-8 4,00 0.60/5 0.60/5 1.00/3 0.00/2
2018-09-08 Sunderland 1-1 Fleetwood 13/8 3,00 2.33/6 2.33/6 2.33/3 2.33/3   11/7 2,50 1.83/6 1.83/6 1.33/3 2.33/3
2018-09-15 Burton 2-1 Sunderland 8/-2 2,57 1.00/7 1.00/7 2.00/3 0.25/4   14/8 2,86 2.14/7 2.14/7 2.00/4 2.33/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 Coventry 1-1 Sunderland 7/-3 1,89 1.22/9 1.38/8 1.50/4 1.00/5   19/10 3,11 2.00/9 1.88/8 2.20/5 1.75/4
2018-10-02 Sunderland 2-2 Peterborough 20/10 3,00 1.90/10 1.88/8 2.20/5 1.60/5   26/13 3,90 2.30/10 2.13/8 1.60/5 3.00/5
2018-10-06 Bradford City 1-2 Sunderland 8/-7 2,09 0.91/11 0.88/8 0.80/5 1.00/6   22/10 3,09 1.82/11 1.63/8 2.00/6 1.60/5
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 Doncaster 0-1 Sunderland 24/5 3,07 1.79/14 2.00/8 1.71/7 1.86/7   26/13 3,00 2.00/13 1.63/8 2.00/6 2.00/7
2018-10-27 Sunderland 3-0 Southend 27/14 2,86 2.07/14 1.88/8 2.00/6 2.13/8   21/3 2,60 1.53/15 2.00/8 1.25/8 1.86/7
2018-11-03 Plymouth 0-2 Sunderland 18/-9 2,81 0.81/16 1.25/8 1.00/8 0.63/8   30/17 2,87 2.13/15 2.13/8 2.14/7 2.13/8
2018-11-17 Sunderland 1-1 Wycombe 32/19 2,81 2.19/16 2.50/8 2.14/7 2.22/9   23/-1 2,76 1.24/17 1.63/8 1.67/9 0.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 Sunderland 4-2 Barnsley 35/19 2,83 2.06/18 2.25/8 2.00/8 2.10/10   32/17 2,61 1.94/18 2.00/8 2.11/9 1.78/9
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 Portsmouth 3-1 Sunderland 36/18 2,45 2.18/22 1.88/8 1.91/11 2.45/11   41/22 3,00 2.15/20 2.50/8 2.20/10 2.10/10
2018-12-26 Sunderland 1-0 Bradford City 42/20 3,05 2.05/21 2.13/8 2.20/10 1.91/11   24/-15 2,74 0.91/23 1.38/8 1.08/12 0.73/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 Blackpool 0-1 Sunderland 26/2 2,08 1.46/24 1.25/8 1.75/12 1.17/12   44/21 2,91 2.04/23 1.88/8 2.17/12 1.91/11
2019-01-05 Charlton 1-1 Sunderland 42/12 2,77 1.77/26 1.88/8 2.23/13 1.31/13   45/22 2,83 2.08/24 1.88/8 2.17/12 2.00/12
2019-01-12 Sunderland 1-1 Luton 46/22 2,80 2.04/25 1.88/8 2.17/12 1.92/13   49/25 2,81 2.00/26 2.50/8 2.54/13 1.46/13
2019-01-19 Scunthorpe 1-1 Sunderland 36/-17 3,18 1.18/28 1.50/8 1.14/14 1.21/14   47/22 2,77 2.00/26 1.88/8 2.08/13 1.92/13
2019-02-02 Sunderland 1-0 AFC Wimbledon 48/22 2,74 1.96/27 1.63/8 2.08/13 1.86/14   22/-23 2,31 0.79/29 1.00/8 0.80/15 0.79/14
2019-02-09 Oxford Utd 1-1 Sunderland 37/-9 2,77 1.07/30 0.88/8 1.47/15 0.67/15   49/23 2,68 2.00/28 1.63/8 2.14/14 1.86/14
2019-02-12 Sunderland 1-1 Blackpool 50/23 2,66 1.97/29 1.75/8 2.14/14 1.80/15   33/6 2,00 1.53/30 1.50/8 1.63/16 1.43/14
2019-02-15 Sunderland 2-2 Accrington 51/23 2,63 1.93/30 1.50/8 2.07/15 1.80/15   27/-11 2,24 1.24/29 1.00/8 1.31/13 1.19/16
2019-02-19 Sunderland 4-2 Gillingham 53/23 2,68 1.90/31 1.50/8 2.00/16 1.80/15   42/-11 2,97 1.13/32 1.00/8 1.06/17 1.20/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 Sunderland 2-0 Plymouth 59/27 2,76 1.97/33 1.75/8 2.06/17 1.88/16   45/-9 2,91 1.21/34 2.13/8 1.47/17 0.94/17
2019-03-09 Wycombe 1-1 Sunderland 44/-8 2,74 1.23/35 1.00/8 1.65/17 0.83/18   61/29 2,74 2.00/34 2.00/8 2.11/18 1.88/16
2019-03-12 Barnsley 0-0 Sunderland 64/36 2,56 2.03/36 2.25/8 2.33/18 1.72/18   62/29 2,71 1.97/35 2.00/8 2.11/18 1.82/17
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-04-03 Accrington 0-3 Sunderland 40/-15 2,50 1.16/38 0.88/8 1.17/18 1.15/20   64/30 2,65 1.97/37 2.00/8 2.16/19 1.78/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 Sunderland 1-1 Burton 69/34 2,67 2.03/39 2.50/8 2.16/19 1.90/20   56/9 2,58 1.40/40 1.75/8 1.67/21 1.11/19
2019-04-13 Sunderland 4-5 Coventry 70/34 2,65 2.00/40 2.25/8 2.10/20 1.90/20   45/0 2,20 1.41/41 1.50/8 1.43/21 1.40/20
2019-04-19 Sunderland 2-0 Doncaster 74/33 2,80 1.95/41 1.88/8 2.00/21 1.90/20   71/19 2,93 1.64/42 1.75/8 2.05/21 1.24/21
2019-04-22 Peterborough 1-1 Sunderland 64/9 2,83 1.55/42 1.63/8 1.43/21 1.67/21   76/35 2,79 1.98/42 1.88/8 2.05/22 1.90/20
2019-04-27 Sunderland 1-1 Portsmouth 77/35 2,77 1.95/43 1.88/8 2.05/22 1.86/21   79/33 2,91 2.00/43 2.63/8 2.00/21 2.00/22
2019-04-30 Fleetwood 2-1 Sunderland 56/6 2,41 1.32/44 1.13/8 1.50/22 1.14/22   78/35 2,75 1.93/44 1.88/8 2.00/23 1.86/21
2019-05-04 Southend 2-1 Sunderland 53/-14 2,67 1.04/45 0.63/8 1.05/22 1.04/23   79/34 2,76 1.89/45 1.50/8 2.00/23 1.77/22