Getting unqiue records from query

[eluser]hendrik[/eluser]
Thanks for putting me in the right direction. This worked:

Code:

SELECT user_id, MIN(duration), screenname FROM campaign_game JOIN dc_contacts ON campaign_game.user_id = contacts.id GROUP BY user_id ORDER BY MIN(duration) ASC