: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 = 5:
RUNDE 5 (30-10-2004/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 =5 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 16 2 4 23 1 1 15 5 2 16 2 
2. Porsche Challenge 3 2 4 1 2 3 1 5 
3. Rallye 2 3 4 1 3 2 1 5 
4. Gran Turismo 3 2 4 1 2 3 1 5 
5. Tekken 4 1 3 2 2 3 1 5 
6. Command & Conquer 4 1 2 3 3 2 1 5 
7. Command & Conquer 2 3 4 1 3 2 1 5 
8. West 1 -7 5 2 0 3 3 1 2 4 6 1 
9. Ave Cæsar 2 13 6 4 11 3 1 20 15 2 13 6 
10. Tipskuponen 2 18 18 3 17 17 1 21 21 4 15 15 
  Samlet 3 43 4 33 1 58 2 54