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

Wolfgang Herzog
Statistik 2003
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
1.461
108
40,583
38,778
0
0
0
DC 1984 Lebfritz 2 - DV Wirtheim 2
1.499
117
38,436
50,444
2
0
0
DC 1984 Lebfritz 2 - DC Florstadt 2
3.001
195
46,169
50,833
2
2
0
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
2.116
136
46,676
48,533
5
0
0
DV Wirtheim 2 - DC 1984 Lebfritz 2
1.831
110
49,936
47,000
2
0
0
DC 1984 Lebfritz 2 - Heart of Steel
2.429
206
35,374
52,400
2
1
0
DC 1984 Lebfritz 2 - DC Morgensonne Bad Orb
1.499
98
45,888
52,444
3
0
0
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
1.760
138
38,261
29,083
1
0
0
DC 1984 Lebfritz 2 - DC Logo 2
1.002
78
38,538
33,333
0
0
0
DC 1984 Lebfritz 2 - DC Hotzenplotz 3
2.166
148
43,905
45,933
3
0
0
DC 1984 Lebfritz 2 - DC Flintstones
2.461
192
38,453
55,867
1
1
0
DC 1984 Lebfritz 2 - DC Tigers
1.862
168
33,250
54,583
4
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 4
1.332
92
43,435
36,111
1
0
0
Gesamt:
24.419
1.786
41,017
46,949
26
4
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
660
54
36,667
0
0
0
DC 1984 Lebfritz 2 - DV Wirtheim 2
1.450
81
53,704
3
0
0
DC 1984 Lebfritz 2 - DC Florstadt 2
477
69
20,739
1
0
0
DC 1984 Lebfritz 2 - DC 1984 Lebfritz 1
878
45
58,533
3
0
0
DV Wirtheim 2 - DC 1984 Lebfritz 2
663
48
41,438
2
0
0
DC 1984 Lebfritz 2 - Heart of Steel
753
61
37,033
0
0
0
DC 1984 Lebfritz 2 - DC Morgensonne Bad Orb
1.305
106
36,934
1
0
0
DC 1984 Lebfritz 1 - DC 1984 Lebfritz 2
509
33
46,273
1
0
0
DC 1984 Lebfritz 2 - DC Logo 2
770
47
49,149
0
0
0
DC 1984 Lebfritz 2 - DC Hotzenplotz 3
632
35
54,171
2
0
0
DC 1984 Lebfritz 2 - DC Flintstones
649
35
55,629
0
1
0
DC 1984 Lebfritz 2 - DC Tigers
781
43
54,488
2
0
0
DC 1984 Lebfritz 2 - DC Bruchköbel 4
335
30
33,500
0
0
0
Gesamt:
9.862
687
43,066
15
1
0