SELECT SUM(ranked.score) AS scores, SUM(ranked.darts) AS darts, ranked.year, heim, gast, id, mdate FROM (SELECT ls.score, ls.darts as darts, YEAR(`lg`.`mdate`) as YEAR, lg.heim, lg.gast, lg.id, lg.mdate ,@leground := IF(@tmpleg = leg, @leground + 1, 1) AS leground, @tmpleg := leg FROM #__livescore_score ls INNER JOIN #__livescore_games lg ON ls.game = lg.id INNER JOIN #__livescore_modus lm ON lg.rrmodus = lm.id INNER JOIN #__livescore_roundrobin lrr ON lm.id = lrr.modus AND lrr.ordering = ls.spiel WHERE ls.pass = 2444 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 AND Year(lg.mdate)=2019 ORDER BY ls.game, ls.spiel, ls.leg, ls.id) ranked WHERE ranked.leground <= 3 GROUP BY ranked.year, ranked.mdate ORDER BY ranked.mdate

Florian Herzog

Statistik 2019 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 Starbulls 2 - Arrows 7 1.996 114 52,526 67,333 2 0 0 DC Hotzenplotz 1 - Starbulls 1 1.319 78 50,731 55,556 1 0 0 Starbulls 2 - DC Derngem 2.002 145 41,421 46,167 0 0 0 Starbulls 2 - DC 1984 Lebfritz 1.849 103 53,854 48,667 3 1 0 Starbulls 2 - DC St. Patrick 1.984 112 53,143 56,917 1 0 0 Starbulls 2 - Arrows 5 1.503 90 50,100 60,111 0 1 1 DC Hotzenplotz 3 - Starbulls 2 1.503 112 40,259 57,889 2 0 0 Starbulls 2 - Arrows 5 1.139 75 45,560 48,222 0 0 0 DC Hotzenplotz 2 - Starbulls 2 1.914 129 44,512 54,750 2 0 0 Starbulls 2 - DC Hotzenplotz 3 1.256 78 48,308 61,333 1 0 0 Starbulls 2 - DC 1984 Lebfritz 2 1.503 93 48,484 65,111 2 0 0 Starbulls 2 - DC St. Patrick 2.411 136 53,184 68,600 3 0 1 Starbulls 2 - Golden Warriors 2 1.503 102 44,206 53,778 3 0 0 Starbulls 2 - DC Bruchköbel 2 2.286 181 37,890 57,133 1 1 0 Gesamt: 24.168 1.548 46,837 57,282 21 3 2   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 Starbulls 2 - Arrows 7 1.098 67 49,164 1 0 0 DC Hotzenplotz 1 - Starbulls 1 563 34 49,676 1 0 0 Starbulls 2 - DC Derngem 767 51 45,118 0 0 0 Starbulls 2 - DC 1984 Lebfritz 632 42 45,143 1 0 0 Starbulls 2 - DC St. Patrick 705 46 45,978 0 0 0 Starbulls 2 - Arrows 5 780 46 50,870 0 0 0 DC Hotzenplotz 3 - Starbulls 2 1.136 88 38,727 0 0 0 Starbulls 2 - Arrows 5 724 54 40,222 0 0 0 DC Hotzenplotz 2 - Starbulls 2 2.080 132 47,273 4 0 1 Starbulls 2 - DC Hotzenplotz 3 981 85 34,624 0 1 0 Starbulls 2 - DC 1984 Lebfritz 2 593 42 42,357 0 1 0 Starbulls 2 - DC St. Patrick 864 52 49,846 0 0 0 Starbulls 2 - Golden Warriors 2 925 86 32,267 0 0 0 Starbulls 2 - DC Bruchköbel 2 1.097 61 53,951 3 0 0 Gesamt: 12.945 886 43,832 10 2 1