: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 = 4:
RUNDE 4 (26-09-2004/LMD/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 =4 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 1 10 5 3 32 2 4 55 1 2 16 3 
2. Bordtennis 3 2 1 5 4 1 2 3 
3. Bordtennis 3 2 2 3 4 1 1 5 
4. Bordtennis 1 5 3 2 4 1 2 3 
5. Bowling 3 112 2 1 153 5 2 113 3 4 77 1 
6. Bowling 1 128 5 2 121 3 4 109 1 3 113 2 
7. Hjertefri 3 49 2 1 24 5 4 107 1 2 32 3 
8. NBA 1 58 5 3 39 2 2 44 3 4 35 1 
9. NBA 3 12 1 2 14 3 3 12 1 1 16 5 
10. NBA 2 28 3 3 20 2 1 39 5 4 9 1 
11. Alpine Racer 1 5 4 1 3 2 2 3 
12. Pool Billard 1 5 2 3 3 2 4 1 
13. Pool Billard 4 1 2 3 1 5 3 2 
14. Minigolf 4 69 1 1 55 5 2 60 3 3 67 2 
15. Daytona 4 1 3 2 2 3 1 5 
16. Daytona 1 5 2 3 4 1 3 2 
17. Daytona 3 2 4 1 1 5 2 3 
18. Lord of the Rings 1 9.687.000 5 3 6.154.900 2 2 7.714.200 3 4 5.537.200 1 
19. Ripley´s 3 2.996.330 2 1 8.939.230 5 4 1.735.330 1 2 6.145.360 3 
  Samlet 1 59 2 57 4 43 3 49