Mysql in cod2 query question

[Mitch]

Try a inner join with player table.

select c.player_id, p.name, MIN(c.time_played) from checkpoint_statistics c INNER JOIN player p ON c.player_id = p.id  WHERE cp_id = 1071 GROUP BY c.player_id ORDER BY MIN(c.time_played) LIMIT 10

Edit: might some editing