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

Jörg Müller
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC Hotzenplotz 1 - Starbulls 1
2.445
144
50,938
57,200
3
0
0
Starbulls 1 - DC Cartoon Gießen
1.187
84
42,393
64,333
1
0
0
Starbulls - Pirates of Darts
1.503
96
46,969
64,444
3
1
0
Starbulls 1 - TSV Ginnheim
1.031
60
51,550
55,889
1
1
0
DC Wetterau 1 - Starbulls 1
1.125
66
51,136
58,667
2
1
0
Starbulls 1 - Arrows 1
1.268
72
52,833
51,889
0
0
0
Starbulls 1 - Marburg 3
1.183
84
42,250
42,222
0
0
0
Arrows 1 - DC Starbulls 1
4.229
210
60,414
56,000
4
2
0
Starbulls 1 - Mighty Mosquitos 1
1.503
79
57,076
59,111
2
2
0
Starbulls 1 - Unicorn Hessen 1
1.988
102
58,471
51,167
4
0
0
Starbulls 1 - DC Bulldogs 1
2.275
155
44,032
55,267
0
0
0
Starbulls 1 - DC 1984 Lebfritz 1
2.316
146
47,589
50,400
1
0
0
Gesamt:
22.053
1.298
50,970
55,361
21
7
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC Hotzenplotz 1 - Starbulls 1
1.267
66
57,591
1
0
0
Starbulls 1 - DC Cartoon Gießen
696
36
58,000
0
0
0
Starbulls - Pirates of Darts
539
48
33,688
1
0
0
Starbulls 1 - TSV Ginnheim
965
48
60,313
2
0
0
DC Wetterau 1 - Starbulls 1
940
65
43,385
1
0
0
Starbulls 1 - Arrows 1
994
59
50,542
1
0
0
Starbulls 1 - Marburg 3
1.097
69
47,696
2
0
0
Arrows 1 - DC Starbulls 1
481
24
60,125
1
0
0
Starbulls 1 - Mighty Mosquitos 1
1.023
48
63,938
3
0
0
Starbulls 1 - Unicorn Hessen 1
1.167
66
53,045
1
0
0
Starbulls 1 - DC Bulldogs 1
891
50
53,460
1
1
0
Starbulls 1 - DC 1984 Lebfritz 1
806
51
47,412
0
0
0
Gesamt:
10.866
630
51,743
14
1
0