SELECT * FROM 1_Kampe WHERE LigaID = '54' 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
2018-08-04 Bochum 0-2 FC Koln 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
2018-08-13 FC Koln 1-1 Union Berlin 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-25 FC Koln 3-1 Aue 3/2 2,00 2.00/2 2.00/2 1.00/1 3.00/1   0/-1 0,50 0.50/2 0.50/2 1.00/1 0.00/1
2018-09-02 St. Pauli 3-5 FC Koln 5/0 3,33 2.00/3 2.00/3 3.00/1 1.50/2   6/4 2,67 2.33/3 2.33/3 2.00/2 3.00/1
2018-09-16 FC Koln 3-5 Paderborn 11/6 4,00 2.50/4 2.50/4 2.00/2 3.00/2   6/1 2,75 1.25/4 1.25/4 2.00/2 0.50/2
2018-09-21 Sandhausen 0-2 FC Koln 2/-6 2,00 0.40/5 0.40/5 0.50/2 0.33/3   14/4 4,80 2.00/5 2.00/5 1.33/3 3.00/2
2018-09-25 FC Koln 2-1 Ingolstadt 16/6 4,33 2.17/6 2.17/6 1.33/3 3.00/3   6/-7 3,17 0.83/6 0.83/6 1.33/3 0.33/3
2018-09-28 Arminia Bielefeld 1-3 FC Koln 11/1 3,00 1.71/7 1.71/7 2.33/3 1.25/4   18/7 4,14 2.29/7 2.29/7 1.75/4 3.00/3
2018-10-08 FC Koln 1-2 Duisburg 21/9 4,13 2.38/8 2.38/8 1.75/4 3.00/4   7/-10 3,00 0.25/8 0.25/8 0.00/4 0.50/4
2018-10-20 Holstein Kiel 1-1 FC Koln 14/0 3,11 1.33/9 1.13/8 2.00/4 0.80/5   22/8 4,00 2.11/9 2.00/8 1.40/5 3.00/4
2018-10-27 FC Koln 1-1 Heidenheim 23/8 3,80 2.00/10 2.00/8 1.40/5 2.60/5   17/5 2,90 1.50/10 1.63/8 2.00/5 1.00/5
2018-11-05 Hamburger SV 1-0 FC Koln 13/2 2,18 1.91/11 1.88/8 1.33/6 2.60/5   24/8 3,64 1.91/11 1.75/8 1.33/6 2.60/5
2018-11-10 FC Koln 8-1 SG Dynamo Dresden 24/7 3,42 1.75/12 1.38/8 1.33/6 2.17/6   16/4 2,33 1.50/12 1.50/8 1.43/7 1.60/5
2018-11-24 Darmstadt 0-3 FC Koln 17/-1 2,69 1.31/13 0.88/8 1.86/7 0.67/6   32/14 3,85 1.85/13 1.75/8 1.57/7 2.17/6
2018-12-01 FC Koln 4-0 Greuther Furth 35/17 3,79 1.93/14 1.75/8 1.57/7 2.29/7   21/1 2,93 1.64/14 1.50/8 1.86/7 1.43/7
2018-12-07 Regensburg 1-3 FC Koln 26/4 3,20 1.47/15 1.50/8 1.43/7 1.50/8   39/21 3,80 2.00/15 1.75/8 1.75/8 2.29/7
2018-12-17 FC Koln 3-0 Magdeburg 42/23 3,81 2.06/16 1.75/8 1.75/8 2.38/8   19/-9 2,94 0.69/16 0.38/8 0.67/9 0.71/7
2018-12-21 FC Koln 2-3 Bochum 45/26 3,76 2.12/17 2.13/8 1.89/9 2.38/8   25/4 2,71 1.41/17 1.25/8 1.78/9 1.00/8
2019-01-31 Union Berlin 2-0 FC Koln 27/12 2,33 1.72/18 1.63/8 2.33/9 1.11/9   47/25 3,83 2.00/18 2.00/8 1.70/10 2.38/8
2019-02-08 FC Koln 4-1 St. Pauli 47/23 3,74 1.89/19 1.88/8 1.70/10 2.11/9   34/8 3,00 1.85/20 1.88/8 2.00/10 1.70/10
2019-02-15 Paderborn 3-2 FC Koln 50/17 3,95 1.62/21 2.00/8 1.91/11 1.30/10   51/26 3,80 1.95/20 2.25/8 1.82/11 2.11/9
2019-02-23 FC Koln 3-1 Sandhausen 53/25 3,86 1.86/21 1.88/8 1.82/11 1.90/10   23/-9 2,50 0.77/22 0.88/8 1.00/11 0.55/11
2019-02-27 Aue 0-1 FC Koln 27/-1 2,50 1.18/22 1.50/8 1.45/11 0.91/11   56/27 3,86 1.91/22 1.88/8 1.92/12 1.90/10
2019-03-03 Ingolstadt 1-2 FC Koln 23/-15 2,65 0.83/23 1.38/8 0.83/12 0.82/11   57/28 3,74 1.96/23 1.88/8 1.92/12 2.00/11
2019-03-09 FC Koln 5-1 Arminia Bielefeld 59/29 3,71 2.00/24 1.88/8 1.92/12 2.08/12   34/-1 2,88 1.29/24 2.00/8 1.17/12 1.42/12
2019-03-31 FC Koln 4-0 Holstein Kiel 64/33 3,80 2.04/25 1.88/8 2.00/13 2.08/12   51/14 3,38 1.62/26 1.50/8 1.77/13 1.46/13
2019-04-07 Heidenheim 0-2 FC Koln 40/8 2,67 1.59/27 1.50/8 1.85/13 1.36/14   68/37 3,81 2.08/26 2.25/8 2.07/14 2.08/12
2019-04-10 Duisburg 4-4 FC Koln 26/-20 2,67 0.81/27 1.13/8 0.69/13 0.93/14   70/39 3,74 2.11/27 2.63/8 2.07/14 2.15/13
2019-04-15 FC Koln 1-1 Hamburger SV 74/39 3,89 2.07/28 2.38/8 2.07/14 2.07/14   39/8 2,50 1.82/28 1.38/8 1.71/14 1.93/14
2019-04-21 SG Dynamo Dresden 3-0 FC Koln 33/-9 2,59 1.14/29 1.00/8 1.21/14 1.07/15   75/39 3,83 2.03/29 2.50/8 2.00/15 2.07/14
2019-04-26 FC Koln 1-2 Darmstadt 75/36 3,80 1.97/30 2.13/8 2.00/15 1.93/15   40/-8 2,93 1.23/30 1.75/8 1.67/15 0.80/15
2019-05-06 Greuther Furth 0-4 FC Koln 34/-16 2,71 1.23/31 1.13/8 1.53/15 0.94/16   76/35 3,77 1.90/31 1.75/8 1.88/16 1.93/15
2019-05-12 FC Koln 3-5 Regensburg 80/39 3,78 1.94/32 1.75/8 1.88/16 2.00/16   48/-1 3,03 1.41/32 1.13/8 1.44/16 1.38/16
2019-05-19 Magdeburg 1-1 FC Koln 34/-18 2,61 0.91/33 1.00/8 0.94/16 0.88/17   83/37 3,91 1.88/33 1.38/8 1.76/17 2.00/16