:select max(year) year from season_meta:
:select year from season_meta where id = 10:
:select year from season_meta where id = 10:
SÆSON 2013 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 =10 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 3 79 4 62 2 87 1 103
2 4 59 2 74 3 63 1 100
3 2 126 1 134 4 58 3 110
4 3 99 2 100 4 84 1 114
5 4 59 1 88 3 73 2 83
6
Samlet 3 422 2 458 4 365 1 510