: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 = 34:
RUNDE 4 (07-11-2009/LMD) 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 =34 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 4 48 8 2 20 23 3 33 15 1 0 30 
2. Matador 1 205.800 70 4 0 18 2 0 53 3 0 35 
3. Hjertefri 2 53 12 1 38 24 4 116 6 2 53 12 
4. Bakari 3 6 4 3 1 11 2 8 
5. Davoserjazz 2 49 11 3 54 7 4 91 4 1 36 14 
  Samlet 1 107 4 75 3 89 2 99