INSERT INTO
				hlstats_EventHistory
				(
					eventType,
					eventTime,
					eventDesc,
					serverName,
					map
				)
			
		SELECT
			'Friendly Fire',
			hlstats_Events_Teamkills.eventTime,
			CONCAT('My teammate %A%/hlstats.php?mode=playerinfo&player=', killerId, '%', IFNULL(hlstats_Players.lastName, 'Unknown'), '%/A%', ' killed me with ', weapon),
			IFNULL(hlstats_Servers.name, 'Unknown'),
			hlstats_Events_Teamkills.map
		FROM
			hlstats_Events_Teamkills
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_Teamkills.serverId
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId = hlstats_Events_Teamkills.killerId
		WHERE
			hlstats_Events_Teamkills.victimId = 1002