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 = 212 AND ls.darts>0 AND lrr.round = 'E' AND lg.finish = 1 AND Year(lg.mdate)=2004 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

Dieter Euler
Statistik 2004
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
1.407
106
39,821
45,778
1
0
0
DC 1984 Lebfritz 1 - DV Wirtheim 2
2.922
202
43,396
58,611
3
0
1
DC 1984 Lebfritz 1 - DC Bruchköbel 3
1.465
89
49,382
46,556
2
0
0
DC 1984 Lebfritz 1 - DC Tigers
1.002
71
42,338
54,500
2
0
0
DC 1984 Lebfritz 1 - DC Logo 2
1.002
77
39,039
46,000
1
0
0
DC 1984 Lebfritz 1 - DC Hotzenplotz 3
2.420
175
41,486
40,733
4
0
0
DC 1984 Lebfritz - DC Wächtersbach eV
903
66
41,045
45,500
2
0
0
DC 1984 Lebfritz - DC Flintstones
885
69
38,478
30,167
0
0
0
Gesamt:
12.006
855
42,126
47,387
15
0
1
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
416
49
25,469
0
0
0
DC 1984 Lebfritz 1 - DV Wirtheim 2
316
30
31,600
0
0
0
DC 1984 Lebfritz 1 - DC Bruchköbel 3
433
30
43,300
0
1
0
DC 1984 Lebfritz 1 - DC Tigers
1.344
113
35,681
1
0
0
DC 1984 Lebfritz 1 - DC Logo 2
740
45
49,333
2
0
0
DC 1984 Lebfritz 1 - DC Hotzenplotz 3
738
48
46,125
2
0
0
DC 1984 Lebfritz - DC Wächtersbach eV
551
46
35,935
0
0
0
DC 1984 Lebfritz - DC Flintstones
550
36
45,833
1
0
0
Gesamt:
5.088
397
38,448
6
1
0