:select max(year) year from season_meta:
:select year from season_meta where id = 2:
:select year from season_meta where id = 2:
SÆSON 2005 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 =2 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 1 26 4 17 4 17 2 24
2 1 48 4 43 3 47 3 47
3 3 38 1 47 4 37 2 46
4 3 41 4 30 2 49 1 78
5 4 7 1 24 2 22 3 12
6
Samlet 4 160 3 161 2 172 1 207