SELECT SUM(ranked.score) AS scores, SUM(ranked.darts) AS darts, ranked.year, heim, gast, id, mdate FROM (SELECT ls.score, ls.darts as darts, YEAR(`lg`.`mdate`) as YEAR, lg.heim, lg.gast, lg.id, lg.mdate ,@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 = 99 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 AND Year(lg.mdate)=2019 ORDER BY ls.game, ls.spiel, ls.leg, ls.id) ranked WHERE ranked.leground <= 3 GROUP BY ranked.year, ranked.mdate ORDER BY ranked.mdate
LiveScoring

Benjamin Stimac
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Arrows 7 - DC Bulldogs 2
1.503
94
47,968
66,556
2
1
0
Starbulls 2 - Arrows 7
1.191
78
45,808
41,444
3
0
0
Arrows 1 - Golden Warriors
1.275
72
53,125
66,111
2
0
1
Arrows 7 - Dartschlümpfe Großenlüder
1.711
134
38,306
51,083
2
0
0
Arrows 7 - DC Bruchköbel 2
1.503
84
53,679
55,778
3
0
0
Arrows 7 - DC 1984 Lebfritz
1.503
79
57,076
54,111
2
2
0
Arrows 7 - DC Logo
2.401
162
44,463
53,533
2
0
0
Arrows 5 - Arrows 7
1.503
136
33,154
46,333
2
0
0
Arrows 3 - DSV Hanau
1.685
120
42,125
53,417
1
0
0
Arrows 5 - DSV Hanau
1.503
75
60,120
59,667
4
0
0
Arrows 5 - DC Hotzenplotz 2
1.402
78
53,923
51,556
0
0
0
Arrows 5 - Dartschlümpfe Großenlüder
1.996
124
48,290
63,583
1
0
0
DC 1984 Lebfritz 2 - DSV Rodgau Arrows 5
2.449
171
42,965
47,067
2
0
0
Arrows 5 - DC Hotzenplotz 3
2.453
177
41,576
56,200
4
1
0
Golden Warriors 2 - Arrows 5
1.503
95
47,463
53,333
6
0
0
Arrows 5 - DC Bulldogs 2
2.002
128
46,922
45,917
1
0
0
Gesamt:
27.583
1.807
45,794
53,874
37
4
1
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Arrows 7 - DC Bulldogs 2
1.455
78
55,962
3
0
0
Starbulls 2 - Arrows 7
872
77
33,974
1
0
0
Arrows 1 - Golden Warriors
545
36
45,417
0
0
0
Arrows 7 - Dartschlümpfe Großenlüder
1.267
73
52,068
2
1
0
Arrows 7 - DC Bruchköbel 2
933
59
47,441
1
0
0
Arrows 7 - DC 1984 Lebfritz
1.084
60
54,200
0
0
0
Arrows 7 - DC Logo
760
41
55,610
1
1
0
Arrows 5 - Arrows 7
750
51
44,118
1
0
0
Arrows 5 - DSV Hanau
1.074
83
38,819
1
0
0
Arrows 5 - DC Hotzenplotz 2
996
60
49,800
2
0
0
Arrows 5 - Dartschlümpfe Großenlüder
647
42
46,214
0
0
0
DC 1984 Lebfritz 2 - DSV Rodgau Arrows 5
644
55
35,127
0
0
0
Arrows 5 - DC Hotzenplotz 3
1.335
82
48,841
0
0
0
Golden Warriors 2 - Arrows 5
2.312
150
46,240
0
1
0
Arrows 5 - DC Bulldogs 2
1.249
87
43,069
2
0
0
Gesamt:
15.923
1.034
46,198
14
3
0