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

Daniel Thölken
Statistik 2004
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
1.467
96
45,844
44,444
3
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 5
2.127
137
46,577
49,400
3
0
0
DC 1984 Lebfritz 2 - DC St. Patrick
2.299
161
42,839
54,333
2
0
0
DC 1984 Lebfritz 2 - DV Wirtheim 2
2.004
131
45,893
54,667
6
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 3
2.231
148
45,223
50,533
4
0
0
DC 1984 Lebfritz - DC Logo 2
1.002
65
46,246
37,833
1
1
0
DC 1984 Lebfritz - DC Wächtersbach eV
1.002
75
40,080
40,833
0
0
0
DC 1984 Lebfritz - DC Flintstones
1.482
104
42,750
50,333
1
0
0
DC 1984 Lebfritz - The Baldeagles
1.002
69
43,565
48,167
1
0
0
DC 1984 Lebfritz - DC Bruchköbel 4
1.501
106
42,481
48,000
1
0
0
DC 1984 Lebfritz - DV Wirtheim 2
1.002
67
44,866
53,167
1
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.002
60
50,100
64,667
1
0
0
Gesamt:
18.121
1.219
44,596
50,202
24
1
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
1.044
72
43,500
1
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 5
1.281
90
42,700
0
1
0
DC 1984 Lebfritz 2 - DC St. Patrick
548
27
60,889
1
0
0
DC 1984 Lebfritz 2 - DV Wirtheim 2
450
31
43,548
1
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 3
532
31
51,484
0
0
0
DC 1984 Lebfritz - DC Logo 2
594
39
45,692
2
0
0
DC 1984 Lebfritz - DC Wächtersbach eV
862
58
44,586
1
0
0
DC 1984 Lebfritz - DC Flintstones
767
54
42,611
2
0
0
DC 1984 Lebfritz - The Baldeagles
554
42
39,571
1
0
0
DC 1984 Lebfritz - DC Bruchköbel 4
492
35
42,171
0
0
0
DC 1984 Lebfritz - DV Wirtheim 2
892
57
46,947
1
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
542
37
43,946
0
0
0
Gesamt:
8.558
573
44,806
10
1
0