SELECT * FROM 1_Kampe WHERE LigaID = '63' AND (Home='Chemnitzer' OR Away='Chemnitzer') 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
2019-07-21 Chemnitzer 1-1 Mannheim 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
2019-07-28 Viktoria Koln 3-2 Chemnitzer 3/0 6,00 1.00/1 1.00/1 0.00/0 1.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-07-31 Chemnitzer 2-4 Meppen 3/-1 3,50 0.50/2 0.50/2 1.00/1 0.00/1   0/-2 1,00 0.50/2 0.50/2 0.00/1 1.00/1
2019-08-03 Hallescher 3-1 Chemnitzer 3/2 1,33 2.00/3 2.00/3 3.00/1 1.50/2   5/-3 4,33 0.33/3 0.33/3 0.50/2 0.00/1
2019-08-16 Chemnitzer 0-0 Magdeburg 6/-5 4,25 0.25/4 0.25/4 0.50/2 0.00/2   6/0 3,00 1.25/4 1.25/4 0.50/2 2.00/2
2019-08-24 Bayern II 2-2 Chemnitzer 8/-4 4,00 1.20/5 1.20/5 1.50/2 1.00/3   6/-5 3,40 0.40/5 0.40/5 0.67/3 0.00/2
2019-08-30 Chemnitzer 0-1 Munich 1860 8/-5 3,50 0.50/6 0.50/6 0.67/3 0.33/3   6/-6 3,00 0.83/6 0.83/6 1.67/3 0.00/3
2019-09-16 Unterhaching 2-1 Chemnitzer 13/2 3,43 2.00/7 2.00/7 2.00/3 2.00/4   8/-6 3,14 0.43/7 0.43/7 0.50/4 0.33/3
2019-09-21 Chemnitzer 3-2 Jena 9/-7 3,13 0.38/8 0.38/8 0.50/4 0.25/4   4/-13 2,63 0.13/8 0.13/8 0.25/4 0.00/4
2019-09-28 Grossaspach 2-0 Chemnitzer 10/-10 3,33 0.89/9 1.00/8 0.50/4 1.20/5   12/-6 3,33 0.67/9 0.63/8 1.00/5 0.25/4
2019-10-06 Chemnitzer 3-1 Duisburg 12/-8 3,20 0.60/10 0.63/8 1.00/5 0.20/5   23/8 3,80 1.90/10 2.00/8 2.40/5 1.40/5
2019-10-19 Ingolstadt 1-1 Chemnitzer 21/7 3,18 1.64/11 1.38/8 1.60/5 1.67/6   15/-6 3,27 0.82/11 1.00/8 1.33/6 0.20/5
2019-10-27 Chemnitzer 3-1 Kaiserslautern 16/-6 3,17 0.83/12 1.13/8 1.33/6 0.33/6   19/-7 3,75 1.08/12 1.00/8 1.17/6 1.00/6
2019-11-02 Preussen Munster 3-3 Chemnitzer 19/-6 3,38 0.85/13 0.50/8 1.33/6 0.43/7   19/-4 3,23 1.00/13 1.38/8 1.57/7 0.33/6
2019-11-10 Chemnitzer 0-0 Wurzburger Kickers 22/-4 3,43 1.00/14 1.38/8 1.57/7 0.43/7   23/-10 4,00 1.36/14 1.63/8 1.71/7 1.00/7
2019-11-23 Braunschweig 2-1 Chemnitzer 24/5 2,87 1.67/15 0.88/8 1.14/7 2.13/8   22/-4 3,20 1.00/15 1.50/8 1.50/8 0.43/7
2019-11-30 Chemnitzer 1-1 Uerdingen 23/-5 3,19 0.94/16 1.50/8 1.50/8 0.38/8   17/-6 2,50 1.38/16 1.63/8 1.00/8 1.75/8
2019-12-06 Chemnitzer 2-2 Zwickau 24/-5 3,12 0.94/17 1.25/8 1.44/9 0.38/8   27/2 3,06 1.29/17 1.38/8 1.63/8 1.00/9
2019-12-14 Hansa Rostock 1-2 Chemnitzer 21/-4 2,56 1.39/18 1.50/8 1.89/9 0.89/9   26/-5 3,17 0.94/18 1.38/8 1.40/10 0.38/8
2019-12-21 Mannheim 4-3 Chemnitzer 29/7 2,68 1.58/19 1.50/8 1.11/9 2.00/10   28/-4 3,16 1.05/19 1.38/8 1.40/10 0.67/9
2020-01-25 Chemnitzer 2-2 Viktoria Koln 31/-5 3,35 1.00/20 1.25/8 1.40/10 0.60/10   33/-9 3,75 1.05/20 0.25/8 0.91/11 1.22/9
2020-02-01 Meppen 1-2 Chemnitzer 40/10 3,33 1.48/21 1.88/8 1.60/10 1.36/11   33/-5 3,38 1.00/21 1.00/8 1.36/11 0.60/10
2020-02-09 Chemnitzer 3-0 Hallescher 35/-4 3,36 1.09/22 1.25/8 1.36/11 0.82/11   38/11 2,95 1.45/22 0.88/8 1.33/12 1.60/10
2020-02-15 Magdeburg 1-1 Chemnitzer 29/3 2,39 1.22/23 1.00/8 1.27/11 1.17/12   38/-1 3,35 1.17/23 1.50/8 1.50/12 0.82/11
2020-02-24 Chemnitzer 1-0 Bayern II 39/-1 3,29 1.17/24 1.63/8 1.50/12 0.83/12   49/4 3,92 1.46/24 1.63/8 1.62/13 1.27/11
2020-02-29 Munich 1860 4-3 Chemnitzer 38/3 2,92 1.44/25 1.50/8 1.75/12 1.15/13   40/0 3,20 1.24/25 1.88/8 1.62/13 0.83/12
2020-03-07 Chemnitzer 1-0 Unterhaching 43/-1 3,35 1.19/26 1.75/8 1.62/13 0.77/13   40/10 2,69 1.69/26 1.63/8 1.50/14 1.92/12
2020-05-31 Jena 0-1 Chemnitzer 27/-34 3,26 0.63/27 0.63/8 0.62/13 0.64/14   44/0 3,26 1.26/27 1.75/8 1.71/14 0.77/13
2020-06-03 Chemnitzer 0-1 Grossaspach 45/1 3,18 1.32/28 2.13/8 1.71/14 0.93/14   23/-31 2,75 0.75/28 0.50/8 0.60/15 0.92/13
2020-06-06 Duisburg 2-1 Chemnitzer 53/14 3,17 1.66/29 1.00/8 2.14/14 1.20/15   45/0 3,10 1.28/29 2.00/8 1.60/15 0.93/14
2020-06-10 Chemnitzer 0-1 Ingolstadt 46/-1 3,10 1.23/30 1.63/8 1.60/15 0.87/15   51/13 2,97 1.53/30 0.63/8 1.50/16 1.57/14
2020-06-13 Kaiserslautern 2-0 Chemnitzer 47/-3 3,13 1.32/31 1.25/8 1.20/15 1.44/16   46/-2 3,03 1.19/31 1.25/8 1.50/16 0.87/15
2020-06-16 Chemnitzer 1-0 Preussen Munster 46/-4 3,00 1.16/32 1.13/8 1.50/16 0.81/16   45/-9 3,09 1.09/32 1.75/8 1.41/17 0.73/15
2020-06-19 Wurzburger Kickers 3-0 Chemnitzer 60/9 3,36 1.64/33 2.13/8 1.75/16 1.53/17   47/-3 2,94 1.21/33 1.13/8 1.59/17 0.81/16
2020-06-23 Chemnitzer 1-2 Braunschweig 47/-6 2,94 1.18/34 1.13/8 1.59/17 0.76/17   54/11 2,85 1.71/34 2.13/8 1.78/18 1.63/16
2020-06-26 Uerdingen 1-1 Chemnitzer 38/-13 2,54 1.31/35 0.88/8 1.12/17 1.50/18   48/-7 2,94 1.14/35 0.75/8 1.50/18 0.76/17
2020-07-01 Zwickau 2-1 Chemnitzer 54/-6 3,17 1.11/36 0.88/8 1.44/18 0.78/18   49/-7 2,92 1.14/36 0.50/8 1.50/18 0.78/18
2020-07-04 Chemnitzer 4-2 Hansa Rostock 50/-8 2,92 1.11/37 0.50/8 1.50/18 0.74/19   52/13 2,46 1.59/37 2.13/8 1.95/19 1.22/18