:select max(year) year from season_meta:
:select year from season_meta where id = 1:
:select year from season_meta where id = 1:
SÆSON 2004 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 =1 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 24 2 34 1 47 3 25
2 1 50 2 46 4 35 3 39
3 2 43 2 43 4 33 4 33
4 1 59 2 57 4 43 3 49
5 3 43 4 33 1 58 2 54
6
Samlet 1 219 3 213 2 216 4 200