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

Harald Rieger
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Golden Warriors 2 - DC Krone Hattersheim 2
2.402
179
40,257
43,800
2
0
0
Golden Warriors 2 - Oberursel 1
1.147
75
45,880
49,667
1
0
0
Golden Warriors 2 - SSG Gude Darter Langen
1.754
131
40,168
43,000
1
0
0
Golden Warriors 2 - Dreieichenhain
2.413
156
46,404
50,667
4
0
1
Golden Warriors 2 - Golden Warriors 2
3.471
253
41,158
45,810
3
0
0
Golden Warriors 2 - Götzenhain
1.503
101
44,644
53,000
1
0
0
DC Hotzenplotz 3 - Golden Warriors 2
2.484
173
43,075
58,467
1
1
0
Golden Warriors 2 - DC St. Patrick
1.940
155
37,548
44,750
2
0
0
Golden Warriors 2 - DC Gassebub
1.421
102
41,794
39,222
1
0
0
Golden Warriors 2 - DC Bruchköbel 2
1.457
96
45,531
47,556
2
1
0
Starbulls 2 - Golden Warriors 2
2.524
174
43,517
38,722
1
0
0
Golden Warriors 2 - DC Hotzenplotz 2
1.417
102
41,676
58,778
3
0
0
Gesamt:
23.933
1.697
42,309
47,320
22
2
1
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Golden Warriors 2 - DC Krone Hattersheim 2
999
75
39,960
1
0
0
Golden Warriors 2 - Oberursel 1
617
42
44,071
0
0
0
Golden Warriors 2 - SSG Gude Darter Langen
841
46
54,848
2
0
0
Golden Warriors 2 - Dreieichenhain
1.224
81
45,333
2
0
0
Golden Warriors 2 - Golden Warriors 2
1.669
86
58,221
0
0
0
Golden Warriors 2 - Götzenhain
1.081
69
47,000
0
0
0
DC Hotzenplotz 3 - Golden Warriors 2
714
43
49,814
1
0
0
Golden Warriors 2 - DC St. Patrick
651
54
36,167
0
0
0
Golden Warriors 2 - DC Gassebub
660
69
28,696
0
0
0
Golden Warriors 2 - DC Bruchköbel 2
497
36
41,417
0
0
0
Starbulls 2 - Golden Warriors 2
501
33
45,545
0
0
0
Golden Warriors 2 - DC Hotzenplotz 2
856
75
34,240
0
0
0
Gesamt:
10.310
709
43,625
6
0
0