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

Uwe Kretschmer
Statistik
Einzel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
2008
1.877
94
59,904
68,417
3
1
0
2009
1.944
110
53,018
57,750
4
0
0
2010
1.378
66
62,636
76,778
4
1
0
2013
1.204
63
57,333
52,444
2
1
0
2016
3.754
254
44,339
60,250
4
1
1
2017
23.565
1.345
52,561
58,380
37
8
0
2018
22.684
1.414
48,127
53,660
34
8
0
2019
24.076
1.387
52,075
61,167
36
10
1
Gesamt:
80.482
4.733
51,013
58,341
124
30
2
 
Doppel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
2008
976
48
61,000
1
0
0
2009
794
36
66,167
0
1
0
2010
1.203
69
52,304
0
1
0
2013
765
35
65,571
3
0
0
2016
814
50
48,840
2
0
0
2017
12.950
726
53,512
23
7
0
2018
13.059
817
47,952
15
4
0
2019
12.556
805
46,793
14
5
0
Gesamt:
43.117
2.586
50,020
58
18
0