Unnamed

SELECT DISTINCT
	t2.name, t2.surname, t2.id as id2
FROM 
	players t2
LEFT JOIN 
	tourney_info t1 
ON
	t1.player_id=t2.id
WHERE 
	t1.player_id NOT IN (SELECT player_id FROM tourney_info WHERE tourney_id='$id')