: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 = 1:
RUNDE 1 (01-02-2004/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 =1 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 6 5 4 12 1 2 8 3 3 10 2 
2. Matador 2 55.450 9 4 6.600 3 1 68.150 15 3 33.000 6 
3. Den store filmquiz 4 3 3 2 5 9 1 5 15 3 5 6 
4. Trivial Pursuit 4 0 3 1 5 15 2 3 9 3 2 6 
5. Davoserjazz 1 61 3 4 68 1 3 62 2 1 61 3 
6. 10.000 4 0 1 1 10.350 5 2 8.300 3 3 8.100 2 
  Samlet 4 24 2 34 1 47 3 25