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 = 2785 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 AND Year(lg.mdate)=2018 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

Thomas Klepl
Statistik 2018
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Golden Warriors 2 - Starbulls 2
2.501
191
39,283
51,133
2
0
0
Starbulls 2 - DC Hotzenplotz 2
1.726
120
43,150
51,750
2
0
0
Starbulls 2 - Dartschlümpfe Großenlüder
2.371
153
46,490
47,733
2
0
0
DC 1984 Lebfritz - Starbulls 2
2.217
144
46,188
51,267
2
1
0
Starbulls 2 - DC Logo
1.988
116
51,414
57,917
3
0
0
Starbulls 2 - DC Bulldogs 2
1.503
90
50,100
55,444
1
1
0
Starbulls 2 - DSV Hanau
1.669
111
45,108
50,083
0
1
0
Arrows 7 - Starbulls 2
1.359
99
41,182
45,556
0
0
0
Starbulls 2 - Dartschlümpfe Großenlüder
1.914
153
37,529
48,333
2
0
0
Starbulls 2 - DC Bruchköbel 2
2.501
186
40,339
65,533
2
1
0
DC 1984 Lebfritz - Starbulls 2
2.251
129
52,349
57,400
2
0
0
Starbulls 2 - DC Logo
1.503
92
49,011
65,556
2
0
0
Arrows 5 - Starbulls 2
1.968
161
36,671
60,583
1
0
0
Starbulls 2 - DC Hotzenplotz 3
1.999
127
47,220
49,917
4
0
0
Gesamt:
27.470
1.872
44,022
54,126
25
4
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Golden Warriors 2 - Starbulls 2
977
65
45,092
1
0
0
Starbulls 2 - DC Hotzenplotz 2
1.267
82
46,354
2
0
0
Starbulls 2 - Dartschlümpfe Großenlüder
1.045
63
49,762
2
1
0
DC 1984 Lebfritz - Starbulls 2
932
55
50,836
2
0
0
Starbulls 2 - DC Logo
940
69
40,870
0
0
0
Starbulls 2 - DC Bulldogs 2
802
72
33,417
0
0
0
Starbulls 2 - DSV Hanau
1.190
87
41,034
3
0
0
Arrows 7 - Starbulls 2
1.764
129
41,023
2
0
0
Starbulls 2 - Dartschlümpfe Großenlüder
2.080
178
35,056
2
0
0
Starbulls 2 - DC Bruchköbel 2
703
42
50,214
0
0
0
DC 1984 Lebfritz - Starbulls 2
631
36
52,583
0
0
0
Starbulls 2 - DC Logo
681
50
40,860
0
0
0
Arrows 5 - Starbulls 2
937
78
36,038
1
0
0
Starbulls 2 - DC Hotzenplotz 3
831
54
46,167
1
0
0
Gesamt:
14.780
1.060
41,830
16
1
0