SELECT * FROM 1_Kampe WHERE LigaID = '13' 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
2010-08-14 Aston Villa 3-0 West Ham 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
2010-08-21 West Ham 1-3 Bolton 0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2010-08-28 Manchester Utd 3-0 West Ham 5/3 3,50 2.00/2 2.00/2 3.00/1 1.00/1   1/-5 3,50 0.00/2 0.00/2 0.00/1 0.00/1
2010-09-11 West Ham 1-3 Chelsea 1/-8 3,33 0.00/3 0.00/3 0.00/1 0.00/2   14/14 4,67 3.00/3 3.00/3 3.00/2 3.00/1
2010-09-18 Stoke 1-1 West Ham 4/-3 2,75 0.75/4 0.75/4 1.50/2 0.00/2   2/-10 3,50 0.00/4 0.00/4 0.00/2 0.00/2
2010-09-25 West Ham 1-0 Tottenham 3/-10 3,20 0.20/5 0.20/5 0.00/2 0.33/3   6/2 2,00 1.60/5 1.60/5 1.33/3 2.00/2
2010-10-02 West Ham 1-1 Fulham 4/-9 2,83 0.67/6 0.67/6 1.00/3 0.33/3   7/1 2,17 1.33/6 1.33/6 1.67/3 1.00/3
2010-10-16 Wolves 1-1 West Ham 7/-5 2,71 0.71/7 0.71/7 1.33/3 0.25/4   5/-9 2,71 0.71/7 0.71/7 1.00/4 0.33/3
2010-10-23 West Ham 1-2 Newcastle 6/-9 2,63 0.75/8 0.75/8 1.00/4 0.50/4   12/0 3,00 1.00/8 1.00/8 1.00/4 1.00/4
2010-10-30 Arsenal 1-0 West Ham 21/11 3,44 1.89/9 2.00/8 2.25/4 1.60/5   7/-10 2,67 0.67/9 0.75/8 0.80/5 0.50/4
2010-11-06 Birmingham 2-2 West Ham 10/-2 2,20 1.10/10 0.88/8 1.60/5 0.60/5   7/-11 2,50 0.60/10 0.75/8 0.80/5 0.40/5
2010-11-10 West Ham 2-2 West Brom 9/-11 2,64 0.64/11 0.88/8 0.80/5 0.50/6   14/-5 3,00 1.36/11 1.50/8 1.83/6 0.80/5
2010-11-13 West Ham 0-0 Blackpool 11/-11 2,75 0.67/12 1.00/8 0.83/6 0.50/6   19/-7 3,75 1.17/12 0.88/8 1.00/5 1.29/7
2010-11-20 Liverpool 3-0 West Ham 13/-4 2,31 1.23/13 1.38/8 1.83/6 0.71/7   11/-11 2,54 0.69/13 1.00/8 0.86/7 0.50/6
2010-11-27 West Ham 3-1 Wigan 11/-14 2,57 0.64/14 0.63/8 0.86/7 0.43/7   10/-13 2,36 1.00/14 1.13/8 1.13/8 0.83/6
2010-12-05 Sunderland 1-0 West Ham 19/1 2,47 1.33/15 1.50/8 1.86/7 0.88/8   14/-12 2,67 0.80/15 0.88/8 1.13/8 0.43/7
2010-12-11 West Ham 1-3 Manchester City 14/-13 2,56 0.75/16 0.75/8 1.13/8 0.38/8   21/9 2,06 1.81/16 1.50/8 1.88/8 1.75/8
2010-12-18 Blackburn 1-1 West Ham 22/-5 2,88 1.24/17 1.50/8 1.75/8 0.78/9   15/-15 2,65 0.71/17 0.75/8 1.00/9 0.38/8
2010-12-26 Fulham 1-3 West Ham 16/-4 2,12 0.94/17 0.88/8 1.22/9 0.63/8   16/-15 2,61 0.72/18 0.88/8 1.00/9 0.44/9
2010-12-28 West Ham 1-1 Everton 19/-13 2,68 0.84/19 1.13/8 1.00/9 0.70/10   20/-1 2,28 1.17/18 1.00/8 1.11/9 1.22/9
2011-01-01 West Ham 2-0 Wolves 20/-13 2,65 0.85/20 1.13/8 1.00/10 0.70/10   20/-12 2,74 0.95/19 1.13/8 1.40/10 0.44/9
2011-01-05 Newcastle 5-0 West Ham 29/-2 3,00 1.25/20 1.00/8 1.20/10 1.30/10   22/-11 2,62 0.95/21 1.38/8 1.18/11 0.70/10
2011-01-15 West Ham 0-3 Arsenal 22/-16 2,73 0.91/22 1.38/8 1.18/11 0.64/11   42/20 3,05 1.90/21 1.75/8 1.90/10 1.91/11
2011-01-22 Everton 2-2 West Ham 25/-2 2,36 1.18/22 1.25/8 1.30/10 1.08/12   22/-19 2,74 0.87/23 1.00/8 1.08/12 0.64/11
2011-02-02 Blackpool 1-3 West Ham 34/-7 3,26 1.22/23 1.13/8 1.10/10 1.31/13   24/-19 2,79 0.88/24 1.13/8 1.08/12 0.67/12
2011-02-06 West Ham 0-1 Birmingham 27/-17 2,84 0.96/25 1.50/8 1.08/12 0.85/13   23/-10 2,43 1.04/23 0.88/8 1.33/12 0.73/11
2011-02-12 West Brom 3-3 West Ham 31/-17 3,16 1.04/25 0.50/8 1.50/12 0.62/13   27/-18 2,77 0.92/26 1.38/8 1.00/13 0.85/13
2011-02-27 West Ham 3-1 Liverpool 30/-18 2,89 0.93/27 1.13/8 1.00/13 0.86/14   35/3 2,48 1.44/27 1.75/8 2.00/14 0.85/13
2011-03-05 West Ham 3-0 Stoke 33/-16 2,93 1.00/28 1.38/8 1.14/14 0.86/14   32/-3 2,39 1.21/28 0.88/8 1.71/14 0.71/14
2011-03-19 Tottenham 0-0 West Ham 41/7 2,68 1.71/28 1.50/8 2.00/13 1.47/15   36/-13 2,93 1.07/29 1.38/8 1.27/15 0.86/14
2011-04-02 West Ham 2-4 Manchester Utd 36/-13 2,83 1.07/30 1.50/8 1.27/15 0.87/15   64/34 3,13 2.10/30 1.88/8 2.87/15 1.33/15
2011-04-09 Bolton 3-0 West Ham 43/0 2,77 1.29/31 1.25/8 1.93/15 0.69/16   38/-15 2,94 1.03/31 1.50/8 1.19/16 0.87/15
2011-04-16 West Ham 1-2 Aston Villa 38/-18 2,94 1.00/32 1.38/8 1.19/16 0.81/16   40/-13 2,91 1.16/32 1.13/8 1.63/16 0.69/16
2011-04-23 Chelsea 3-0 West Ham 61/34 2,67 1.94/33 2.50/8 2.38/16 1.53/17   39/-19 2,94 0.97/33 1.00/8 1.12/17 0.81/16
2011-05-01 Manchester City 2-1 West Ham 51/21 2,45 1.79/33 1.63/8 2.13/16 1.47/17   39/-22 2,94 0.94/34 1.00/8 1.12/17 0.76/17
2011-05-07 West Ham 1-1 Blackburn 40/-23 2,94 0.91/35 0.88/8 1.12/17 0.72/18   41/-14 2,74 1.09/35 0.75/8 1.50/18 0.65/17
2011-05-15 Wigan 3-2 West Ham 36/-23 2,64 1.00/36 1.13/8 1.11/18 0.89/18   41/-23 2,92 0.92/36 0.63/8 1.11/18 0.72/18
2011-05-22 West Ham 0-3 Sunderland 43/-24 2,97 0.89/37 0.25/8 1.11/18 0.68/19   42/-14 2,65 1.19/37 0.75/8 1.37/19 1.00/18