SELECT
			hlstats_Countries.flag,
			hlstats_Countries.name,
			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_Countries 
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.flag = hlstats_Countries.flag
		WHERE
			hlstats_Players.game = 'css'
			AND hlstats_Players.hideranking = 0
			AND IF(31536000 > (UNIX_TIMESTAMP() - hlstats_Players.last_event), ((100 / 31536000) * (31536000 - (UNIX_TIMESTAMP() - hlstats_Players.last_event))), -1) >= 0
		GROUP BY
			hlstats_Countries.flag
		HAVING
			activity >= 0
			AND nummembers >= 3
		ORDER BY
			skill desc,
			kpd desc,
			hlstats_Countries.name ASC
		LIMIT
			0,
			50