: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 = 83:
RUNDE 5 (11-10-2020/RTP) 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 =83 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 7 28 4 18 7 3 14 14 2 11 21 
2. Carcassonne 1 67 35 4 42 9 2 62 26 3 50 18 
3. Quiz Zone Stories 4 7 6 1 39 24 3 30 12 2 31 18 
4. Exploding Kittens 4 11 6 2 9 16 4 11 6 2 9 16 
5. 10.000 1 10.150 7 3 6.400 4 4 5.550 2 2 6.550 5 
6. Kingdoms 2 246 12 4 208 4 3 243 8 1 248 16 
  Samlet 2 94 4 64 3 68 2 94