:select max(year) year from season_meta:
:select year from season_meta where id = 6:
:select year from season_meta where id = 6:
SÆSON 2009 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 =6 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 112 3 88 4 83 1 140
2 4 67 1 129 3 74 2 125
3 3 91 2 99 1 105 4 55
4 1 107 4 75 3 89 2 99
5
Samlet 3 377 2 391 4 351 1 419