: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 = 33:
RUNDE 3 (10-05-2009/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 =33 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 2 3 15 1 0 20 3 10 10 4 23 5 
2. Game of Life 2 65.469 38 3 40.259 25 1 130.159 50 4 35.845 13 
3. Vikingespil 3 2 1 5 1 5 3 2 
4. Vikingespil 1 3 1 3 3 1 3 1 
5. Vikingespil 1 5 3 2 1 5 3 2 
6. Jeopardy 3 1.900 14 1 7.100 27 2 6.700 20 4 1.800 7 
7. 10.000 1 10.450 9 4 2.200 3 3 8.100 5 2 8.400 7 
8. Hjertefri 4 75 5 2 60 14 3 64 9 1 35 18 
  Samlet 3 91 2 99 1 105 4 55