SELECT * FROM 1_Kampe WHERE LigaID = '13' AND (Home='Birmingham' OR Away='Birmingham') 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 Sunderland 2-2 Birmingham 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 Birmingham 2-1 Blackburn 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2010-08-29 Bolton 2-2 Birmingham 3/2 2,00 2.00/2 2.00/2 1.00/1 3.00/1   4/1 3,50 2.00/2 2.00/2 3.00/1 1.00/1
2010-09-12 Birmingham 0-0 Liverpool 6/1 3,67 1.67/3 1.67/3 3.00/1 1.00/2   2/-2 2,00 1.33/3 1.33/3 2.00/2 0.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 Birmingham 0-0 Wigan 7/-1 3,00 1.20/5 1.20/5 2.00/2 0.67/3   2/-11 3,00 0.80/5 0.80/5 0.25/4 3.00/1
2010-10-02 Birmingham 0-2 Everton 7/-1 2,50 1.17/6 1.17/6 1.67/3 0.67/3   4/-3 1,83 0.50/6 0.50/6 0.67/3 0.33/3
2010-10-16 Arsenal 2-1 Birmingham 16/7 3,57 1.57/7 1.57/7 2.00/3 1.25/4   7/-3 2,43 1.00/7 1.00/7 1.25/4 0.67/3
2010-10-23 Birmingham 2-0 Blackpool 8/-4 2,50 0.88/8 0.88/8 1.25/4 0.50/4   13/-5 3,88 1.25/8 1.25/8 0.33/3 1.80/5
2010-10-31 Aston Villa 0-0 Birmingham 9/-4 2,44 1.22/9 1.00/8 2.00/4 0.60/5   10/-2 2,44 1.11/9 1.13/8 1.60/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-09 Stoke 3-2 Birmingham 10/-6 2,36 0.91/11 1.25/8 1.40/5 0.50/6   12/-2 2,36 1.09/11 0.88/8 1.50/6 0.60/5
2010-11-13 Manchester City 0-0 Birmingham 15/5 2,08 1.75/12 2.00/8 1.83/6 1.67/6   14/-3 2,58 1.00/12 0.75/8 1.50/6 0.50/6
2010-11-20 Birmingham 1-0 Chelsea 14/-3 2,38 1.00/13 0.88/8 1.50/6 0.57/7   28/20 2,77 2.15/13 1.63/8 2.57/7 1.67/6
2010-11-27 Fulham 1-1 Birmingham 14/-3 2,21 1.00/14 0.75/8 1.29/7 0.71/7   15/-2 2,29 1.14/14 1.13/8 1.71/7 0.57/7
2010-12-04 Birmingham 1-1 Tottenham 16/-2 2,27 1.13/15 1.25/8 1.71/7 0.63/8   23/3 2,87 1.67/15 1.75/8 1.88/8 1.43/7
2010-12-12 Wolves 1-0 Birmingham 17/-13 2,94 0.75/16 0.75/8 1.38/8 0.13/8   17/-2 2,25 1.13/16 1.38/8 1.63/8 0.63/8
2010-12-28 Birmingham 1-1 Manchester Utd 17/-3 2,18 1.06/17 1.00/8 1.63/8 0.56/9   38/22 3,18 2.18/17 2.50/8 2.80/10 1.29/7
2011-01-01 Birmingham 0-3 Arsenal 18/-3 2,17 1.06/18 1.00/8 1.56/9 0.56/9   39/17 3,21 1.89/19 2.00/8 2.00/9 1.80/10
2011-01-04 Blackpool 1-2 Birmingham 26/-4 3,11 1.39/18 1.50/8 1.33/6 1.42/12   18/-6 2,21 1.00/19 0.88/8 1.40/10 0.56/9
2011-01-16 Birmingham 1-1 Aston Villa 20/-5 2,25 1.10/20 1.25/8 1.40/10 0.80/10   23/-15 2,90 1.00/21 0.50/8 1.45/11 0.50/10
2011-01-22 Manchester Utd 5-0 Birmingham 43/24 2,95 2.14/21 2.50/8 2.82/11 1.40/10   21/-5 2,24 1.10/21 1.25/8 1.36/11 0.80/10
2011-02-02 Birmingham 2-2 Manchester City 21/-10 2,36 1.05/22 0.88/8 1.36/11 0.73/11   37/17 2,38 1.88/24 2.00/8 2.00/12 1.75/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 Birmingham 1-0 Stoke 24/-9 2,38 1.13/24 1.13/8 1.33/12 0.92/12   31/-1 2,52 1.32/25 1.50/8 1.77/13 0.83/12
2011-02-15 Birmingham 0-2 Newcastle 25/-8 2,32 1.20/25 1.50/8 1.46/13 0.92/12   40/2 3,00 1.23/26 1.25/8 1.31/13 1.15/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-09 Everton 1-1 Birmingham 37/0 2,64 1.29/28 1.75/8 1.54/13 1.07/15   26/-12 2,37 1.11/27 1.38/8 1.27/15 0.92/12
2011-03-19 Wigan 2-1 Birmingham 27/-23 2,66 0.93/29 0.75/8 1.00/15 0.86/14   27/-12 2,36 1.11/28 1.13/8 1.27/15 0.92/13
2011-04-02 Birmingham 2-1 Bolton 28/-13 2,38 1.07/29 1.00/8 1.27/15 0.86/14   42/1 2,77 1.33/30 1.25/8 1.93/15 0.73/15
2011-04-09 Blackburn 1-1 Birmingham 39/-12 2,90 1.10/31 0.75/8 1.53/15 0.69/16   30/-12 2,40 1.13/30 1.38/8 1.38/16 0.86/14
2011-04-16 Birmingham 2-0 Sunderland 31/-12 2,39 1.13/31 1.38/8 1.38/16 0.87/15   35/-10 2,50 1.19/32 0.13/8 1.44/16 0.94/16
2011-04-20 Chelsea 3-1 Birmingham 58/32 2,63 1.91/32 2.13/8 2.33/15 1.53/17   33/-10 2,38 1.19/32 1.38/8 1.47/17 0.87/15
2011-04-23 Liverpool 5-0 Birmingham 46/7 2,58 1.48/33 1.75/8 2.13/16 0.88/17   34/-12 2,42 1.15/33 1.00/8 1.47/17 0.81/16
2011-05-01 Birmingham 1-1 Wolves 34/-17 2,50 1.12/34 1.00/8 1.47/17 0.76/17   37/-23 2,85 0.97/34 1.13/8 1.47/17 0.47/17
2011-05-07 Newcastle 2-1 Birmingham 49/-2 2,86 1.17/35 0.75/8 1.29/17 1.06/18   35/-17 2,49 1.11/35 1.13/8 1.44/18 0.76/17
2011-05-15 Birmingham 0-2 Fulham 36/-18 2,50 1.08/36 1.00/8 1.44/18 0.72/18   45/4 2,39 1.25/36 1.63/8 1.67/18 0.83/18
2011-05-22 Tottenham 2-1 Birmingham 53/8 2,65 1.59/37 1.25/8 1.83/18 1.37/19   36/-20 2,49 1.05/37 1.00/8 1.37/19 0.72/18