:select year from season_meta where id = 15:
SÆSON 2018 OVERBLIK
Runde | FFJ | LMD | RTP | SAC |
Placering | SpilPoint | Point | Placering | SpilPoint | Point | Placering | SpilPoint | Point | Placering | SpilPoint | Point |
:select b.id, b.round_number, a.season_meta_id, sum(a.ffj_points) ffj, sum(a.lmd_points) lmd, sum(a.rtp_points) rtp, sum(a.sac_points) sac from round_meta b left join game_result a on a.round_meta_id = b.id where b.season_meta_id =15 group by b.id, b.round_number order by b.id, b.round_number :
1 | 3 | | 78 | 4 | | 76 | 2 | | 99 | 1 | | 109 |
2 | 4 | | 59 | 1 | | 112 | 2 | | 88 | 3 | | 84 |
3 | 4 | | 83 | 3 | | 87 | 3 | | 87 | 1 | | 101 |
4 | 3 | | 90 | 1 | | 126 | 2 | | 96 | 4 | | 75 |
5 | 3 | | 82 | 1 | | 119 | 2 | | 94 | 4 | | 63 |
6 | 4 | | 71 | 3 | | 85 | 2 | | 105 | 1 | | 141 |
|
Samlet | 4 | | 71 | 3 | | 85 | 2 | | 105 | 1 | | 141 |
Warning: Undefined array key "logged_in" in /customers/8/b/5/sparbonde.dk/httpd.www/round_overview.php on line 164