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

Andre Michel

Statistik 2018 Einzel Paarung Gesamtscore Gesamtdarts 3-Dart Average First 9 Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 1.990 106 56,321 63,500 0 3 0 Arrows 5 - DC Hotzenplotz 2 1.503 87 51,828 58,667 0 1 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 1.503 72 62,625 56,778 4 0 0 DC 1984 Lebfritz - DC Hotzenplotz 2 1.503 62 72,726 78,000 5 1 0 DC Hotzenplotz 2 - Bären 3 1.503 76 59,329 74,111 4 1 0 Seenbachdarter 1 - DC Hotzenplotz 2 1.992 109 54,826 81,750 3 0 1 DC Hotzenplotz 2 - Flying Eagles 6 1.859 92 60,620 57,417 2 1 0 Arrows 1 - DC Hotzenplotz 1 1.979 94 63,160 68,667 3 1 1 DC Hotzenplotz 2 - Seenbachdarter 1 1.998 105 57,086 74,583 7 0 0 Gesamt: 15.830 803 59,141 68,323 28 8 2   Doppel Paarung Gesamtscore Gesamtdarts 3-Dart Average 100+ 140+ 180 Starbulls 2 - DC Hotzenplotz 2 932 45 62,133 3 0 0 Arrows 5 - DC Hotzenplotz 2 956 45 63,733 2 0 0 DC Hotzenplotz 2 - DC Hotzenplotz 3 1.299 87 44,793 2 0 0 DC 1984 Lebfritz - DC Hotzenplotz 2 800 48 50,000 2 0 0 DC Hotzenplotz 2 - Bären 3 1.143 52 65,942 5 0 0 Seenbachdarter 1 - DC Hotzenplotz 2 1.001 61 49,230 1 0 0 DC Hotzenplotz 2 - Flying Eagles 6 977 52 56,365 2 0 0 Arrows 1 - DC Hotzenplotz 1 882 51 51,882 1 0 0 DC Hotzenplotz 2 - Seenbachdarter 1 1.653 75 66,120 7 0 0 Gesamt: 9.643 516 56,064 25 0 0