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

Sokratis Paschalopoulos
Statistik 2019
Einzel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
First 9 Average
100+
140+
180
Golden Warriors 2 - DC Krone Hattersheim 2
2.333
140
49,993
45,467
2
0
0
Golden Warriors 2 - Oberursel 1
1.503
99
45,545
60,333
2
0
0
Golden Warriors 2 - SSG Gude Darter Langen
1.441
93
46,484
51,000
0
0
0
Golden Warriors 2 - Dreieichenhain
1.885
124
45,605
54,250
1
0
0
Golden Warriors 2 - Götzenhain
2.485
208
35,841
43,000
0
0
0
Golden Warriors 2 - DC St. Patrick
2.381
154
46,383
48,733
2
0
0
Golden Warriors 2 - DC Gassebub
2.002
143
42,000
67,667
3
0
0
Golden Warriors 2 - DC Bruchköbel 2
2.458
158
46,671
59,933
0
1
0
Golden Warriors 2 - DSV Hanau
2.295
142
48,486
57,533
2
0
0
Golden Warriors 2 - Arrows 5
1.231
78
47,346
52,889
1
0
0
Golden Warriors 2 - DC Hotzenplotz 2
2.491
221
33,814
47,667
5
0
0
Gesamt:
22.505
1.560
43,279
53,021
18
1
0
 
Doppel
Paarung
Gesamtscore
Gesamtdarts
3-Dart Average
100+
140+
180
Golden Warriors 2 - Oberursel 1
716
39
55,077
1
0
0
Golden Warriors 2 - SSG Gude Darter Langen
932
75
37,280
1
0
0
Golden Warriors 2 - Dreieichenhain
1.304
90
43,467
0
0
0
Golden Warriors 2 - Götzenhain
1.064
68
46,941
0
1
0
Golden Warriors 2 - Dartschlümpfe Großenlüder
599
45
39,933
1
0
0
Golden Warriors 2 - DC St. Patrick
652
45
43,467
0
0
0
Golden Warriors 2 - DC Gassebub
629
45
41,933
0
0
0
Golden Warriors 2 - DC Bruchköbel 2
987
72
41,125
0
0
0
Golden Warriors 2 - DSV Hanau
1.334
84
47,643
1
1
0
Golden Warriors 2 - Arrows 5
1.356
93
43,742
1
0
0
Golden Warriors 2 - DC Hotzenplotz 2
987
69
42,913
1
0
0
Gesamt:
10.560
725
43,697
6
2
0