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

Sonja Neuendorf
Statistik
Einzel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
2002
3.483
208
50,236
46,190
5
0
0
2003
3.967
245
48,576
54,000
4
1
0
2005
1.454
100
43,620
38,444
2
0
0
2006
5.772
387
44,744
54,556
3
0
0
2007
20.447
1.369
44,807
51,746
25
5
1
2008
19.658
1.294
45,575
54,556
15
4
0
2009
18.719
1.162
48,328
57,051
29
1
0
2010
21.666
1.300
49,998
51,630
23
3
0
2011
12.295
792
46,572
54,654
12
1
0
2012
14.062
1.055
39,987
46,667
10
0
0
2013
9.782
770
38,112
45,758
3
0
0
2014
1.453
111
39,270
49,667
3
0
0
2015
4.421
346
38,332
41,926
2
0
0
2019
3.649
298
36,735
38,750
0
0
0
Gesamt:
140.828
9.437
44,769
51,375
136
15
1
 
Doppel
Jahr
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
2002
1.419
100
42,570
1
0
0
2003
3.398
223
45,713
4
1
0
2005
523
33
47,545
2
0
0
2006
3.714
237
47,013
6
0
0
2007
11.165
721
46,456
17
3
0
2008
10.866
636
51,255
14
3
1
2009
10.536
635
49,776
9
2
0
2010
13.977
885
47,380
17
1
1
2011
6.785
458
44,443
11
0
1
2012
9.112
653
41,862
8
1
1
2013
6.163
472
39,172
3
1
0
2014
1.815
158
34,462
0
0
0
2015
1.489
111
40,243
0
0
0
2019
2.040
164
37,317
0
0
0
Gesamt:
83.002
5.486
45,389
92
12
4