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 = 527 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

Klaus Trageser

Statistik 2019 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 DC Hotzenplotz 1 - Starbulls 1 1.319 60 65,950 67,667 2 0 0 Starbulls 1 - DC Cartoon Gießen 2.333 127 55,110 48,467 1 1 0 Starbulls - Pirates of Darts 2.288 120 57,200 56,200 2 0 0 Starbulls 1 - TSV Ginnheim 1.868 100 56,040 56,500 0 0 0 DC Wetterau 1 - Starbulls 1 1.890 111 51,081 60,333 2 0 0 Starbulls 1 - Arrows 1 1.199 66 54,500 51,000 0 0 0 Starbulls 1 - Marburg 3 1.503 91 49,549 51,556 2 0 0 Starbulls 1 - Mighty Mosquitos 1 2.409 147 49,163 52,933 2 0 0 Starbulls 1 - Unicorn Hessen 1 2.025 103 58,981 55,133 1 0 0 Starbulls 1 - DC Bulldogs 1 2.298 128 53,859 66,667 4 1 0 Starbulls 1 - DC 1984 Lebfritz 1 1.909 119 48,126 55,333 4 0 0 Gesamt: 21.041 1.172 53,859 56,442 20 2 0   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 DC Hotzenplotz 1 - Starbulls 1 953 54 52,944 1 0 0 Starbulls 1 - DC Cartoon Gießen 1.150 58 59,483 1 0 0 Starbulls - Pirates of Darts 964 53 54,566 0 0 0 Starbulls 1 - TSV Ginnheim 1.133 57 59,632 1 0 0 DC Wetterau 1 - Starbulls 1 1.351 75 54,040 2 0 0 Starbulls 1 - Arrows 1 1.358 66 61,727 1 0 0 Starbulls 1 - Marburg 3 1.305 81 48,333 0 0 0 Starbulls 1 - Mighty Mosquitos 1 849 51 49,941 1 0 0 Starbulls 1 - Unicorn Hessen 1 1.242 71 52,479 1 0 0 Starbulls 1 - DC Bulldogs 1 1.041 55 56,782 0 0 0 Starbulls 1 - DC 1984 Lebfritz 1 1.153 58 59,638 2 0 0 Gesamt: 12.499 679 55,224 10 0 0