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

Siegfried Steiner
Statistik 2010
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC 1984 Lebfritz - Großauheim 05
1.474
117
37,795
51,444
4
0
0
DC 1984 Lebfritz - Made of Steel
1.065
75
42,600
48,556
2
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.971
171
34,579
54,500
1
0
0
DC 1984 Lebfritz - Die Tattonis
1.678
122
41,262
64,417
1
0
0
DC 1984 Lebfritz - DC Tigers
1.503
111
40,622
42,667
1
0
0
DC 1984 Lebfritz - DC St. Patrick
1.944
190
30,695
36,417
0
0
0
DC 1984 Lebfritz - DSV Rodgau Arrows II
1.503
93
48,484
32,778
2
0
0
DC 1984 Lebfritz - DV Wirtheim
1.047
93
33,774
43,556
0
0
0
DC 1984 Lebfritz - Die Tattonis
2.114
160
39,638
41,867
4
0
0
DC 1984 Lebfritz - DC St. Patrick
1.959
157
37,433
31,833
1
0
0
DC 1984 Lebfritz - DC Bruchköbel 3
2.130
153
41,765
39,867
1
0
0
DC 1984 Lebfritz - DC Cartoon Gießen
1.100
66
50,000
52,889
1
0
0
DC 1984 Lebfritz - Starbulls 1
1.338
93
43,161
45,889
1
0
0
Gesamt:
20.826
1.601
39,024
44,908
19
0
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz - Großauheim 05
638
48
39,875
1
0
0
DC 1984 Lebfritz - Made of Steel
702
60
35,100
0
0
0
DC 1984 Lebfritz - DC Hotzenplotz 3
1.140
90
38,000
1
0
0
DC 1984 Lebfritz - Die Tattonis
865
54
48,056
1
0
0
DC 1984 Lebfritz - DC Tigers
1.140
99
34,545
2
0
0
DC 1984 Lebfritz - DC St. Patrick
916
67
41,015
0
0
0
DC 1984 Lebfritz - DSV Rodgau Arrows II
854
84
30,500
0
0
0
DC 1984 Lebfritz - DV Wirtheim
711
63
33,857
0
0
0
DC 1984 Lebfritz - Die Tattonis
961
84
34,321
0
0
0
DC 1984 Lebfritz - DC St. Patrick
570
56
30,536
0
0
0
DC 1984 Lebfritz - DC Bruchköbel 3
558
51
32,824
0
0
0
DC 1984 Lebfritz - DC Cartoon Gießen
699
54
38,833
0
0
0
DC 1984 Lebfritz - Starbulls 1
882
63
42,000
1
0
0
Gesamt:
10.636
873
36,550
6
0
0