:select max(year) year from season_meta:
:select year from season_meta where id = 9:
:select year from season_meta where id = 9:
SÆSON 2012 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 =9 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 54 1 94 3 76 2 81
2 2 95 3 75 4 69 1 101
3 4 51 1 96 3 59 2 73
4 2 120 3 82 4 49 2 120
5 3 82 1 97 2 96 4 69
6
Samlet 3 402 2 444 4 349 2 444