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

Andreas Günther
Statistik
Einzel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
2006
2.719
169
48,266
58,833
2
0
0
2007
2.841
196
43,485
54,111
1
0
0
2008
3.890
273
42,747
47,583
2
0
0
2009
3.006
224
40,259
45,444
2
1
0
2011
2.207
156
42,442
45,600
1
1
0
2013
1.254
87
43,241
33,222
0
0
0
2015
1.972
172
34,395
47,917
2
0
0
2017
1.995
153
39,118
46,917
0
0
0
2018
2.000
153
39,216
47,667
0
0
0
2019
2.427
193
37,725
47,267
1
0
0
Gesamt:
24.311
1.776
41,066
48,333
11
2
0
 
Doppel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
2006
1.353
93
43,645
1
0
0
2007
1.164
80
43,650
1
0
0
2008
2.408
161
44,870
1
0
0
2009
2.049
142
43,289
2
0
0
2011
1.077
66
48,955
1
0
0
2013
818
80
30,675
0
1
0
2015
661
60
33,050
0
0
0
2017
943
69
41,000
0
0
0
2018
1.824
133
41,143
2
0
0
2019
861
71
36,380
0
0
0
Gesamt:
13.158
955
41,334
8
1
0