SELECT * FROM 1_Kampe WHERE LigaID = '320' AND (Home='Stoke' OR Away='Stoke') 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
2021-08-07 Stoke 3-2 Reading 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
2021-08-14 Birmingham 0-0 Stoke 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2021-08-17 Swansea 1-3 Stoke 1/-1 1,50 0.50/2 0.50/2 1.00/1 0.00/1   3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1
2021-08-21 Stoke 1-0 Nottingham 6/3 3,00 2.33/3 2.33/3 3.00/1 2.00/2   3/-3 3,00 0.00/3 0.00/3 0.00/2 0.00/1
2021-08-28 Fulham 3-0 Stoke 10/7 3,25 2.50/4 2.50/4 2.00/2 3.00/2   7/4 2,50 2.50/4 2.50/4 3.00/2 2.00/2
2021-09-11 Stoke 2-1 Huddersfield 7/1 2,60 2.00/5 2.00/5 3.00/2 1.33/3   9/2 3,20 2.00/5 2.00/5 2.00/3 2.00/2
2021-09-15 Stoke 1-1 Barnsley 9/2 2,67 2.17/6 2.17/6 3.00/3 1.33/3   5/-3 2,17 1.00/6 1.00/6 1.33/3 0.67/3
2021-09-18 Derby 2-1 Stoke 4/-2 1,43 1.00/7 1.00/7 1.00/3 1.00/4   10/2 2,57 2.00/7 2.00/7 2.50/4 1.33/3
2021-09-25 Stoke 2-0 Hull 11/1 2,63 1.75/8 1.75/8 2.50/4 1.00/4   5/-7 2,13 0.63/8 0.63/8 0.25/4 1.00/4
2021-09-28 Preston 1-1 Stoke 9/-2 2,22 1.11/9 1.25/8 1.75/4 0.60/5   13/3 2,56 1.89/9 1.75/8 2.60/5 1.00/4
2021-10-01 Stoke 1-0 West Brom 14/3 2,50 1.80/10 1.75/8 2.60/5 1.00/5   20/12 2,80 2.20/10 2.25/8 2.20/5 2.20/5
2021-10-16 Sheffield Utd 2-1 Stoke 14/-2 2,73 1.09/11 1.38/8 1.40/5 0.83/6   15/4 2,36 1.91/11 1.75/8 2.67/6 1.00/5
2021-10-19 Stoke 0-1 Bournemouth 16/3 2,42 1.75/12 1.38/8 2.67/6 0.83/6   20/12 2,33 2.33/12 2.50/8 2.33/6 2.33/6
2021-10-23 Millwall 2-1 Stoke 13/-1 2,08 1.38/13 1.63/8 1.33/6 1.43/7   16/2 2,31 1.62/13 1.38/8 2.29/7 0.83/6
2021-10-30 Stoke 3-3 Cardiff 17/1 2,36 1.50/14 1.00/8 2.29/7 0.71/7   12/-14 2,71 0.79/14 0.00/8 0.57/7 1.00/7
2021-11-03 Blackpool 0-1 Stoke 18/0 2,40 1.60/15 2.38/8 1.71/7 1.50/8   20/1 2,60 1.47/15 1.00/8 2.13/8 0.71/7
2021-11-06 Luton 0-1 Stoke 26/5 2,94 1.50/16 1.75/8 1.88/8 1.13/8   21/2 2,50 1.56/16 1.38/8 2.13/8 1.00/8
2021-11-20 Stoke 2-0 Peterborough 22/3 2,41 1.65/17 1.38/8 2.13/8 1.22/9   17/-15 2,88 0.88/17 1.00/8 1.33/9 0.38/8
2021-11-24 Bristol City 1-0 Stoke 20/-8 2,67 1.11/18 0.88/8 0.89/9 1.33/9   24/5 2,39 1.72/18 1.63/8 2.22/9 1.22/9
2021-11-27 Stoke 0-1 Blackburn 24/4 2,32 1.63/19 1.25/8 2.22/9 1.10/10   33/6 3,16 1.58/19 1.75/8 2.00/10 1.11/9
2021-12-05 QPR 0-2 Stoke 33/8 2,90 1.75/20 2.13/8 2.10/10 1.40/10   24/3 2,25 1.55/20 1.25/8 2.00/10 1.10/10
2021-12-11 Stoke 0-0 Middlesbrough 26/5 2,24 1.62/21 1.63/8 2.00/10 1.27/11   24/1 2,24 1.38/21 1.38/8 1.55/11 1.20/10
2021-12-30 Stoke 1-2 Derby 26/5 2,14 1.59/22 1.75/8 1.91/11 1.27/11   19/-2 1,74 1.22/23 1.38/8 1.67/12 0.73/11
2022-01-03 Stoke 1-2 Preston 27/4 2,17 1.52/23 1.63/8 1.75/12 1.27/11   24/-4 2,36 1.27/22 1.63/8 1.73/11 0.82/11
2022-01-16 Hull 0-2 Stoke 20/-9 2,04 0.96/24 1.75/8 1.09/11 0.85/13   28/3 2,21 1.46/24 1.25/8 1.62/13 1.27/11
2022-01-22 Stoke 2-3 Fulham 30/5 2,20 1.52/25 1.25/8 1.62/13 1.42/12   70/47 3,58 2.08/26 1.63/8 2.14/14 2.00/12
2022-01-25 Coventry 1-0 Stoke 34/4 2,56 1.48/25 0.88/8 1.77/13 1.17/12   32/4 2,31 1.46/26 0.88/8 1.50/14 1.42/12
2022-01-28 Huddersfield 1-1 Stoke 37/4 2,50 1.57/28 2.00/8 1.85/13 1.33/15   32/3 2,26 1.41/27 0.88/8 1.50/14 1.31/13
2022-02-08 Stoke 3-0 Swansea 33/3 2,25 1.39/28 1.00/8 1.50/14 1.29/14   29/-6 2,29 1.25/28 1.00/8 1.57/14 0.93/14
2022-02-12 Nottingham 2-2 Stoke 41/10 2,40 1.53/30 1.88/8 1.40/15 1.67/15   36/6 2,28 1.45/29 1.00/8 1.60/15 1.29/14
2022-02-19 Stoke 2-2 Birmingham 38/6 2,33 1.43/30 1.00/8 1.60/15 1.27/15   37/-12 2,69 1.13/32 1.13/8 1.38/16 0.88/16
2022-02-23 Stoke 1-2 Luton 40/6 2,39 1.42/31 1.13/8 1.56/16 1.27/15   43/7 2,55 1.55/31 2.00/8 1.81/16 1.27/15
2022-02-26 Bournemouth 2-1 Stoke 49/23 2,50 1.93/30 1.88/8 1.93/14 1.94/16   41/5 2,41 1.38/32 1.13/8 1.47/17 1.27/15
2022-03-05 Stoke 0-1 Blackpool 42/4 2,42 1.33/33 0.75/8 1.47/17 1.19/16   40/-1 2,38 1.32/34 1.50/8 1.61/18 1.00/16
2022-03-08 Barnsley 1-1 Stoke 24/-26 2,18 0.68/34 1.13/8 1.00/16 0.39/18   42/3 2,38 1.29/34 0.75/8 1.39/18 1.19/16
2022-03-12 Peterborough 2-2 Stoke 25/-45 2,71 0.63/35 0.25/8 1.06/16 0.26/19   43/3 2,37 1.29/35 0.88/8 1.39/18 1.18/17
2022-03-16 Cardiff 2-1 Stoke 43/-12 2,65 1.16/37 1.38/8 1.11/19 1.22/18   45/3 2,42 1.28/36 0.88/8 1.39/18 1.17/18
2022-03-19 Stoke 2-0 Millwall 46/2 2,43 1.24/37 0.50/8 1.39/18 1.11/19   39/5 1,97 1.54/37 2.50/8 1.89/19 1.17/18
2022-04-02 Stoke 1-0 Sheffield Utd 48/4 2,42 1.29/38 0.75/8 1.47/19 1.11/19   52/12 2,42 1.61/38 1.75/8 1.89/18 1.35/20
2022-04-05 Reading 2-1 Stoke 45/-29 3,05 1.03/39 1.38/8 1.16/19 0.90/20   49/5 2,38 1.33/39 1.00/8 1.55/20 1.11/19
2022-04-09 West Brom 1-3 Stoke 44/7 2,03 1.43/40 1.38/8 1.95/19 0.95/21   50/4 2,40 1.30/40 1.00/8 1.55/20 1.05/20
2022-04-15 Stoke 0-1 Bristol City 53/6 2,44 1.34/41 1.38/8 1.55/20 1.14/21   52/-21 3,05 1.10/41 0.63/8 1.33/21 0.85/20
2022-04-18 Blackburn 0-1 Stoke 53/9 2,31 1.50/42 0.75/8 1.95/21 1.05/21   53/5 2,40 1.31/42 1.38/8 1.48/21 1.14/21
2022-04-23 Stoke 1-0 QPR 54/6 2,37 1.35/43 1.63/8 1.48/21 1.23/22   58/3 2,63 1.47/43 0.88/8 1.64/22 1.29/21
2022-04-30 Middlesbrough 3-1 Stoke 55/10 2,27 1.52/44 1.38/8 1.86/22 1.18/22   55/7 2,34 1.39/44 1.88/8 1.55/22 1.23/22
2022-05-07 Stoke 1-1 Coventry 56/5 2,38 1.36/45 1.88/8 1.55/22 1.17/23   59/1 2,60 1.40/45 1.13/8 1.52/23 1.27/22