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