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

Arkadius Stottko
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Arrows 7 - DC Bulldogs 2
2.463
144
51,313
58,400
3
0
0
Starbulls 2 - Arrows 7
1.503
73
61,767
68,778
2
3
0
Arrows 7 - Dartschlümpfe Großenlüder
2.489
149
50,114
82,867
5
2
0
Arrows 7 - DC Bruchköbel 2
1.503
76
59,329
61,444
1
0
1
Arrows 7 - DC 1984 Lebfritz
1.503
122
36,959
64,333
0
1
0
Arrows 7 - DC Logo
1.503
83
54,325
61,222
2
2
0
Arrows 5 - Arrows 7
1.503
66
68,318
76,444
2
2
1
Arrows 5 - DSV Hanau
1.503
71
63,507
72,222
4
0
0
Starbulls 2 - Arrows 5
1.503
93
48,484
71,111
3
0
0
Arrows 5 - DC Hotzenplotz 2
1.503
63
71,571
87,000
6
1
0
Arrows 5 - Dartschlümpfe Großenlüder
1.503
83
54,325
59,000
3
0
0
DC 1984 Lebfritz 2 - DSV Rodgau Arrows 5
2.002
126
47,667
79,833
4
1
0
Arrows 5 - DC Hotzenplotz 3
1.503
79
57,076
77,000
6
1
0
Golden Warriors 2 - Arrows 5
3.006
151
59,722
71,278
2
2
1
Arrows 5 - DC Bulldogs 2
1.503
63
71,571
70,000
1
2
0
Gesamt:
26.493
1.442
55,117
70,925
44
17
3
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Arrows 7 - DC Bulldogs 2
881
53
49,868
3
0
0
Starbulls 2 - Arrows 7
1.230
72
51,250
3
0
0
Arrows 7 - Dartschlümpfe Großenlüder
833
39
64,077
1
0
0
Arrows 7 - DC Bruchköbel 2
630
32
59,063
0
1
0
Arrows 7 - DC 1984 Lebfritz
1.313
86
45,802
2
0
0
Arrows 7 - DC Logo
1.477
91
48,692
1
0
0
Arrows 5 - Arrows 7
764
51
44,941
1
0
0
Arrows 5 - DSV Hanau
780
39
60,000
0
0
1
Starbulls 2 - Arrows 5
1.427
83
51,578
2
0
0
Arrows 5 - DC Hotzenplotz 2
1.236
73
50,795
1
0
0
Arrows 5 - Dartschlümpfe Großenlüder
856
48
53,500
1
0
0
DC 1984 Lebfritz 2 - DSV Rodgau Arrows 5
1.539
86
53,686
5
0
0
Arrows 5 - DC Hotzenplotz 3
1.249
68
55,103
1
0
0
Golden Warriors 2 - Arrows 5
974
51
57,294
1
0
1
Arrows 5 - DC Bulldogs 2
991
37
80,351
2
3
0
Gesamt:
16.180
909
53,399
24
4
2