: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 = 3:
RUNDE 3 (13-06-2004/FFJ/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 =3 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 3 4 19 1 1 1 5 3 14 2 
2. Kanonskydning 4 0 1 4 0 1 4 0 1 4 0 1 
3. Kanonskydning 2 0 1 2 0 1 2 0 1 1 1 5 
4. Pileskydning 1 3 5 2 2 2 4 1 1 2 2 2 
5. Havfruen 4 1 1 5 2 3 3 2 
6. Frøen 1 2 5 2 1 3 3 0 1 3 0 1 
7. AirHockey 3 2 1 5 2 3 4 1 
8. Galoppen 2 3 1 5 3 1 3 1 
9. Galoppen 1 5 2 3 4 1 3 2 
10. Lord of the Rings 2 3.214.080 3 4 2.618.180 1 3 3.044.080 2 1 7.122.800 5 
11. Hjertefri 1 32 5 3 70 2 4 113 1 2 55 3 
12. Ring Rider 2 3 3 2 1 5 4 1 
13. Klatrebjørne 2 10 1 1 20 3 1 20 3 2 10 1 
14. Pjerrotspil 1 2 2 1 2 2 1 2 2 4 0 1 
15. Pjerrotspil 4 0 1 1 2 2 1 2 2 1 2 2 
16. Muldvarpen 3 23 2 1 25 5 4 21 1 2 24 3 
  Samlet 2 43 2 43 4 33 4 33