:select max(year) year from season_meta:
:select year from season_meta where id = 14:
:select year from season_meta where id = 14:
SÆSON 2017 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 =14 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 76 4 65 1 91 2 79
2 2 90 4 66 1 91 3 80
3 3 60 1 136 4 58 2 118
4 3 113 1 140 4 75 2 135
5 4 96 2 125 4 96 1 144
6 3 67 1 120 2 84 4 65
Samlet 3 502 1 652 4 495 2 621