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

Jens Orth
Statistik 2017
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Arrows 1 - DC 1984 Lebfritz
2.496
218
34,349
49,667
1
0
0
DC 1984 Lebfritz - Starbulls 2
2.391
163
44,006
36,933
3
0
0
DC 1984 Lebfritz - DC St. Patrick
1.988
126
47,333
62,250
2
0
0
Golden Warriors 2 - DC 1984 Lebfritz 1
1.731
116
44,767
43,833
1
0
0
Arrows 5 - DC 1984 Lebfritz
2.353
175
40,337
46,200
1
1
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.503
122
36,959
50,667
0
0
1
DC 1984 Lebfritz - DC Logo
1.979
156
38,058
46,250
2
0
0
DC 1984 Lebfritz - DC Logo
1.423
93
45,903
34,333
1
0
0
DC 1984 Lebfritz - DSV Rodgau Arrows 5
1.980
140
42,429
44,500
3
0
0
DC Wetterau Pokal Team 2 - DC 1984 Lebfritz
1.140
72
47,500
47,778
0
0
0
DC 1984 Lebfritz - Golden Warriors 2
1.503
122
36,959
50,222
1
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.249
96
39,031
45,556
0
0
0
DC 1984 Lebfritz - DC Bruchköbel 2
1.958
150
39,160
39,500
2
1
0
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
2.469
175
42,326
44,467
3
0
0
Gesamt:
26.163
1.924
40,795
45,770
20
2
1
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz - Starbulls 2
897
75
35,880
0
0
0
DC 1984 Lebfritz - DC St. Patrick
748
56
40,071
1
0
0
Golden Warriors 2 - DC 1984 Lebfritz 1
985
70
42,214
1
0
0
Arrows 5 - DC 1984 Lebfritz
1.123
74
45,527
2
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.085
65
50,077
2
0
0
DC 1984 Lebfritz - DC Logo
1.088
69
47,304
0
2
0
DC Wetterau Pokal Team 2 - DC 1984 Lebfritz
1.065
66
48,409
1
1
0
DC 1984 Lebfritz - Golden Warriors 2
1.199
93
38,677
0
1
0
DC 1984 Lebfritz - DC Hotzenplotz 3
908
69
39,478
1
0
0
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
1.280
87
44,138
1
1
0
Gesamt:
10.378
724
43,003
9
5
0