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

Daniel Thölken
Statistik
Einzel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
2002
1.943
141
41,340
40,250
2
0
0
2003
13.065
912
42,977
47,488
18
1
0
2004
18.121
1.219
44,596
50,202
24
1
0
2005
8.048
567
42,582
48,686
4
0
0
2006
5.146
397
38,887
46,242
4
1
0
2007
3.285
176
55,994
62,381
7
1
0
2008
7.839
465
50,574
52,196
12
1
0
2009
13.203
824
48,069
65,099
18
6
1
2010
3.926
209
56,354
60,417
8
1
0
2011
8.510
437
58,421
62,333
14
2
0
2012
1.503
80
56,363
62,333
1
2
0
2014
1.503
78
57,808
72,111
3
1
0
Gesamt:
86.092
5.505
46,917
54,237
115
17
1
 
Doppel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
2002
738
60
36,900
0
0
0
2003
10.696
756
42,444
6
2
0
2004
8.558
573
44,806
10
1
0
2005
5.102
337
45,418
11
2
0
2006
1.761
130
40,638
2
1
0
2007
1.131
65
52,200
3
0
0
2008
2.819
160
52,856
6
1
0
2009
7.006
410
51,263
8
4
0
2010
2.465
149
49,631
2
2
0
2011
5.375
295
54,661
9
1
1
2012
1.241
80
46,538
2
1
0
2014
931
54
51,722
1
0
0
Gesamt:
47.823
3.069
46,748
60
15
1