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

Alexander Wies

Statistik 2019 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 DC Hotzenplotz 3 - DC Derngem 2.312 171 40,561 47,533 1 0 0 DC Hotzenplotz 3 - DC 1984 Lebfritz 788 63 37,524 27,111 1 0 0 DC Hotzenplotz 3 - Starbulls 2 1.980 146 40,685 38,417 3 0 0 DSV Hanau - DC Hotzenplotz 2 1.865 156 35,865 36,500 0 0 0 DC Hotzenplotz 2 - Starbulls 2 1.447 99 43,848 50,333 0 1 0 Arrows 5 - DC Hotzenplotz 2 1.984 157 37,911 46,250 1 0 0 DC Hotzenplotz 2 - DC 1984 Lebfritz 2 2.495 234 31,987 41,133 2 0 0 DC Hotzenplotz 2 - DC Gassebub 1.272 90 42,400 60,889 1 0 0 DC Hotzenplotz 3 - DC Hotzenplotz 2 1.832 132 41,636 42,333 0 0 0 Gesamt: 15.975 1.248 38,401 43,210 9 1 0   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 DC Hotzenplotz 3 - DC Derngem 1.212 83 43,807 0 0 0 DC Hotzenplotz 3 - DC 1984 Lebfritz 716 42 51,143 2 0 0 DC Hotzenplotz 3 - Starbulls 2 893 62 43,210 0 0 0 DC Hotzenplotz 2 - DC Logo 869 69 37,783 0 0 0 DSV Hanau - DC Hotzenplotz 2 666 54 37,000 0 0 0 DC Hotzenplotz 2 - Starbulls 2 613 60 30,650 0 0 0 Arrows 5 - DC Hotzenplotz 2 1.381 91 45,527 0 0 0 DC Hotzenplotz 2 - DC 1984 Lebfritz 2 892 67 39,940 0 0 0 DC Hotzenplotz 2 - DC Gassebub 834 63 39,714 0 0 0 DC Hotzenplotz 3 - DC Hotzenplotz 2 1.046 70 44,829 0 0 0 Gesamt: 9.122 661 41,401 2 0 0