KitPvP top, friends fetch

SELECT primaryname FROM players WHERE uid = (SELECT IF(smalluid = $uid, largeuid, smalluid) FROM kitpvp_friends WHERE type = %d AND (smalluid = $uid OR largeuid = $uid) AS tmp);
SELECT primaryname FROM players WHERE uid = (SELECT uid FROM kitpvp ORDER BY kills DESC LIMIT 5 AS tmp);