: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 = 32:
RUNDE 2 (05-04-2009/FFJ) 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 =32 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. Yatzy 3 262 10 2 267 14 4 214 5 1 322 19 
2. Blind Napoleon 4 20 11 2 11 15 3 12 5 1 9 20 
3. Jeopardy 4 1.100 8 2 4.700 23 1 4.800 31 3 2.400 16 
4. Sparbonde 4 33 9 2 10 26 3 15 17 1 3 34 
5. Myretuen 2 6 7 1 7 25 2 6 7 2 6 7 
6. Hjertefri 3 60 12 2 56 18 4 101 6 1 39 24 
7. 10.000 1 10.550 10 2 9.700 8 4 8.400 3 3 9.000 5 
  Samlet 4 67 1 129 3 74 2 125