SELECT
			skill,
			kills,
			flag,
			lastName AS playerName,
			playerId
		FROM
			hlstats_Players,
			hlstats_Ranks
		WHERE
			rankId=1101 AND
			kills>=minKills AND
			kills<=maxKills AND
			hlstats_Players.game = 'csgo' AND
			hlstats_Players.hideranking<>'1'
		ORDER BY
			skill desc,
			playerName desc
		LIMIT 0,50