SELECT * FROM 1_Kampe WHERE LigaID = '13' AND (Home='West Brom' OR Away='West Brom') 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 Chelsea 6-0 West Brom 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 Brom 1-0 Sunderland 0/-6 6,00 0.00/1 0.00/1 0.00/0 0.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2010-08-29 Liverpool 1-0 West Brom 1/-3 2,50 0.50/2 0.50/2 1.00/1 0.00/1   1/-5 3,50 1.50/2 1.50/2 3.00/1 0.00/1
2010-09-11 West Brom 1-1 Tottenham 1/-6 2,67 1.00/3 1.00/3 3.00/1 0.00/2   2/0 1,33 1.33/3 1.33/3 0.50/2 3.00/1
2010-09-18 West Brom 3-1 Birmingham 2/-6 2,50 1.00/4 1.00/4 2.00/2 0.00/2   6/1 2,75 1.50/4 1.50/4 2.00/2 1.00/2
2010-09-25 Arsenal 2-3 West Brom 14/10 3,60 2.20/5 2.20/5 3.00/2 1.67/3   5/-4 2,80 1.40/5 1.40/5 2.33/3 0.00/2
2010-10-02 West Brom 1-1 Bolton 8/-3 3,17 1.67/6 1.67/6 2.33/3 1.00/3   9/-1 3,17 1.17/6 1.17/6 1.00/3 1.33/3
2010-10-16 Manchester Utd 2-2 West Brom 16/7 3,57 1.86/7 1.86/7 3.00/3 1.00/4   9/-3 3,00 1.57/7 1.57/7 2.00/4 1.00/3
2010-10-23 West Brom 2-1 Fulham 11/-3 3,13 1.50/8 1.50/8 2.00/4 1.00/4   9/0 2,25 1.13/8 1.13/8 1.25/4 1.00/4
2010-11-01 Blackpool 2-1 West Brom 13/-7 3,67 1.11/9 0.88/8 0.33/3 1.50/6   13/-2 3,11 1.67/9 1.88/8 2.20/5 1.00/4
2010-11-07 West Brom 0-2 Manchester City 14/-3 3,10 1.50/10 1.50/8 2.20/5 0.80/5   13/3 2,30 1.70/10 1.63/8 2.00/5 1.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 Wigan 1-0 West Brom 9/-12 2,50 0.92/12 0.88/8 0.86/7 1.00/5   16/-5 3,08 1.33/12 1.50/8 1.83/6 0.83/6
2010-11-20 West Brom 0-3 Stoke 16/-6 2,92 1.23/13 1.13/8 1.83/6 0.71/7   15/-3 2,54 1.23/13 1.50/8 1.86/7 0.50/6
2010-11-27 Everton 1-4 West Brom 16/1 2,21 1.14/14 1.63/8 1.29/7 1.00/7   16/-9 2,93 1.14/14 0.75/8 1.57/7 0.71/7
2010-12-05 West Brom 3-1 Newcastle 20/-6 3,07 1.27/15 1.00/8 1.57/7 1.00/8   23/1 3,00 1.27/15 1.50/8 1.13/8 1.43/7
2010-12-11 Aston Villa 2-1 West Brom 17/-10 2,75 1.06/16 0.75/8 1.63/8 0.50/8   23/-4 3,13 1.38/16 1.25/8 1.75/8 1.00/8
2010-12-26 Bolton 2-0 West Brom 30/5 3,06 1.44/18 1.75/8 1.78/9 1.11/9   24/-5 3,12 1.29/17 0.88/8 1.75/8 0.89/9
2010-12-28 West Brom 1-3 Blackburn 24/-7 3,06 1.22/18 0.88/8 1.75/8 0.80/10   23/-7 2,79 1.16/19 1.25/8 1.50/10 0.78/9
2011-01-01 West Brom 1-2 Manchester Utd 25/-9 3,11 1.16/19 0.88/8 1.56/9 0.80/10   39/22 3,11 2.11/18 2.25/8 2.80/10 1.25/8
2011-01-04 Fulham 3-0 West Brom 19/-5 2,15 0.95/20 0.75/8 1.10/10 0.80/10   26/-10 3,10 1.10/20 0.75/8 1.40/10 0.80/10
2011-01-15 West Brom 3-2 Blackpool 26/-13 3,10 1.05/21 0.75/8 1.40/10 0.73/11   29/-4 3,10 1.40/20 1.75/8 1.38/8 1.42/12
2011-01-23 Blackburn 2-0 West Brom 29/-8 2,87 1.22/23 1.25/8 1.64/11 0.83/12   29/-12 3,18 1.14/22 1.13/8 1.55/11 0.73/11
2011-02-01 West Brom 2-2 Wigan 29/-14 3,13 1.09/23 0.75/8 1.55/11 0.67/12   20/-19 2,46 0.92/24 0.88/8 0.92/13 0.91/11
2011-02-05 Manchester City 3-0 West Brom 39/17 2,44 1.84/25 1.75/8 2.00/12 1.69/13   31/-14 3,17 1.08/24 0.50/8 1.50/12 0.67/12
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-20 West Brom 1-1 Wolves 34/-17 3,27 1.04/26 0.63/8 1.46/13 0.62/13   26/-19 2,73 0.92/26 1.13/8 1.54/13 0.31/13
2011-02-28 Stoke 1-1 West Brom 31/-3 2,41 1.22/27 1.13/8 1.77/13 0.71/14   35/-17 3,22 1.04/27 0.75/8 1.43/14 0.62/13
2011-03-05 Birmingham 1-3 West Brom 25/-10 2,31 1.15/26 1.38/8 1.36/14 0.92/12   36/-17 3,18 1.04/28 0.88/8 1.43/14 0.64/14
2011-03-19 West Brom 2-2 Arsenal 39/-15 3,21 1.10/29 1.25/8 1.43/14 0.80/15   57/30 3,00 2.04/28 2.25/8 2.13/15 1.92/13
2011-04-02 West Brom 2-1 Liverpool 41/-15 3,23 1.10/30 1.00/8 1.40/15 0.80/15   41/5 2,57 1.50/30 2.38/8 2.07/15 0.93/15
2011-04-09 Sunderland 2-3 West Brom 33/-9 2,42 1.23/31 0.50/8 1.53/15 0.94/16   43/-14 3,23 1.16/31 1.38/8 1.50/16 0.80/15
2011-04-16 West Brom 1-3 Chelsea 46/-13 3,28 1.22/32 1.63/8 1.50/16 0.94/16   55/30 2,58 1.87/31 2.13/8 2.33/15 1.44/16
2011-04-23 Tottenham 2-2 West Brom 47/8 2,69 1.69/32 1.63/8 1.94/16 1.44/16   47/-15 3,30 1.18/33 1.63/8 1.41/17 0.94/16
2011-04-30 West Brom 2-1 Aston Villa 49/-15 3,32 1.18/34 1.63/8 1.41/17 0.94/17   43/-12 2,88 1.21/34 1.50/8 1.59/17 0.82/17
2011-05-08 Wolves 3-1 West Brom 38/-23 2,83 0.97/35 1.13/8 1.47/17 0.50/18   51/-14 3,31 1.23/35 1.88/8 1.50/18 0.94/17
2011-05-14 West Brom 1-0 Everton 52/-16 3,33 1.19/36 1.75/8 1.50/18 0.89/18   50/6 2,61 1.42/36 1.88/8 1.72/18 1.11/18
2011-05-22 Newcastle 3-3 West Brom 53/-1 2,89 1.22/37 1.13/8 1.39/18 1.05/19   53/-15 3,27 1.24/37 1.75/8 1.58/19 0.89/18