SELECT * FROM 1_Kampe WHERE LigaID = '52' AND (Home='FC Koln' OR Away='FC Koln') 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-28 Werder Bremen 4-2 FC Koln 1/-3 5,00 0.00/1 0.00/1 0.00/0 0.00/1   1/-2 4,00 0.00/1 0.00/1 0.00/1 0.00/0
2010-09-12 FC Koln 1-0 St. Pauli 3/-4 5,00 0.00/2 0.00/2 0.00/1 0.00/1   3/1 2,50 1.50/2 1.50/2 0.00/1 3.00/1
2010-09-18 Bayern Munich 0-0 FC Koln 2/-1 1,67 1.33/3 1.33/3 2.00/2 0.00/1   4/-3 3,67 1.00/3 1.00/3 1.50/2 0.00/1
2010-09-21 Mainz 2-0 FC Koln 10/6 3,50 3.00/4 3.00/4 3.00/2 3.00/2   4/-3 2,75 1.00/4 1.00/4 1.50/2 0.50/2
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 Freiburg 3-2 FC Koln 8/-1 2,83 1.50/6 1.50/6 1.00/3 2.00/3   5/-5 2,50 0.83/6 0.83/6 1.33/3 0.33/3
2010-10-15 FC Koln 1-2 Dortmund 7/-6 2,86 0.71/7 0.71/7 1.33/3 0.25/4   18/13 3,29 2.57/7 2.57/7 2.25/4 3.00/3
2010-10-23 Hannover 2-1 FC Koln 11/0 2,75 1.63/8 1.63/8 1.75/4 1.50/4   8/-7 2,88 0.63/8 0.63/8 1.00/4 0.25/4
2010-10-30 FC Koln 3-2 Hamburger SV 9/-8 2,89 0.56/9 0.63/8 1.00/4 0.20/5   13/2 2,67 1.67/9 1.50/8 1.60/5 1.75/4
2010-11-06 Nurnberg 3-1 FC Koln 14/0 2,80 1.50/10 1.75/8 2.25/4 1.00/6   12/-7 3,10 0.80/10 1.00/8 1.40/5 0.20/5
2010-11-13 FC Koln 0-4 B. Monchengladbach 13/-9 3,18 0.73/11 0.63/8 1.40/5 0.17/6   17/-16 4,55 0.64/11 0.38/8 0.50/6 0.80/5
2010-11-21 Stuttgart 0-1 FC Koln 25/3 3,92 0.92/12 1.00/8 1.50/6 0.33/6   13/-13 3,25 0.67/12 0.50/8 1.17/6 0.17/6
2010-11-28 FC Koln 1-1 Wolfsburg 14/-12 3,08 0.85/13 0.88/8 1.17/6 0.57/7   21/-1 3,31 1.15/13 1.13/8 1.67/6 0.71/7
2010-12-05 Bayer Leverkusen 3-2 FC Koln 26/7 3,21 1.86/14 1.88/8 1.29/7 2.43/7   15/-12 3,00 0.86/14 0.88/8 1.14/7 0.57/7
2010-12-11 FC Koln 1-0 Eintracht Frankfurt 17/-13 3,13 0.80/15 0.88/8 1.14/7 0.50/8   23/3 2,87 1.53/15 1.75/8 1.43/7 1.63/8
2010-12-18 Schalke 3-0 FC Koln 22/-2 2,88 1.19/16 1.75/8 1.38/8 1.00/8   18/-12 3,00 0.94/16 1.25/8 1.38/8 0.50/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 FC Koln 3-0 Werder Bremen 19/-15 2,94 0.89/18 1.00/8 1.38/8 0.50/10   25/-11 3,39 1.22/18 1.00/8 1.78/9 0.67/9
2011-01-29 St. Pauli 3-0 FC Koln 20/-14 2,84 1.00/19 0.75/8 0.90/10 1.11/9   22/-12 2,95 1.00/19 1.38/8 1.56/9 0.50/10
2011-02-05 FC Koln 3-2 Bayern Munich 22/-15 2,95 0.95/20 1.38/8 1.56/9 0.45/11   40/17 3,15 1.80/20 2.13/8 2.30/10 1.30/10
2011-02-13 FC Koln 4-2 Mainz 25/-14 3,05 1.05/21 1.38/8 1.70/10 0.45/11   32/10 2,57 1.76/21 1.25/8 1.45/11 2.10/10
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 FC Koln 1-0 Freiburg 30/-12 3,13 1.13/23 1.75/8 1.82/11 0.50/12   31/1 2,65 1.61/23 1.63/8 1.92/12 1.27/11
2011-03-04 Dortmund 1-0 FC Koln 52/38 2,75 2.42/24 1.88/8 2.18/11 2.62/13   31/-11 3,04 1.21/24 1.75/8 1.92/12 0.50/12
2011-03-11 FC Koln 4-0 Hannover 31/-12 2,96 1.16/25 1.75/8 1.92/12 0.46/13   37/5 2,76 1.88/25 2.00/8 2.15/13 1.58/12
2011-03-19 Hamburger SV 6-2 FC Koln 37/-5 3,04 1.42/26 1.25/8 1.67/12 1.21/14   35/-8 3,00 1.23/26 2.00/8 2.00/13 0.46/13
2011-04-03 FC Koln 1-0 Nurnberg 37/-12 3,19 1.19/27 1.63/8 2.00/13 0.43/14   42/6 2,89 1.56/27 2.38/8 1.93/14 1.15/13
2011-04-10 B. Monchengladbach 5-1 FC Koln 38/-24 3,57 0.82/28 0.88/8 0.64/14 1.00/14   38/-11 3,11 1.25/28 2.00/8 2.07/14 0.43/14
2011-04-16 FC Koln 1-3 Stuttgart 39/-15 3,21 1.21/29 1.63/8 2.07/14 0.40/15   49/-5 3,55 1.03/29 1.38/8 1.13/15 0.93/14
2011-04-24 Wolfsburg 4-1 FC Koln 34/-10 2,60 0.97/30 0.75/8 1.20/15 0.73/15   40/-17 3,23 1.17/30 1.25/8 1.93/15 0.40/15
2011-04-30 FC Koln 2-0 Bayer Leverkusen 41/-20 3,29 1.13/31 1.13/8 1.93/15 0.38/16   62/21 3,32 2.06/31 2.38/8 1.94/16 2.20/15
2011-05-07 Eintracht Frankfurt 0-2 FC Koln 30/-14 2,31 1.06/32 0.88/8 1.19/16 0.94/16   43/-18 3,25 1.19/32 1.13/8 2.00/16 0.38/16
2011-05-14 FC Koln 2-1 Schalke 45/-16 3,21 1.24/33 1.50/8 2.00/16 0.53/17   37/-5 2,39 1.21/33 1.25/8 1.41/17 1.00/16