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

Peter Wengel
Statistik 2017
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Arrows 5 - DSV Rodgau Arrows 4
1.953
142
41,261
46,917
3
0
0
Arrows 5 - DSV Hanau
1.072
99
32,485
32,778
0
0
0
Arrows 5 - DC 1984 Lebfritz
1.298
129
30,186
33,444
2
0
0
Arrows 5 - DC Bulldogs 2
2.485
188
39,654
56,267
5
0
0
Arrows 5 - Starbulls 2
2.282
163
42,000
42,867
0
0
0
DC 1984 Lebfritz - DSV Rodgau Arrows 5
1.910
140
40,929
37,667
2
0
0
Arrows 5 - Golden Warriors 2
1.997
123
48,707
72,333
0
1
0
Arrows 5 - DC Bruchköbel 2
1.503
107
42,140
51,444
0
0
0
Arrows 5 - DC Bulldogs 2
1.952
154
38,026
39,333
0
0
0
Gesamt:
16.452
1.245
39,643
46,472
12
1
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Arrows 5 - DSV Rodgau Arrows 4
1.821
117
46,692
2
0
0
Arrows 5 - DSV Hanau
1.083
67
48,493
2
0
0
Arrows 5 - DC 1984 Lebfritz
1.014
75
40,560
1
0
0
Arrows 5 - DC Bulldogs 2
1.365
110
37,227
1
0
0
Arrows 5 - Starbulls 2
687
39
52,846
1
0
0
DC 1984 Lebfritz - DSV Rodgau Arrows 5
604
42
43,143
0
0
0
Arrows 5 - Golden Warriors 2
1.029
66
46,773
1
0
0
Arrows 5 - DC Bruchköbel 2
804
54
44,667
1
0
0
Arrows 5 - DC Bulldogs 2
783
54
43,500
0
0
0
Gesamt:
9.190
624
44,183
9
0
0