SELECT * FROM 1_Kampe WHERE LigaID = '52' AND (Home='Hoffenheim' OR Away='Hoffenheim') 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-21 Hoffenheim 4-1 Werder Bremen 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-28 St. Pauli 0-1 Hoffenheim 3/2 4,00 3.00/1 3.00/1 0.00/0 3.00/1   4/3 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2010-09-10 Hoffenheim 2-0 Schalke 5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1   2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2010-09-18 Kaiserslautern 2-2 Hoffenheim 6/3 3,00 2.00/3 2.00/3 3.00/1 1.50/2   7/6 2,67 3.00/3 3.00/3 3.00/2 3.00/1
2010-09-21 Hoffenheim 1-2 Bayern Munich 9/6 3,00 2.50/4 2.50/4 3.00/2 2.00/2   2/-1 1,25 1.25/4 1.25/4 1.67/3 0.00/1
2010-09-24 FC Koln 1-1 Hoffenheim 4/-5 2,60 0.80/5 0.80/5 1.50/2 0.33/3   10/5 3,00 2.00/5 2.00/5 2.00/3 2.00/2
2010-10-02 Mainz 4-2 Hoffenheim 14/9 3,17 3.00/6 3.00/6 3.00/3 3.00/3   11/5 2,83 1.83/6 1.83/6 2.00/3 1.67/3
2010-10-17 Hoffenheim 3-2 B. Monchengladbach 13/3 3,29 1.57/7 1.57/7 2.00/3 1.25/4   11/-9 4,43 0.86/7 0.86/7 0.50/4 1.33/3
2010-10-24 Dortmund 1-1 Hoffenheim 20/14 3,25 2.63/8 2.63/8 2.25/4 3.00/4   16/4 3,50 1.75/8 1.75/8 2.25/4 1.25/4
2010-10-31 Hoffenheim 4-0 Hannover 17/4 3,33 1.67/9 1.50/8 2.25/4 1.20/5   13/1 2,78 1.78/9 1.63/8 2.00/5 1.50/4
2010-11-06 Hamburger SV 2-1 Hoffenheim 15/1 2,90 1.50/10 1.13/8 1.60/5 1.40/5   21/8 3,40 1.80/10 1.50/8 2.40/5 1.20/5
2010-11-14 Hoffenheim 0-1 Freiburg 22/7 3,36 1.64/11 1.13/8 2.40/5 1.00/6   17/-1 3,18 1.64/11 1.50/8 2.00/6 1.20/5
2010-11-20 Eintracht Frankfurt 0-4 Hoffenheim 20/9 2,58 1.67/12 2.13/8 1.40/5 1.86/7   22/6 3,17 1.50/12 1.00/8 2.00/6 1.00/6
2010-11-27 Hoffenheim 2-2 Bayer Leverkusen 26/10 3,23 1.62/13 1.38/8 2.00/6 1.29/7   24/7 3,15 1.92/13 2.13/8 1.29/7 2.67/6
2010-12-04 Stuttgart 1-1 Hoffenheim 27/0 3,86 0.79/14 1.00/8 1.29/7 0.29/7   28/10 3,29 1.57/14 1.38/8 1.86/7 1.29/7
2010-12-11 Hoffenheim 1-1 Nurnberg 29/10 3,20 1.53/15 1.50/8 1.86/7 1.25/8   18/-8 2,93 1.20/15 1.13/8 1.71/7 0.75/8
2010-12-18 Wolfsburg 2-2 Hoffenheim 22/-1 2,81 1.13/16 1.00/8 1.57/7 0.78/9   30/10 3,13 1.50/16 1.25/8 1.75/8 1.25/8
2011-01-15 Werder Bremen 2-1 Hoffenheim 23/-12 3,41 1.12/17 0.63/8 1.63/8 0.67/9   32/10 3,18 1.47/17 1.25/8 1.75/8 1.22/9
2011-01-23 Hoffenheim 2-2 St. Pauli 33/9 3,17 1.39/18 0.88/8 1.75/8 1.10/10   18/-14 2,78 1.00/18 0.63/8 0.90/10 1.13/8
2011-01-29 Schalke 0-1 Hoffenheim 26/1 2,68 1.32/19 2.00/8 1.40/10 1.22/9   35/9 3,21 1.37/19 1.00/8 1.67/9 1.10/10
2011-02-05 Hoffenheim 3-2 Kaiserslautern 36/10 3,10 1.45/20 1.38/8 1.67/9 1.27/11   29/-5 3,15 1.10/20 1.38/8 1.30/10 0.90/10
2011-02-12 Bayern Munich 4-0 Hoffenheim 42/16 3,24 1.71/21 2.00/8 2.30/10 1.18/11   39/11 3,19 1.52/21 1.38/8 1.80/10 1.27/11
2011-02-19 Hoffenheim 1-1 FC Koln 39/7 3,23 1.45/22 1.25/8 1.80/10 1.17/12   29/-12 3,18 1.14/22 1.63/8 1.82/11 0.45/11
2011-02-26 Hoffenheim 1-2 Mainz 40/7 3,17 1.43/23 1.25/8 1.73/11 1.17/12   35/6 2,78 1.61/23 0.88/8 1.33/12 1.91/11
2011-03-05 B. Monchengladbach 2-0 Hoffenheim 35/-24 3,92 0.79/24 1.13/8 0.50/12 1.08/12   41/6 3,17 1.38/24 1.13/8 1.58/12 1.17/12
2011-03-12 Hoffenheim 1-0 Dortmund 41/4 3,12 1.32/25 1.00/8 1.58/12 1.08/13   53/39 2,68 2.44/25 2.25/8 2.25/12 2.62/13
2011-03-19 Hannover 2-0 Hoffenheim 37/1 2,81 1.81/26 1.63/8 2.15/13 1.46/13   42/5 3,04 1.38/26 1.38/8 1.69/13 1.08/13
2011-04-02 Hoffenheim 0-0 Hamburger SV 42/3 3,00 1.33/27 1.25/8 1.69/13 1.00/14   43/-1 3,22 1.48/27 1.25/8 1.77/13 1.21/14
2011-04-09 Freiburg 3-2 Hoffenheim 35/-4 2,64 1.36/28 0.63/8 1.64/14 1.07/14   42/3 2,89 1.32/28 1.00/8 1.64/14 1.00/14
2011-04-16 Hoffenheim 1-0 Eintracht Frankfurt 44/2 2,97 1.28/29 0.63/8 1.64/14 0.93/15   29/-10 2,34 1.14/29 0.75/8 1.20/15 1.07/14
2011-04-23 Bayer Leverkusen 2-1 Hoffenheim 60/20 3,33 2.03/30 2.38/8 1.87/15 2.20/15   45/3 2,90 1.33/30 1.00/8 1.73/15 0.93/15
2011-04-30 Hoffenheim 1-2 Stuttgart 46/2 2,90 1.29/31 0.88/8 1.73/15 0.88/16   55/0 3,55 1.16/31 2.13/8 1.25/16 1.07/15
2011-05-07 Nurnberg 1-2 Hoffenheim 45/5 2,66 1.47/32 1.38/8 1.81/16 1.13/16   47/1 2,91 1.25/32 0.88/8 1.63/16 0.88/16
2011-05-14 Hoffenheim 1-3 Wolfsburg 49/2 2,91 1.30/33 1.25/8 1.63/16 1.00/17   40/-7 2,64 1.06/33 1.13/8 1.24/17 0.88/16