SELECT * FROM 1_Kampe WHERE LigaID = '54' AND (Home='SG Dynamo Dresden' OR Away='SG Dynamo Dresden') 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-06 SG Dynamo Dresden 1-0 Duisburg 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-11 Arminia Bielefeld 2-1 SG Dynamo Dresden 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.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-14 Regensburg 0-2 SG Dynamo Dresden 5/-3 3,25 1.00/4 1.00/4 2.00/2 0.00/2   3/-2 2,67 1.00/3 1.00/3 1.50/2 0.00/1
2018-09-18 SG Dynamo Dresden 0-1 Hamburger SV 5/0 2,50 1.50/4 1.50/4 1.50/2 1.50/2   9/4 3,50 2.25/4 2.25/4 2.00/3 3.00/1
2018-09-22 SG Dynamo Dresden 4-1 Darmstadt 5/-1 2,20 1.20/5 1.20/5 1.00/3 1.50/2   6/3 1,80 2.00/5 2.00/5 2.33/3 1.50/2
2018-09-25 Bochum 0-1 SG Dynamo Dresden 13/7 3,17 1.83/6 1.83/6 2.00/3 1.67/3   9/2 2,67 1.50/6 1.50/6 1.50/4 1.50/2
2018-09-30 SG Dynamo Dresden 0-1 Greuther Furth 10/3 2,43 1.71/7 1.71/7 1.50/4 2.00/3   11/4 2,57 1.71/7 1.71/7 2.00/4 1.33/3
2018-10-06 Magdeburg 2-2 SG Dynamo Dresden 11/-1 2,88 1.00/8 1.00/8 0.75/4 1.25/4   10/2 2,25 1.50/8 1.50/8 1.20/5 2.00/3
2018-10-19 SG Dynamo Dresden 1-1 Aue 12/2 2,44 1.44/9 1.25/8 1.20/5 1.75/4   10/-3 2,56 1.11/9 1.25/8 1.75/4 0.60/5
2018-10-28 Union Berlin 0-0 SG Dynamo Dresden 14/7 2,10 1.80/10 1.75/8 2.20/5 1.40/5   13/2 2,40 1.40/10 1.38/8 1.17/6 1.75/4
2018-11-02 SG Dynamo Dresden 3-1 Sandhausen 13/2 2,18 1.36/11 1.50/8 1.17/6 1.60/5   12/-5 2,64 0.82/11 1.13/8 0.80/5 0.83/6
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-25 SG Dynamo Dresden 2-0 Ingolstadt 17/-3 2,85 1.38/13 1.50/8 1.43/7 1.33/6   13/-14 3,08 0.62/13 0.38/8 0.86/7 0.33/6
2018-12-01 St. Pauli 1-1 SG Dynamo Dresden 20/1 2,79 1.71/14 1.88/8 1.67/6 1.75/8   19/-1 2,79 1.50/14 1.50/8 1.63/8 1.33/6
2018-12-09 SG Dynamo Dresden 0-2 Holstein Kiel 20/-1 2,73 1.47/15 1.25/8 1.63/8 1.29/7   28/6 3,33 1.60/15 1.88/8 1.86/7 1.38/8
2018-12-15 Paderborn 3-0 SG Dynamo Dresden 33/5 3,81 1.38/16 1.25/8 1.50/8 1.25/8   20/-3 2,69 1.38/16 1.25/8 1.44/9 1.29/7
2018-12-23 Duisburg 1-3 SG Dynamo Dresden 15/-15 2,65 0.76/17 1.00/8 0.38/8 1.11/9   20/-6 2,71 1.29/17 1.13/8 1.44/9 1.13/8
2019-01-30 SG Dynamo Dresden 3-4 Arminia Bielefeld 23/-4 2,78 1.39/18 1.38/8 1.44/9 1.33/9   22/-6 2,78 1.00/18 0.75/8 0.89/9 1.11/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-11 Hamburger SV 1-0 SG Dynamo Dresden 27/5 2,45 2.00/20 2.00/8 1.80/10 2.20/10   26/-6 2,90 1.25/20 0.88/8 1.30/10 1.20/10
2019-02-17 SG Dynamo Dresden 0-0 Regensburg 26/-7 2,81 1.19/21 0.88/8 1.30/10 1.09/11   33/0 3,14 1.38/21 1.13/8 1.30/10 1.45/11
2019-02-23 Darmstadt 2-0 SG Dynamo Dresden 29/-11 3,14 1.05/22 0.75/8 1.55/11 0.55/11   26/-7 2,68 1.18/22 0.63/8 1.27/11 1.09/11
2019-03-03 SG Dynamo Dresden 2-2 Bochum 26/-9 2,65 1.13/23 0.50/8 1.27/11 1.00/12   33/-1 2,91 1.30/23 0.75/8 1.58/12 1.00/11
2019-03-16 SG Dynamo Dresden 1-1 Magdeburg 28/-9 2,71 1.13/24 0.63/8 1.25/12 1.00/12   27/-13 2,68 0.88/25 1.38/8 0.85/13 0.92/12
2019-04-01 Aue 1-3 SG Dynamo Dresden 33/-2 2,62 1.23/26 1.25/8 1.46/13 1.00/13   29/-9 2,68 1.12/25 0.75/8 1.23/13 1.00/12
2019-04-04 Greuther Furth 0-0 SG Dynamo Dresden 28/-15 2,73 1.27/26 1.13/8 1.50/12 1.07/14   32/-7 2,73 1.19/26 0.75/8 1.23/13 1.15/13
2019-04-07 SG Dynamo Dresden 0-0 Union Berlin 32/-7 2,63 1.19/27 0.88/8 1.23/13 1.14/14   43/17 2,56 1.74/27 1.63/8 2.21/14 1.23/13
2019-04-13 Sandhausen 3-1 SG Dynamo Dresden 32/-8 2,57 0.96/28 1.38/8 1.07/14 0.86/14   32/-7 2,54 1.18/28 1.00/8 1.21/14 1.14/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 Ingolstadt 1-0 SG Dynamo Dresden 34/-17 2,83 0.87/30 0.88/8 0.73/15 1.00/15   36/-6 2,60 1.20/30 1.25/8 1.33/15 1.07/15
2019-05-03 SG Dynamo Dresden 2-1 St. Pauli 36/-7 2,55 1.16/31 1.25/8 1.33/15 1.00/16   44/-5 3,00 1.55/31 1.00/8 1.75/16 1.33/15
2019-05-12 Holstein Kiel 3-0 SG Dynamo Dresden 57/7 3,34 1.44/32 0.88/8 1.63/16 1.25/16   38/-6 2,56 1.22/32 1.50/8 1.44/16 1.00/16
2019-05-19 SG Dynamo Dresden 3-1 Paderborn 38/-9 2,58 1.18/33 1.38/8 1.44/16 0.94/17   75/28 3,70 1.73/33 2.38/8 2.12/17 1.31/16