:select date_format(rm.round_date, '%d-%m-%Y') round_date, rm.round_number, p.name_short from round_meta rm, player p where rm.player_id = p.id and rm.id = 82:
RUNDE 4 (30-11-2019/SAC) OVERBLIK
:select a.id, b.id game_id, b.name, a.ffj_result, a.ffj_game_points, a.ffj_points, a.lmd_result, a.lmd_game_points, a.lmd_points, a.rtp_result, a.rtp_game_points, a.rtp_points, a.sac_result, a.sac_game_points, a.sac_points from game_result a, game b, round_meta c where a.round_meta_id =82 and a.game_id = b.id and a.round_meta_id = c.id order by a.id :
==> ==> ==> ==> ==> ==> ==>
  Spil FFJ LMD RTP SAC  
  Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point Placering SpilPoint Point  
1. Sparbonde 1 1 19 3 11 10 2 3 15 4 15 5 
2. UNO 4 1 5 4 1 5 4 1 5 1 3 18 
3. Agurk 3 22 4 2 6 6 4 35 2 1 0 8 
4. Hjertefri 2 81 20 4 116 7 3 88 13 1 58 26 
5. Ave Cæsar 1 14 25 3 12 13 4 5 7 2 13 19 
6. Blind Napoleon 1 15 42 4 25 11 2 18 32 3 24 21 
7. Kabale 2 29 17 4 32 6 1 19 23 3 30 12 
  Samlet 1 132 4 58 3 97 2 109