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

Janosch Hensel
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
DC 1984 Lebfritz - DC Logo
2.402
147
49,020
56,533
4
0
0
Arrows 5 - DC Sterbfritz
1.503
99
45,545
56,556
1
0
0
DC Hotzenplotz 3 - DC 1984 Lebfritz
1.480
67
66,269
73,889
2
0
1
DC 1984 Lebfritz - DC Bulldogs 2
1.503
76
59,329
59,667
2
1
0
Arrows 7 - DC 1984 Lebfritz
1.988
143
41,706
53,667
1
0
0
DC 1984 Lebfritz - DC Starbulls 1
2.495
131
57,137
53,067
0
0
0
DC 1984 Lebfritz - Blackpool Arrows
2.764
130
63,785
60,944
0
0
0
DC 1984 Lebfritz - DC Hotzenplotz
2.004
96
62,625
61,333
0
0
0
DC 1984 Lebfritz - Nachwuchstalente
2.004
113
53,204
73,417
0
0
0
Arrows 1 - DC Sterbfritz
5.343
273
58,714
69,515
8
3
1
DC 1984 Lebfritz - Eintracht Frankfurt
3.978
186
64,161
74,917
9
1
0
DC 1984 Lebfritz 1 - SSG Langen GUDE-Darter 1
1.503
101
44,644
60,222
0
0
0
DC 1984 Lebfritz 1 - DC Cartoon Gießen 2
1.948
81
72,148
72,917
1
2
0
DC 1984 Lebfritz 1 - Wizards 2
1.980
119
49,916
69,833
2
0
0
Gesamt:
32.895
1.762
56,007
64,975
30
7
2
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
DC 1984 Lebfritz - DC Logo
1.028
41
75,220
2
1
0
Arrows 5 - DC Sterbfritz
740
42
52,857
3
0
0
DC Hotzenplotz 3 - DC 1984 Lebfritz
879
46
57,326
0
0
0
DC 1984 Lebfritz - DC Bulldogs 2
793
56
42,482
0
0
0
Arrows 7 - DC 1984 Lebfritz
888
59
45,153
1
0
0
DC 1984 Lebfritz - Blackpool Arrows
696
34
61,412
0
0
0
Arrows 1 - DC Sterbfritz
438
24
54,750
0
0
0
DC 1984 Lebfritz - Eintracht Frankfurt
818
35
70,114
1
0
1
DC 1984 Lebfritz 1 - SSG Langen GUDE-Darter 1
1.048
67
46,925
1
0
0
DC 1984 Lebfritz 1 - DC Cartoon Gießen 2
1.326
59
67,424
1
3
0
DC 1984 Lebfritz 1 - Wizards 2
1.103
49
67,531
2
0
0
Gesamt:
9.757
512
57,170
11
4
1