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 = 101 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 AND Year(lg.mdate)=2018 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 Herchenröder

Statistik 2018 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 1.423 75 56,920 63,778 4 0 0 Arrows 5 - DC Hotzenplotz 2 1.912 117 49,026 62,583 4 1 0 Golden Warriors 2 - DC Hotzenplotz 2 1.503 80 56,363 55,111 3 0 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 2.463 160 46,181 59,200 3 0 0 DC Hotzenplotz 2 - Bären 3 2.389 142 50,472 57,133 5 0 0 DC Hotzenplotz 2 - Flying Eagles 6 1.872 101 55,604 50,667 2 1 0 DC Hotzenplotz 2 - SSG Langen GUDE-Darter 2.170 160 40,688 47,067 2 1 0 DC Hotzenplotz 2 - Seenbachdarter 1 2.140 141 45,532 44,000 1 0 0 Gesamt: 15.872 976 48,787 54,314 24 3 0   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 1.142 63 54,381 3 0 0 Arrows 5 - DC Hotzenplotz 2 1.666 104 48,058 2 0 0 Golden Warriors 2 - DC Hotzenplotz 2 877 47 55,979 3 0 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 811 60 40,550 2 0 0 DC 1984 Lebfritz - DC Hotzenplotz 2 825 45 55,000 2 0 0 DC Hotzenplotz 2 - Bären 3 1.123 84 40,107 2 0 0 Seenbachdarter 1 - DC Hotzenplotz 2 878 57 46,211 1 1 0 DC Hotzenplotz 2 - Flying Eagles 6 526 45 35,067 0 0 0 DC Hotzenplotz 2 - SSG Langen GUDE-Darter 658 45 43,867 1 0 0 DC Hotzenplotz 2 - Seenbachdarter 1 1.012 79 38,430 3 1 0 Gesamt: 9.518 629 45,396 19 2 0