:select max(year) year from season_meta:
:select year from season_meta where id = 5:
:select year from season_meta where id = 5:
SÆSON 2008 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 =5 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 103 1 107 4 56 3 71
2 1 117 3 91 4 81 2 101
3 2 81 1 84 3 79 4 67
4 4 48 2 95 1 119 3 72
5 4 89 1 103 2 97 3 92
6
Samlet 2 438 1 480 3 432 4 403