SELECT
			IFNULL(hlstats_Teams.name, hlstats_Events_ChangeTeam.team) AS name,
			COUNT(hlstats_Events_ChangeTeam.id) AS teamcount,
			ROUND(COUNT(hlstats_Events_ChangeTeam.id) / IF(0 = 0, 1, 0) * 100, 2) AS percent
		FROM
			hlstats_Events_ChangeTeam
		LEFT JOIN
			hlstats_Teams
		ON
			hlstats_Events_ChangeTeam.team = hlstats_Teams.code
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeTeam.serverId
		WHERE
			hlstats_Teams.game = 'hl2dm_2' 
			AND hlstats_Servers.game = 'hl2dm_2' 
			AND hlstats_Events_ChangeTeam.playerId = 150842 
			AND
			(
				hidden <> '1'
				OR hidden IS NULL
			)
		GROUP BY
			hlstats_Events_ChangeTeam.team
		ORDER BY
			teamcount desc,
			name desc