SELECT team.tid, team.name AS tname, tag, player.name AS lname
FROM player, team
LEFT JOIN leader ON team.tid = leader.tid
WHERE leader.pid = player.pid
ORDER BY tname