SELECT * FROM players
LEFT JOIN matchs
	ON players.match_id = matchs.id
where
	matchs.id = 7 and
	players.team <> "other"
ORDER BY
	players.nb_kill DESC