: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 = 31:
RUNDE 1 (14-02-2009/SAC) 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 =31 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. Game of Life 4 23.998 11 3 45.301 22 2 91.771 33 1 109.000 44 
2. Ave Cæsar 1 19 26 3 13 13 4 9 7 2 17 19 
3. Blind Napoleon 1 -5 18 3 -10 9 4 -11 5 2 -9 14 
4. Golf 4 37 46 2 43 23 1 47 12 3 43 23 
5. WII - Mario 1 10 6 2 8 11 3 8 11 4 4 21 
6. Sparbonde 4 54 5 3 29 10 2 18 15 1 0 19 
  Samlet 2 112 3 88 4 83 1 140