:select max(year) year from season_meta:
:select year from season_meta where id = 3:
:select year from season_meta where id = 3:
SÆSON 2006 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 =3 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 2 25 2 25 4 21 4 21
2 1 33 2 22 3 14 4 9
3 4 5 1 25 3 8 2 21
4 1 27 2 21 4 12 3 14
5 3 41 1 45 2 44 4 32
6
Samlet 2 131 1 138 3 99 4 97