:select max(year) year from season_meta:
:select year from season_meta where id = 12:
:select year from season_meta where id = 12:
SÆSON 2015 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 =12 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 4 72 2 96 3 74 1 99
2 2 86 3 52 4 42 1 92
3 4 44 1 108 3 63 2 101
4 2 79 3 67 4 62 1 96
5 1 82 2 75 4 71 3 72
6 2 91 4 84 3 85 1 98
Samlet 3 454 2 482 4 397 1 558