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)=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 Wengel
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Arrows 5 - Dartschlümpfe Großenlüder
1.647
153
32,294
32,417
1
0
0
Arrows 5 - DC Bruchköbel 2
2.487
225
33,160
48,267
0
0
0
Arrows 5 - DC Sterbfritz
1.069
75
42,760
36,111
0
0
0
Arrows 5 - DC Logo
2.496
218
34,349
51,000
1
0
1
Arrows 5 - DC Bulldogs 2
1.688
125
40,512
32,500
0
0
0
Arrows 3 - DC Krone Hattersheim 3
1.698
146
34,890
37,167
0
0
0
Arrows 3 - Krone 4
1.914
126
45,571
47,083
0
0
0
Arrows 3 - Teutonia Hausen 1
2.213
191
34,759
37,467
0
0
0
Arrows 3 - SSG Langen GUDE-Darter
2.301
170
40,606
39,333
0
0
0
Arrows 3 - DC Oberursel
1.994
148
40,419
43,167
3
0
0
Arrows 3 - DC Krone Hattersheim 2
1.957
141
41,638
56,417
1
2
0
Gesamt:
21.464
1.718
37,481
42,206
6
2
1
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Arrows 5 - Dartschlümpfe Großenlüder
1.021
96
31,906
0
0
0
Arrows 5 - DC Bruchköbel 2
679
46
44,283
0
0
0
Arrows 5 - DC Sterbfritz
1.073
60
53,650
1
0
0
Arrows 5 - DC Logo
975
77
37,987
0
0
0
Arrows 5 - DC Bulldogs 2
923
66
41,955
1
0
0
Arrows 3 - DC Krone Hattersheim 3
757
50
45,420
0
0
0
Arrows 3 - Krone 4
556
45
37,067
0
0
0
Arrows 3 - Teutonia Hausen 1
701
48
43,813
1
0
0
Arrows 3 - SSG Langen GUDE-Darter
1.104
84
39,429
0
0
0
Arrows 3 - DC Oberursel
682
48
42,625
0
0
0
Gesamt:
8.471
620
40,989
3
0
0