SELECT * FROM 1_Kampe WHERE LigaID = '52' AND (Home='Kaiserslautern' OR Away='Kaiserslautern') 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 FC Koln 1-3 Kaiserslautern 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-27 Kaiserslautern 2-0 Bayern Munich 3/2 4,00 3.00/1 3.00/1 0.00/0 3.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2010-09-12 Mainz 2-1 Kaiserslautern 6/3 4,50 3.00/2 3.00/2 3.00/1 3.00/1   5/4 3,00 3.00/2 3.00/2 3.00/1 3.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-22 Dortmund 5-0 Kaiserslautern 8/4 3,00 2.25/4 2.25/4 1.50/2 3.00/2   8/3 3,25 1.75/4 1.75/4 2.00/2 1.50/2
2010-09-26 Kaiserslautern 0-1 Hannover 8/-2 3,60 1.40/5 1.40/5 2.00/2 1.00/3   10/3 3,40 2.00/5 2.00/5 2.33/3 1.50/2
2010-10-02 Hamburger SV 2-1 Kaiserslautern 10/0 3,33 1.33/6 1.33/6 1.33/3 1.33/3   8/-3 3,17 1.17/6 1.17/6 1.33/3 1.00/3
2010-10-17 Kaiserslautern 0-3 Eintracht Frankfurt 9/-4 3,14 1.00/7 1.00/7 1.33/3 0.75/4   11/2 2,86 1.29/7 1.29/7 1.00/3 1.50/4
2010-10-23 Freiburg 2-1 Kaiserslautern 12/-1 3,13 1.50/8 1.50/8 1.50/4 1.50/4   9/-7 3,13 0.88/8 0.88/8 1.00/4 0.75/4
2010-10-30 Kaiserslautern 3-0 B. Monchengladbach 10/-8 3,11 0.78/9 0.50/8 1.00/4 0.60/5   14/-13 4,56 0.67/9 0.63/8 0.40/5 1.00/4
2010-11-07 Bayer Leverkusen 3-1 Kaiserslautern 19/4 3,40 1.80/10 1.88/8 1.00/5 2.60/5   13/-5 3,10 1.00/10 0.50/8 1.40/5 0.60/5
2010-11-13 Kaiserslautern 3-3 Stuttgart 14/-7 3,18 0.91/11 0.50/8 1.40/5 0.50/6   22/3 3,73 0.91/11 1.25/8 1.50/6 0.20/5
2010-11-20 Nurnberg 1-3 Kaiserslautern 17/-1 2,92 1.50/12 1.88/8 2.40/5 0.86/7   17/-7 3,42 0.92/12 0.50/8 1.33/6 0.50/6
2010-11-27 Kaiserslautern 5-0 Schalke 20/-5 3,46 1.08/13 0.88/8 1.33/6 0.86/7   19/0 2,92 1.00/13 1.25/8 1.14/7 0.83/6
2010-12-03 St. Pauli 1-0 Kaiserslautern 13/-10 2,57 1.00/14 0.88/8 0.71/7 1.29/7   25/0 3,57 1.21/14 1.25/8 1.57/7 0.86/7
2010-12-11 Kaiserslautern 0-0 Wolfsburg 25/-1 3,40 1.13/15 1.25/8 1.57/7 0.75/8   22/-1 3,00 1.13/15 0.88/8 1.57/7 0.75/8
2010-12-18 Werder Bremen 1-2 Kaiserslautern 22/-11 3,44 1.19/16 1.00/8 1.86/7 0.67/9   25/-1 3,19 1.13/16 1.38/8 1.50/8 0.75/8
2011-01-16 Kaiserslautern 1-1 FC Koln 27/0 3,18 1.24/17 1.75/8 1.50/8 1.00/9   18/-15 3,00 0.88/17 1.25/8 1.38/8 0.44/9
2011-01-22 Bayern Munich 5-1 Kaiserslautern 32/11 2,94 1.67/18 1.88/8 2.22/9 1.11/9   28/0 3,11 1.22/18 1.50/8 1.44/9 1.00/9
2011-01-29 Kaiserslautern 0-1 Mainz 29/-4 3,26 1.16/19 1.50/8 1.44/9 0.90/10   30/9 2,68 1.74/19 1.13/8 1.50/10 2.00/9
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 Kaiserslautern 1-1 Dortmund 31/-6 3,24 1.05/21 1.00/8 1.30/10 0.82/11   46/34 2,76 2.43/21 2.13/8 2.10/10 2.73/11
2011-02-19 Hannover 3-0 Kaiserslautern 30/-1 2,77 1.73/22 1.63/8 2.00/11 1.45/11   32/-6 3,18 1.05/22 0.75/8 1.27/11 0.82/11
2011-02-26 Kaiserslautern 1-1 Hamburger SV 32/-9 3,17 1.00/23 0.75/8 1.27/11 0.75/12   34/3 2,83 1.57/23 1.88/8 1.82/11 1.33/12
2011-03-05 Eintracht Frankfurt 0-0 Kaiserslautern 24/-10 2,42 1.13/24 0.50/8 1.08/12 1.17/12   33/-9 3,13 1.00/24 0.75/8 1.25/12 0.75/12
2011-03-12 Kaiserslautern 2-1 Freiburg 33/-9 3,00 1.00/25 0.50/8 1.25/12 0.77/13   32/-2 2,64 1.48/25 1.13/8 1.77/13 1.17/12
2011-03-18 B. Monchengladbach 0-1 Kaiserslautern 38/-22 3,77 0.88/26 1.25/8 0.69/13 1.08/13   35/-8 3,00 1.08/26 0.75/8 1.38/13 0.77/13
2011-04-02 Kaiserslautern 0-1 Bayer Leverkusen 36/-7 2,93 1.15/27 1.13/8 1.38/13 0.93/14   56/22 3,33 2.04/27 2.38/8 1.79/14 2.31/13
2011-04-09 Stuttgart 2-4 Kaiserslautern 47/-3 3,46 1.07/28 1.75/8 1.21/14 0.93/14   36/-8 2,86 1.11/28 1.13/8 1.29/14 0.93/14
2011-04-16 Kaiserslautern 0-2 Nurnberg 40/-6 2,97 1.17/29 1.50/8 1.29/14 1.07/15   43/5 2,79 1.48/29 1.75/8 1.87/15 1.07/14
2011-04-23 Schalke 0-1 Kaiserslautern 35/1 2,30 1.33/30 1.38/8 1.60/15 1.07/15   40/-8 2,93 1.13/30 1.38/8 1.20/15 1.07/15
2011-04-29 Kaiserslautern 2-0 St. Pauli 41/-7 2,87 1.19/31 1.75/8 1.20/15 1.19/16   33/-23 2,87 0.94/31 0.13/8 0.94/16 0.93/15
2011-05-07 Wolfsburg 1-2 Kaiserslautern 39/-6 2,63 1.09/32 1.13/8 1.31/16 0.88/16   43/-5 2,84 1.25/32 2.00/8 1.31/16 1.19/16
2011-05-14 Kaiserslautern 3-2 Werder Bremen 45/-4 2,85 1.30/33 2.25/8 1.31/16 1.29/17   45/-13 3,12 1.24/33 1.63/8 1.41/17 1.06/16