: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 = 78:
RUNDE 1 (15-09-2019/FFJ) 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 =78 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. West 4 -23 7 3 7 14 3 7 14 1 9 27 
2. Ticket to Ride Europe 1 102 40 2 101 30 4 40 10 3 95 20 
3. 10.000 1 10.700 9 2 7.900 7 4 2.550 3 3 6.500 5 
4. Liverpool 1 150 50 4 505 13 3 370 25 2 290 38 
5. Kabale 1 11 13 4 15 4 3 14 7 2 13 10 
  Samlet 1 119 3 68 4 59 2 100