SELECT
			hlstats_Clans.clanId,
			hlstats_Clans.name,
			hlstats_Clans.tag,
			COUNT(hlstats_Players.playerId) AS nummembers,
			SUM(hlstats_Players.kills) AS kills,
			SUM(hlstats_Players.deaths) AS deaths,
			SUM(hlstats_Players.connection_time) AS connection_time,
			ROUND(AVG(hlstats_Players.skill)) AS skill,
			ROUND(AVG(hlstats_Players.last_skill_change)) AS last_skill_change,
			ROUND(SUM(hlstats_Players.kills) / IF(SUM(hlstats_Players.deaths) = 0, 1, SUM(hlstats_Players.deaths)), 2) AS kpd,
			TRUNCATE(AVG(activity), 2) AS activity
		FROM
			hlstats_Clans,
			hlstats_Players
		WHERE
			hlstats_Clans.game = 'tf'
			AND hlstats_Clans.hidden <> 1
			AND hlstats_Players.clan = hlstats_Clans.clanId
			AND hlstats_Players.hideranking = 0
		GROUP BY
			hlstats_Clans.clanId
		HAVING
			activity >= 0
			AND nummembers >= 3
		ORDER BY
			skill desc,
			kpd desc,
			hlstats_Clans.name ASC
		LIMIT
			0,
			50