SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='Aston Villa' OR Away='Aston Villa') 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
2019-08-10 Tottenham 3-1 Aston Villa 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
2019-08-17 Aston Villa 1-2 Bournemouth 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-08-23 Aston Villa 2-0 Everton 2/-3 3,50 0.00/2 0.00/2 0.00/1 0.00/1   1/1 0,50 2.00/2 2.00/2 3.00/1 1.00/1
2019-08-31 Crystal Palace 1-0 Aston Villa 2/0 1,33 1.33/3 1.33/3 1.00/1 1.50/2   4/-1 3,00 1.00/3 1.00/3 1.50/2 0.00/1
2019-09-16 Aston Villa 0-0 West Ham 4/-2 2,50 0.75/4 0.75/4 1.50/2 0.00/2   6/-1 3,25 1.75/4 1.75/4 1.50/2 2.00/2
2019-09-22 Arsenal 3-2 Aston Villa 8/0 3,20 1.60/5 1.60/5 2.00/2 1.33/3   4/-2 2,00 0.80/5 0.80/5 1.33/3 0.00/2
2019-09-28 Aston Villa 2-2 Burnley 6/-3 2,50 0.67/6 0.67/6 1.33/3 0.00/3   8/1 2,50 1.33/6 1.33/6 2.00/3 0.67/3
2019-10-05 Norwich 1-5 Aston Villa 9/-7 3,57 0.86/7 0.86/7 2.00/3 0.00/4   8/-3 2,71 0.71/7 0.71/7 1.25/4 0.00/3
2019-10-19 Aston Villa 2-1 Brighton 13/1 3,13 1.00/8 1.00/8 1.25/4 0.75/4   8/-2 2,25 1.13/8 1.13/8 1.25/4 1.00/4
2019-10-26 Manchester City 3-0 Aston Villa 29/20 4,22 2.11/9 2.00/8 1.75/4 2.40/5   15/2 3,11 1.22/9 1.38/8 1.60/5 0.75/4
2019-11-02 Aston Villa 1-2 Liverpool 15/-1 3,10 1.10/10 1.38/8 1.60/5 0.60/5   23/15 3,10 2.80/10 2.75/8 3.00/5 2.60/5
2019-11-10 Wolves 2-1 Aston Villa 14/0 2,55 1.18/11 1.25/8 1.20/5 1.17/6   16/-2 3,09 1.00/11 1.00/8 1.33/6 0.60/5
2019-11-25 Aston Villa 2-0 Newcastle 17/-3 3,08 0.92/12 1.00/8 1.33/6 0.50/6   11/-7 2,42 1.25/12 1.38/8 1.50/6 1.00/6
2019-12-01 Manchester Utd 2-2 Aston Villa 19/4 2,62 1.31/13 1.13/8 1.83/6 0.86/7   19/-1 3,00 1.08/13 1.25/8 1.57/7 0.50/6
2019-12-04 Chelsea 2-1 Aston Villa 28/8 3,43 1.86/14 2.25/8 1.57/7 2.14/7   21/-1 3,07 1.07/14 1.38/8 1.57/7 0.57/7
2019-12-08 Aston Villa 1-4 Leicester 22/-2 3,07 1.00/15 1.25/8 1.57/7 0.50/8   35/26 2,93 2.33/15 2.63/8 2.75/8 1.86/7
2019-12-14 Sheffield Utd 2-0 Aston Villa 19/3 2,19 1.38/16 1.63/8 1.25/8 1.50/8   23/-5 3,19 0.94/16 0.88/8 1.38/8 0.50/8
2019-12-21 Aston Villa 1-3 Southampton 23/-7 3,12 0.88/17 0.50/8 1.38/8 0.44/9   18/-18 3,18 0.88/17 0.88/8 0.78/9 1.00/8
2019-12-26 Aston Villa 1-0 Norwich 24/-9 3,17 0.83/18 0.50/8 1.22/9 0.44/9   19/-18 3,11 0.67/18 0.63/8 0.78/9 0.56/9
2019-12-28 Watford 3-0 Aston Villa 12/-21 2,37 0.68/19 1.00/8 0.78/9 0.60/10   25/-8 3,05 0.95/19 0.88/8 1.40/10 0.44/9
2020-01-01 Burnley 1-2 Aston Villa 23/-9 2,75 1.20/20 1.13/8 1.50/10 0.90/10   25/-11 3,05 0.90/20 0.88/8 1.40/10 0.40/10
2020-01-12 Aston Villa 1-6 Manchester City 27/-10 3,05 1.00/21 0.88/8 1.40/10 0.64/11   56/32 3,81 2.10/21 2.00/8 2.27/11 1.90/10
2020-01-18 Brighton 1-1 Aston Villa 25/-5 2,50 1.09/22 1.13/8 1.45/11 0.73/11   28/-15 3,23 0.95/22 0.75/8 1.27/11 0.64/11
2020-01-21 Aston Villa 2-1 Watford 29/-15 3,17 0.96/23 0.88/8 1.27/11 0.67/12   20/-14 2,35 1.00/23 1.88/8 1.17/12 0.82/11
2020-02-01 Bournemouth 2-1 Aston Villa 23/-14 2,50 0.96/24 0.88/8 1.08/12 0.83/12   31/-14 3,17 1.04/24 1.25/8 1.42/12 0.67/12
2020-02-16 Aston Villa 2-3 Tottenham 32/-15 3,16 1.00/25 1.25/8 1.42/12 0.62/13   40/8 2,88 1.48/25 1.38/8 2.00/13 0.92/12
2020-02-22 Southampton 2-0 Aston Villa 32/-16 3,08 1.19/26 1.63/8 0.85/13 1.54/13   34/-16 3,23 0.96/26 1.25/8 1.31/13 0.62/13
2020-03-09 Leicester 4-0 Aston Villa 54/26 2,93 1.79/28 1.00/8 1.93/14 1.64/14   34/-18 3,19 0.93/27 0.88/8 1.31/13 0.57/14
2020-06-17 Aston Villa 0-0 Sheffield Utd 34/-22 3,21 0.89/28 0.88/8 1.31/13 0.53/15   30/5 1,96 1.54/28 1.75/8 1.60/15 1.46/13
2020-06-21 Aston Villa 1-2 Chelsea 34/-22 3,10 0.90/29 0.63/8 1.29/14 0.53/15   51/12 3,10 1.66/29 1.50/8 1.60/15 1.71/14
2020-06-24 Newcastle 1-1 Aston Villa 28/-13 2,30 1.27/30 1.50/8 1.60/15 0.93/15   35/-23 3,10 0.87/30 0.63/8 1.20/15 0.53/15
2020-06-27 Aston Villa 0-1 Wolves 36/-23 3,06 0.87/31 0.63/8 1.20/15 0.56/16   44/10 2,52 1.58/31 1.88/8 1.56/16 1.60/15
2020-07-05 Liverpool 2-0 Aston Villa 70/45 2,97 2.69/32 2.00/8 3.00/16 2.38/16   36/-24 3,00 0.84/32 0.25/8 1.13/16 0.56/16
2020-07-09 Aston Villa 0-3 Manchester Utd 36/-26 2,97 0.82/33 0.25/8 1.13/16 0.53/17   56/23 2,70 1.67/33 2.50/8 2.06/17 1.25/16
2020-07-12 Aston Villa 2-0 Crystal Palace 36/-29 2,97 0.79/34 0.25/8 1.06/17 0.53/17   30/-13 2,15 1.24/34 1.50/8 1.29/17 1.18/17
2020-07-16 Everton 1-1 Aston Villa 41/-11 2,66 1.29/35 1.13/8 1.76/17 0.83/18   38/-27 2,94 0.86/35 0.63/8 1.17/18 0.53/17
2020-07-21 Aston Villa 1-0 Arsenal 39/-27 2,92 0.86/36 0.75/8 1.17/18 0.56/18   53/8 2,72 1.47/36 1.63/8 1.83/18 1.11/18
2020-07-26 West Ham 1-1 Aston Villa 48/-13 2,95 1.03/37 1.38/8 1.17/18 0.89/19   40/-26 2,86 0.92/37 1.00/8 1.26/19 0.56/18