EXPLAIN SELECT Timestamp, kill.KillID, CACHE_VictimFactionID AS VictimFactionID, VFaction.Name as VictimFactionName, CACHE_FinalBlowFactionID AS FinalBlowFactionID

			FROM			testdb.kill FORCE INDEX (Timestamp)
			JOIN 			killparticipantpilot FORCE INDEX (PRIMARY) ON killparticipantpilot.KillID = kill.KillID
			JOIN 			killvictimpilot FORCE INDEX (PRIMARY) ON kill.KillID = killvictimpilot.KillID
			JOIN			faction AS VFaction FORCE INDEX (PRIMARY) ON VFaction.FactionID = CACHE_VictimFactionID

			WHERE			killparticipantpilot.PilotID = 2285

			ORDER BY	Timestamp DESC
			LIMIT 25