:select max(year) year from season_meta:
:select year from season_meta where id = 11:
:select year from season_meta where id = 11:
SÆSON 2014 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 =11 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
2 1 106 2 100 4 43 3 86
1 2 93 1 108 4 33 3 67
3 4 50 3 57 1 113 2 104
4 4 68 2 79 1 104 4 68
5 3 82 1 130 4 67 2 92
6 2 80 3 76 4 70 1 134
Samlet 3 479 2 550 4 430 1 551