: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 = 79:
RUNDE 2 (15-09-2019/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 =79 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 3 14 10 2 8 15 1 -1 20 4 19 5 
2. Ticket to Ride Europe 2 118 32 1 124 43 3 99 22 4 87 11 
3. Exploding Kittens 2 2 5 3 3 3 1 1 6 4 4 2 
4. Exploding Kittens 3 3 3 2 2 4 4 4 2 1 1 5 
5. Alt Besat 2 3 3 4 5 1 3 4 2 1 0 4 
6. Alt Besat 3 3 2 2 2 2 4 8 1 1 0 3 
7. Quiz Battle 4 6 9 1 0 35 2 1 26 4 6 9 
8. Hjertefri 4 102 8 3 79 16 1 78 31 3 79 16 
  Samlet 3 72 1 119 2 110 4 55