SELECT * FROM 1_Kampe WHERE LigaID = '54' AND (Home='Heidenheim' OR Away='Heidenheim') 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-05 Heidenheim 1-1 Arminia Bielefeld 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-12 Holstein Kiel 1-1 Heidenheim 3/3 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-08-26 SG Dynamo Dresden 1-3 Heidenheim 2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1   2/0 2,00 1.00/2 1.00/2 1.00/1 1.00/1
2018-09-02 Heidenheim 0-1 Darmstadt 5/2 2,67 1.67/3 1.67/3 1.00/1 2.00/2   4/2 2,00 2.00/3 2.00/3 3.00/2 0.00/1
2018-09-15 Hamburger SV 3-2 Heidenheim 6/3 3,00 2.00/3 2.00/3 1.50/2 3.00/1   5/1 2,25 1.25/4 1.25/4 0.50/2 2.00/2
2018-09-23 Heidenheim 2-0 Greuther Furth 7/0 2,80 1.00/5 1.00/5 0.50/2 1.33/3   11/6 3,20 2.20/5 2.20/5 2.33/3 2.00/2
2018-09-26 Regensburg 2-1 Heidenheim 10/0 3,33 1.17/6 1.17/6 1.33/3 1.00/3   9/2 2,67 1.33/6 1.33/6 1.33/3 1.33/3
2018-09-29 Heidenheim 3-2 Bochum 10/1 2,71 1.14/7 1.14/7 1.33/3 1.00/4   13/6 2,86 1.57/7 1.57/7 1.50/4 1.67/3
2018-10-07 Union Berlin 1-1 Heidenheim 13/7 2,38 2.00/8 2.00/8 2.50/4 1.50/4   13/2 3,00 1.38/8 1.38/8 1.75/4 1.00/4
2018-10-20 Heidenheim 3-0 Magdeburg 14/2 2,89 1.33/9 1.38/8 1.75/4 1.00/5   13/-1 3,00 1.00/9 1.13/8 0.80/5 1.25/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-04 Heidenheim 1-0 Aue 18/5 2,82 1.45/11 1.38/8 2.00/5 1.00/6   12/-2 2,36 1.27/11 1.63/8 2.00/5 0.67/6
2018-11-10 St. Pauli 1-1 Heidenheim 18/1 2,92 1.83/12 2.00/8 1.80/5 1.86/7   19/6 2,67 1.58/12 1.75/8 2.17/6 1.00/6
2018-11-25 Heidenheim 1-5 Paderborn 20/6 2,62 1.54/13 1.88/8 2.17/6 1.00/7   26/2 3,85 1.38/13 1.25/8 1.57/7 1.17/6
2018-12-02 Sandhausen 1-2 Heidenheim 14/-8 2,57 0.71/14 1.00/8 0.83/6 0.63/8   21/2 2,86 1.43/14 1.50/8 1.86/7 1.00/7
2018-12-08 Heidenheim 4-1 Duisburg 23/3 2,87 1.53/15 1.88/8 1.86/7 1.25/8   13/-11 2,47 0.87/15 1.38/8 0.43/7 1.25/8
2018-12-16 Ingolstadt 1-1 Heidenheim 15/-17 2,94 0.56/16 0.50/8 0.75/8 0.38/8   27/6 3,00 1.63/16 1.88/8 2.00/8 1.25/8
2018-12-22 Arminia Bielefeld 1-2 Heidenheim 21/-5 2,76 1.06/17 0.75/8 1.00/8 1.11/9   28/6 2,94 1.59/17 1.88/8 2.00/8 1.22/9
2019-01-30 Heidenheim 2-2 Holstein Kiel 30/7 2,94 1.67/18 1.88/8 2.00/8 1.40/10   34/9 3,28 1.67/18 2.13/8 1.78/9 1.56/9
2019-02-02 Heidenheim 1-0 SG Dynamo Dresden 32/7 3,00 1.63/19 1.88/8 1.89/9 1.40/10   26/-5 3,00 1.32/19 1.25/8 1.30/10 1.33/9
2019-02-10 Darmstadt 1-2 Heidenheim 27/-10 3,20 1.10/20 0.63/8 1.70/10 0.50/10   33/8 2,90 1.70/20 1.88/8 2.00/10 1.40/10
2019-02-16 Heidenheim 2-2 Hamburger SV 35/9 2,90 1.76/21 2.13/8 2.00/10 1.55/11   28/6 2,38 2.05/21 2.00/8 1.91/11 2.20/10
2019-02-22 Greuther Furth 0-0 Heidenheim 24/-16 2,91 1.27/22 0.63/8 1.60/10 1.00/12   37/9 2,95 1.73/22 2.25/8 1.91/11 1.55/11
2019-03-02 Heidenheim 1-2 Regensburg 37/9 2,83 1.70/23 2.00/8 1.91/11 1.50/12   35/1 3,00 1.43/23 1.38/8 1.45/11 1.42/12
2019-03-08 Bochum 1-0 Heidenheim 35/-1 2,96 1.29/24 0.88/8 1.58/12 1.00/12   38/8 2,83 1.63/24 1.63/8 1.75/12 1.50/12
2019-03-15 Heidenheim 2-1 Union Berlin 38/7 2,76 1.56/25 1.50/8 1.75/12 1.38/13   41/20 2,48 1.88/25 2.00/8 2.38/13 1.33/12
2019-03-29 Magdeburg 0-0 Heidenheim 28/-13 2,65 0.88/26 1.50/8 0.85/13 0.92/13   40/8 2,77 1.62/26 1.50/8 1.85/13 1.38/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-12 Aue 0-1 Heidenheim 35/-5 2,68 1.14/28 1.25/8 1.36/14 0.93/14   40/6 2,64 1.54/28 1.13/8 1.71/14 1.36/14
2019-04-21 Heidenheim 3-0 St. Pauli 41/7 2,59 1.59/29 1.13/8 1.71/14 1.47/15   40/-3 2,86 1.55/29 1.00/8 1.67/15 1.43/14
2019-04-28 Paderborn 3-1 Heidenheim 68/25 3,70 1.70/30 1.75/8 2.00/15 1.40/15   44/10 2,60 1.63/30 1.38/8 1.80/15 1.47/15
2019-05-04 Heidenheim 2-3 Sandhausen 45/8 2,65 1.58/31 1.25/8 1.80/15 1.38/16   40/-5 2,74 1.10/31 2.13/8 1.31/16 0.87/15
2019-05-12 Duisburg 3-4 Heidenheim 36/-22 2,94 0.88/32 1.00/8 0.75/16 1.00/16   47/7 2,72 1.53/32 1.25/8 1.69/16 1.38/16
2019-05-19 Heidenheim 4-2 Ingolstadt 51/8 2,85 1.58/33 1.63/8 1.69/16 1.47/17   41/-10 2,79 1.06/33 2.00/8 1.00/17 1.13/16