: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 = 2:
RUNDE 2 (28-03-2004/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 =2 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 37 1 3 24 2 2 18 3 1 12 5 
2. Matador 1 35.250 15 2 30.900 9 3 22.100 6 4 13.350 3 
3. Hjertefri 4 87 1 3 81 2 2 77 3 1 62 5 
4. Ave Cæsar 3 7 6 1 11 9 1 11 9 4 5 3 
5. Klodsmajor 1 15 4 3 3 6 2 9 
6. Petanque 4 6 1 1 11 5 2 9 3 3 7 2 
7. 10.000 1 10.250 5 4 7.000 1 3 9.500 2 2 9.800 3 
8. Carcassonne 3 55 6 1 62 15 4 49 3 2 60 9 
  Samlet 1 50 2 46 4 35 3 39