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

Glen Hummel

Statistik 2019 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 DC Hotzenplotz 1 - Eintracht Frankfurt 1 1.876 92 61,174 63,917 3 1 0 DC Hotzenplotz 1 - Starbulls 1 2.212 114 58,211 69,333 6 0 0 DC Wetterau 1 - DC Hotzenplotz 1 1.358 66 61,727 64,556 2 2 0 DC Hotzenplotz 1 - Arrows 1 2.089 100 62,670 57,267 4 2 0 DC Hotzenplotz 1 - DC Cartoon Gießen 1.503 59 76,424 82,333 5 2 0 DC Hotzenplotz 1 - DC Cartoon Gießen 2.248 115 58,643 58,867 4 1 0 DC Hotzenplotz 1 - Bären2 1.354 69 58,870 68,778 2 1 0 Arrows 1 - DC Hotzenplotz 1 1.176 66 53,455 56,667 2 0 0 DC Hotzenplotz 1 - SC 07 Bürgel 1 1.503 69 65,348 86,667 1 1 1 Gesamt: 15.319 750 61,276 66,471 29 10 1   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 DC Hotzenplotz 1 - Eintracht Frankfurt 1 1.156 51 68,000 3 0 1 DC Hotzenplotz 1 - Starbulls 1 1.042 60 52,100 3 0 0 DC Wetterau 1 - DC Hotzenplotz 1 1.129 51 66,412 2 1 0 DC Hotzenplotz 1 - Arrows 1 1.045 51 61,471 1 0 0 DC Hotzenplotz 1 - DC Cartoon Gießen 1.011 55 55,145 3 1 0 DC Hotzenplotz 1 - DC Cartoon Gießen 1.103 47 70,404 4 0 0 DC Hotzenplotz 1 - Bären2 1.107 54 61,500 2 1 0 Arrows 1 - DC Hotzenplotz 1 1.249 74 50,635 3 0 0 DC Hotzenplotz 1 - SC 07 Bürgel 1 1.050 43 73,256 3 0 1 Gesamt: 9.892 486 61,062 24 3 2