:select max(year) year from season_meta:
:select year from season_meta where id = 13:
:select year from season_meta where id = 13:
SÆSON 2016 OVERBLIK
: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 =13 group by b.id, b.round_number order by b.id, b.round_number :
Runde FFJ LMD RTP SAC
Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point
1 3 99 2 100 4 84 1 114
2 2 94 4 53 3 69 1 107
3 4 69 1 96 2 87 3 71
4 4 47 2 100 3 81 1 132
5 4 81 1 126 3 82 2 94
6 1 120 3 96 4 89 2 114
Samlet 3 510 2 571 4 492 1 632