SELECT SUM(ranked.score) AS scores, SUM(ranked.darts) AS darts, ranked.year FROM (SELECT ls.score, ls.darts as darts, YEAR(`lg`.`mdate`) as YEAR ,@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 = 272 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 ORDER BY ls.game, ls.spiel, ls.leg, ls.id) ranked WHERE ranked.leground <= 3 GROUP BY ranked.year

Uwe Schädel

Statistik Einzel Jahr Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 2003 632 42 45,143 47,333 0 0 0 2004 1.002 66 45,545 46,000 2 0 0 2007 1.856 185 30,097 39,467 0 0 0 2009 1.503 93 48,484 50,222 2 0 0 2010 2.495 202 37,054 42,400 4 0 0 2011 878 63 41,810 37,000 0 0 0 2014 1.503 120 37,575 50,889 1 0 0 2015 1.252 99 37,939 33,667 1 0 0 2016 4.033 344 35,172 43,367 1 0 0 2017 1.984 152 39,158 53,083 1 0 0 Gesamt: 17.138 1.366 37,638 43,933 12 0 0   Doppel Jahr Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 2004 630 59 32,034 0 0 0 2007 2.146 156 41,269 2 0 0 2009 1.363 106 38,575 2 0 0 2010 888 60 44,400 0 1 0 2011 754 75 30,160 0 0 0 2014 870 72 36,250 0 0 0 2015 1.313 85 46,341 3 0 0 2016 347 33 31,545 0 0 0 2017 2.172 215 30,307 0 0 0 2018 655 66 29,773 0 0 0 Gesamt: 11.138 927 36,045 7 1 0