:select max(year) year from season_meta:
:select year from season_meta where id = 4:
:select year from season_meta where id = 4:
SÆSON 2007 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 =4 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 102 2 65 3 63 4 49
2 1 139 4 74 2 112 3 110
3 4 58 1 95 3 75 2 80
4 3 74 2 86 4 67 1 90
5 2 94 3 92 4 84 1 145
6
Samlet 2 467 3 412 4 401 1 474