:select max(year) year from season_meta:
:select year from season_meta where id = 16:
:select year from season_meta where id = 16:
SÆSON 2019 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 =16 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 1 119 3 68 4 59 2 100
2 3 72 1 119 2 110 4 55
3 3 89 1 125 4 66 2 94
4 1 132 4 58 3 97 2 109
5 2 94 4 64 3 68 2 94
6 4 56 3 82 1 118 3 82
Samlet 1 562 4 516 3 518 2 534