:select max(year) year from season_meta:
:select year from season_meta where id = 15:
:select year from season_meta where id = 15:
SÆSON 2018 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 =15 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 78 4 76 2 99 1 109
2 4 59 1 112 2 88 3 84
3 4 83 3 87 3 87 1 101
4 3 90 1 126 2 96 4 75
5 3 82 1 119 2 94 4 63
6 4 71 3 85 2 105 1 141
Samlet 4 463 1 605 3 569 2 573