INSERT INTO
				hlstats_EventHistory
				(
					eventType,
					eventTime,
					eventDesc,
					serverName,
					map
				)
			
		SELECT
			'Team',
			hlstats_Events_ChangeTeam.eventTime,
			IF(hlstats_Teams.name IS NULL, CONCAT('I joined team "', team, '"'), CONCAT('I joined team "', team, '" (', hlstats_Teams.name, ')')),
			IFNULL(hlstats_Servers.name, 'Unknown'),
			hlstats_Events_ChangeTeam.map
		FROM
			hlstats_Events_ChangeTeam
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeTeam.serverId
		LEFT JOIN
			hlstats_Teams
		ON
			hlstats_Teams.code = hlstats_Events_ChangeTeam.team
		WHERE
			hlstats_Events_ChangeTeam.playerId = 514
		AND
			hlstats_Teams.game = 'cstrike'