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

Nico Schneider

Statistik 2019 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 DSV Hanau - DC Hotzenplotz 2 1.066 75 42,640 34,111 1 0 0 Arrows 5 - DC Hotzenplotz 2 1.503 113 39,903 40,556 1 0 0 DC Hotzenplotz 2 - DC 1984 Lebfritz 2 1.503 117 38,538 48,556 5 0 0 DC Hotzenplotz 2 - DC Gassebub 1.893 146 38,897 46,000 2 0 0 DC Hotzenplotz 3 - DC Hotzenplotz 2 1.960 139 42,302 49,000 2 0 0 Golden Warriors 2 - DC Hotzenplotz 2 2.002 166 36,181 39,083 0 0 0 Gesamt: 9.927 756 39,393 43,143 11 0 0   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 DC Hotzenplotz 2 - DC Logo 886 70 37,971 0 0 0 DSV Hanau - DC Hotzenplotz 2 662 51 38,941 1 0 0 Arrows 5 - DC Hotzenplotz 2 901 63 42,905 0 0 0 DC Hotzenplotz 2 - DC 1984 Lebfritz 2 949 69 41,261 0 0 0 DC Hotzenplotz 2 - DC Gassebub 744 47 47,489 0 1 0 DC Hotzenplotz 3 - DC Hotzenplotz 2 1.145 73 47,055 1 0 0 Golden Warriors 2 - DC Hotzenplotz 2 648 48 40,500 1 0 0 Gesamt: 5.935 421 42,292 3 1 0