SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='West Ham' OR Away='West Ham') 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 West Ham 0-5 Manchester 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
2019-08-17 Brighton 1-1 West Ham 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   0/-5 5,00 0.00/1 0.00/1 0.00/1 0.00/0
2019-08-24 Watford 1-3 West Ham 0/-4 2,00 0.00/2 0.00/2 0.00/1 0.00/1   1/-5 3,50 0.50/2 0.50/2 0.00/1 1.00/1
2019-08-31 West Ham 2-0 Norwich 4/-3 3,67 1.33/3 1.33/3 0.00/1 2.00/2   6/-2 4,67 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 West Ham 2-0 Manchester Utd 6/-1 2,60 1.60/5 1.60/5 1.50/2 1.67/3   8/4 2,40 1.60/5 1.60/5 2.00/3 1.00/2
2019-09-28 Bournemouth 2-2 West Ham 11/1 3,50 1.67/6 1.67/6 1.33/3 2.00/3   8/1 2,50 1.83/6 1.83/6 2.00/3 1.67/3
2019-10-05 West Ham 1-2 Crystal Palace 10/1 2,71 1.71/7 1.71/7 2.00/3 1.50/4   6/-1 1,86 1.57/7 1.57/7 2.00/4 1.00/3
2019-10-19 Everton 2-0 West Ham 6/-7 2,38 0.88/8 0.88/8 1.50/4 0.25/4   11/0 2,75 1.50/8 1.50/8 1.50/4 1.50/4
2019-10-26 West Ham 1-1 Sheffield Utd 11/-2 2,67 1.33/9 1.50/8 1.50/4 1.20/5   8/1 1,67 1.33/9 1.38/8 1.20/5 1.50/4
2019-11-02 West Ham 2-3 Newcastle 12/-2 2,60 1.30/10 1.50/8 1.40/5 1.20/5   6/-9 2,10 0.90/10 1.13/8 1.20/5 0.60/5
2019-11-09 Burnley 3-0 West Ham 14/-4 2,91 1.09/11 1.00/8 1.80/5 0.50/6   14/-3 2,82 1.18/11 1.13/8 1.17/6 1.20/5
2019-11-23 West Ham 2-3 Tottenham 14/-6 2,83 1.08/12 0.75/8 1.17/6 1.00/6   18/1 2,92 1.17/12 1.13/8 1.83/6 0.50/6
2019-11-30 Chelsea 0-1 West Ham 28/9 3,62 2.00/13 2.25/8 1.83/6 2.14/7   16/-7 3,00 1.00/13 0.63/8 1.00/7 1.00/6
2019-12-04 Wolves 2-0 West Ham 19/2 2,57 1.43/14 2.00/8 1.43/7 1.43/7   17/-6 2,86 1.14/14 0.63/8 1.00/7 1.29/7
2019-12-09 West Ham 1-3 Arsenal 17/-8 2,80 1.07/15 0.50/8 1.00/7 1.13/8   21/-2 2,93 1.27/15 0.88/8 1.63/8 0.86/7
2019-12-14 Southampton 0-1 West Ham 18/-17 3,31 0.94/16 1.00/8 0.88/8 1.00/8   18/-10 2,88 1.00/16 0.50/8 0.88/8 1.13/8
2019-12-26 Crystal Palace 2-1 West Ham 15/-5 1,94 1.28/18 1.00/8 1.33/9 1.22/9   19/-9 2,76 1.12/17 0.88/8 0.88/8 1.33/9
2019-12-28 West Ham 1-2 Leicester 20/-10 2,78 1.06/18 0.75/8 0.88/8 1.20/10   41/23 3,11 2.05/19 2.00/8 2.30/10 1.78/9
2020-01-01 West Ham 4-0 Bournemouth 21/-11 2,79 1.00/19 0.75/8 0.78/9 1.20/10   20/-8 2,40 1.00/20 0.50/8 1.00/10 1.00/10
2020-01-10 Sheffield Utd 1-0 West Ham 23/2 2,10 1.38/21 1.38/8 1.40/10 1.36/11   25/-7 2,85 1.10/20 1.13/8 1.00/10 1.20/10
2020-01-18 West Ham 1-1 Everton 25/-8 2,76 1.05/21 1.13/8 1.00/10 1.09/11   25/-7 2,59 1.27/22 1.75/8 1.82/11 0.73/11
2020-01-22 Leicester 4-1 West Ham 48/25 3,09 1.96/23 1.25/8 2.09/11 1.83/12   26/-8 2,73 1.05/22 0.88/8 1.00/11 1.09/11
2020-01-29 West Ham 0-2 Liverpool 27/-11 2,83 1.00/23 0.88/8 1.00/11 1.00/12   54/39 3,00 2.91/23 3.00/8 3.00/12 2.82/11
2020-02-01 West Ham 3-3 Brighton 27/-13 2,79 0.96/24 0.88/8 0.92/12 1.00/12   27/-7 2,54 1.04/24 0.75/8 1.42/12 0.67/12
2020-02-19 Manchester City 2-0 West Ham 65/36 3,76 2.04/25 2.00/8 2.17/12 1.92/13   30/-13 2,92 0.96/25 0.63/8 0.92/13 1.00/12
2020-02-24 Liverpool 3-2 West Ham 61/46 2,92 2.92/26 3.00/8 3.00/13 2.85/13   30/-15 2,88 0.92/26 0.63/8 0.92/13 0.92/13
2020-02-29 West Ham 3-1 Southampton 32/-16 2,96 0.89/27 0.63/8 0.92/13 0.86/14   34/-14 3,04 1.26/27 1.63/8 1.00/14 1.54/13
2020-03-07 Arsenal 1-0 West Ham 39/3 2,78 1.37/27 1.63/8 1.64/14 1.08/13   35/-14 3,00 0.96/28 0.63/8 1.07/14 0.86/14
2020-06-20 West Ham 0-2 Wolves 35/-15 2,93 0.93/29 0.63/8 1.07/14 0.80/15   41/7 2,59 1.48/29 1.63/8 1.47/15 1.50/14
2020-06-23 Tottenham 2-0 West Ham 48/7 2,97 1.40/30 1.50/8 1.80/15 1.00/15   35/-17 2,90 0.90/30 0.50/8 1.00/15 0.80/15
2020-07-01 West Ham 3-2 Chelsea 35/-19 2,87 0.87/31 0.50/8 1.00/15 0.75/16   55/14 3,10 1.74/31 1.88/8 1.69/16 1.80/15
2020-07-05 Newcastle 2-2 West Ham 33/-10 2,38 1.31/32 1.50/8 1.56/16 1.06/16   38/-18 2,94 0.94/32 0.88/8 1.13/16 0.75/16
2020-07-08 West Ham 0-1 Burnley 40/-18 2,97 0.94/33 0.88/8 1.13/16 0.76/17   37/-9 2,52 1.39/33 1.88/8 1.59/17 1.19/16
2020-07-11 Norwich 0-4 West Ham 26/-37 2,62 0.62/34 0.38/8 0.88/17 0.35/17   40/-19 2,91 0.91/34 0.88/8 1.06/17 0.76/17
2020-07-17 West Ham 3-1 Watford 44/-15 2,94 0.97/35 1.25/8 1.06/17 0.89/18   33/-21 2,49 0.97/35 1.25/8 1.33/18 0.59/17
2020-07-22 Manchester Utd 1-1 West Ham 63/28 2,72 1.72/36 2.50/8 2.00/18 1.44/18   47/-13 2,97 1.03/36 1.25/8 1.17/18 0.89/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