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

Björn Tost
Statistik 2017
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DSV Rodgau Arrows III - SSG Langen GUDE-Darter
1.461
99
44,273
45,778
4
0
0
DSV Rodgau Arrows III - DIG Neu-Isenburg
1.767
104
50,971
55,500
1
0
0
DSV Rodgau Arrows III - DC Wetterau 1
1.980
119
49,916
48,000
2
0
0
Golden Warriors - DSV Rodgau Arrows III
1.762
99
53,394
59,000
1
1
0
DSV Rodgau Arrows III - Finegan's Light
1.503
92
49,011
59,111
2
0
0
DSV Rodgau Arrows III - Bären 3
2.302
125
55,248
51,800
2
1
0
DSV Rodgau Arrows III - DC Cartoon Gießen 2
2.399
146
49,295
57,333
6
1
0
Golden Warriors - DSV Rodgau Arrows III
1.954
118
49,678
42,417
3
0
0
DSV Rodgau Arrows III - Wizards 2
1.988
124
48,097
58,667
3
0
0
DSV Rodgau Arrows III - SSG Langen GUDE-Darter
1.017
66
46,227
48,222
1
0
0
DSV Rodgau Arrows III - DC Gassebub
1.964
129
45,674
55,833
3
0
0
DSV Rodgau Arrows III - DSV Hanau
1.430
84
51,071
49,000
2
1
0
Gesamt:
21.527
1.305
49,487
52,819
30
4
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DSV Rodgau Arrows III - SSG Langen GUDE-Darter
905
63
43,095
0
0
0
DSV Rodgau Arrows III - DIG Neu-Isenburg
962
62
46,548
1
0
0
DSV Rodgau Arrows III - DC Gassebub
610
39
46,923
1
0
0
DSV Rodgau Arrows III - DC Wetterau 1
906
60
45,300
1
0
0
Golden Warriors - DSV Rodgau Arrows III
727
57
38,263
0
0
0
DSV Rodgau Arrows III - Finegan's Light
789
44
53,795
3
0
0
DSV Rodgau Arrows III - Bären 3
1.013
63
48,238
2
0
0
DSV Rodgau Arrows III - DC Cartoon Gießen 2
1.531
85
54,035
4
0
0
Golden Warriors - DSV Rodgau Arrows III
879
59
44,695
2
0
0
DSV Rodgau Arrows III - Wizards 2
1.078
66
49,000
2
0
0
DSV Rodgau Arrows III - SSG Langen GUDE-Darter
872
57
45,895
1
0
0
DSV Rodgau Arrows III - DC Gassebub
1.255
78
48,269
1
1
0
DSV Rodgau Arrows III - DSV Hanau
1.078
72
44,917
2
0
0
Gesamt:
12.605
805
46,975
20
1
0