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

Daniel Zobel

Statistik 2018 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 1.834 145 37,945 45,500 1 1 0 Arrows 1 - DC Hotzenplotz 1 1.858 99 56,303 51,500 3 0 0 Arrows 5 - DC Hotzenplotz 2 1.957 145 40,490 62,000 3 1 0 Golden Warriors 2 - DC Hotzenplotz 2 1.503 125 36,072 63,556 0 1 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 2.385 155 46,161 45,867 3 0 0 DC Hotzenplotz 2 - DC Bruchköbel 2 1.503 102 44,206 75,222 3 0 0 DC 1984 Lebfritz - DC Hotzenplotz 2 1.878 102 55,235 50,833 2 1 0 DC Hotzenplotz 2 - Bären 3 1.503 78 57,808 64,111 3 0 0 Seenbachdarter 1 - DC Hotzenplotz 2 2.002 107 56,131 56,667 3 1 0 DC Hotzenplotz 1 - Pirates of Darts 1.213 75 48,520 42,111 2 0 0 DC Hotzenplotz 1 - DC Wetterau 1 1.051 66 47,773 57,444 2 0 0 Arrows 1 - DC Hotzenplotz 1 1.250 72 52,083 45,444 2 0 0 DC Hotzenplotz 1 - Marburg 3 1.203 78 46,269 41,222 0 0 0 Golden Warriors - DC Hotzenplotz 1 1.837 95 58,011 49,583 7 0 0 DC Hotzenplotz 1 - DC Krone Hattersheim 1 2.381 154 46,383 45,467 2 0 0 Gesamt: 25.358 1.598 47,606 52,515 36 5 0   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 823 54 45,722 1 0 0 Arrows 1 - DC Hotzenplotz 1 923 45 61,533 4 0 0 Arrows 5 - DC Hotzenplotz 2 697 54 38,722 0 0 0 Golden Warriors 2 - DC Hotzenplotz 2 626 43 43,674 1 0 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 1.349 72 56,208 2 0 1 DC Hotzenplotz 2 - DC Bruchköbel 2 764 67 34,209 1 0 0 DC 1984 Lebfritz - DC Hotzenplotz 2 895 73 36,781 0 0 0 DC Hotzenplotz 2 - Bären 3 1.542 81 57,111 2 1 0 Seenbachdarter 1 - DC Hotzenplotz 2 1.139 67 51,000 3 0 0 DC Hotzenplotz 1 - Pirates of Darts 579 36 48,250 0 0 0 DC Hotzenplotz 1 - DC Wetterau 1 834 62 40,355 0 0 0 Arrows 1 - DC Hotzenplotz 1 898 42 64,143 2 0 0 DC Hotzenplotz 1 - Marburg 3 771 75 30,840 0 0 0 Golden Warriors - DC Hotzenplotz 1 613 30 61,300 1 0 0 DC Hotzenplotz 1 - DC Krone Hattersheim 1 1.024 50 61,440 1 0 0 Gesamt: 13.477 851 47,510 18 1 1