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 = 367 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
LiveScoring

Gunnar Steidle
Statistik
Einzel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
2008
2.002
168
35,750
50,083
0
0
0
2009
1.376
90
45,867
55,778
2
0
0
2014
3.864
261
44,414
47,370
4
1
0
2016
2.316
162
42,889
49,733
3
1
0
2017
3.552
266
40,060
46,708
4
0
0
2018
8.778
683
38,556
42,860
6
0
0
2019
6.384
428
44,748
49,238
7
1
0
Gesamt:
28.272
2.058
41,213
47,097
26
3
0
 
Doppel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
2008
641
63
30,524
1
0
0
2009
952
63
45,333
0
0
0
2014
1.673
126
39,833
1
0
0
2016
950
74
38,514
2
0
0
2017
1.933
176
32,949
1
0
0
2018
6.138
468
39,346
3
1
0
2019
1.342
106
37,981
2
0
0
Gesamt:
13.629
1.076
37,999
10
1
0