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

Peter Spengler
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Golden Warriors 2 - DC Krone Hattersheim 2
1.947
125
46,728
38,750
2
1
0
Golden Warriors 2 - Oberursel 1
1.874
135
41,644
48,250
2
0
0
Golden Warriors 2 - SSG Gude Darter Langen
2.360
178
39,775
48,867
4
0
0
Golden Warriors 2 - Dreieichenhain
1.332
81
49,333
34,444
2
0
0
Golden Warriors 2 - Golden Warriors 2
4.415
360
36,792
42,000
2
0
0
Golden Warriors 2 - Götzenhain
1.942
132
44,136
48,417
1
0
0
Golden Warriors 2 - Dartschlümpfe Großenlüder
1.837
121
45,545
57,083
2
0
0
DC Hotzenplotz 3 - Golden Warriors 2
1.959
156
37,673
48,083
2
0
0
Golden Warriors 2 - DC St. Patrick
1.908
140
40,886
54,333
1
0
0
Golden Warriors 2 - DC Gassebub
1.887
146
38,774
51,833
0
0
0
Golden Warriors 2 - DC Bruchköbel 2
2.288
155
44,284
54,000
4
0
0
Golden Warriors 2 - DSV Hanau
1.940
126
46,190
47,667
1
0
0
Starbulls 2 - Golden Warriors 2
1.503
117
38,538
29,222
0
0
0
Golden Warriors 2 - Arrows 5
3.900
288
40,625
51,583
8
0
0
Golden Warriors 2 - DC Hotzenplotz 2
2.489
169
44,183
56,933
2
0
0
Gesamt:
33.581
2.429
41,475
47,976
33
1
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Golden Warriors 2 - DC Krone Hattersheim 2
1.236
94
39,447
2
0
0
Golden Warriors 2 - Oberursel 1
587
54
32,611
0
0
0
Golden Warriors 2 - SSG Gude Darter Langen
1.413
91
46,582
0
0
0
Golden Warriors 2 - Golden Warriors 2
1.650
90
55,000
0
0
0
Golden Warriors 2 - Götzenhain
1.076
97
33,278
1
0
0
Golden Warriors 2 - Dartschlümpfe Großenlüder
1.399
88
47,693
3
0
0
DC Hotzenplotz 3 - Golden Warriors 2
980
76
38,684
0
0
0
Golden Warriors 2 - DC St. Patrick
1.135
66
51,591
1
0
0
Golden Warriors 2 - DC Gassebub
1.266
108
35,167
1
0
0
Golden Warriors 2 - DC Bruchköbel 2
1.209
76
47,724
1
0
0
Golden Warriors 2 - DSV Hanau
1.023
72
42,625
0
0
0
Starbulls 2 - Golden Warriors 2
1.755
153
34,412
0
0
0
Golden Warriors 2 - Arrows 5
830
63
39,524
0
0
0
Golden Warriors 2 - DC Hotzenplotz 2
719
48
44,938
3
0
0
Gesamt:
16.278
1.176
41,526
12
0
0