: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 = 80:
RUNDE 3 (28-10-2019/LMD) 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 =80 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. Hjertefri 4 107 8 2 73 22 3 88 15 1 18 29 
2. Sequence 4 1 4 1 3 15 4 1 4 4 1 4 
3. Liverpool 1 140 56 2 250 42 4 290 14 3 270 28 
4. Exploding Kittens 4 9 7 2 12 19 3 10 13 1 13 26 
5. Ticket to Ride Europe 3 108 14 1 124 27 2 112 20 4 84 7 
  Samlet 3 89 1 125 4 66 2 94