INSERT INTO
				hlstats_EventHistory
				(
					eventType,
					eventTime,
					eventDesc,
					serverName,
					map
				)
			
		SELECT
			'Action',
			hlstats_Events_PlayerPlayerActions.eventTime,
			CONCAT('I received a points bonus of ', bonus, ' for triggering "', IFNULL(hlstats_Actions.description,'Unknown'), '" against %A%/stats/hlstats.php?mode=playerinfo&player=', victimId, '%', IFNULL(hlstats_Players.lastName,'Unknown'), '%/A%'),
			IFNULL(hlstats_Servers.name, 'Unknown'),
			hlstats_Events_PlayerPlayerActions.map
		FROM
			hlstats_Events_PlayerPlayerActions
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_PlayerPlayerActions.serverId
		LEFT JOIN
			hlstats_Actions
		ON
			hlstats_Actions.id = hlstats_Events_PlayerPlayerActions.actionId
		LEFT JOIN hlstats_Players ON
			hlstats_Players.playerId = hlstats_Events_PlayerPlayerActions.victimId
		WHERE
			hlstats_Events_PlayerPlayerActions.playerId = 631
		AND
			hlstats_Actions.game = 'insurgency'