I wrote this ISAPI filter to rewrite the URL because we had some sites that moved locations... Basically the filter looks at the referrer, and if it's the local server, it looks at the requested URL and compared it to the full referrer. If the first path is identical, nothing is done, however if not, it takes the first path from the full referrer and prepends it to the URL. For example: /Content/imgs/img.jpg from a referrer of http://myserver/wr...

Hmm... I just got it to work by doing the following...
...

UPDATE tblplayers a,
(
SELECT SUM(COALESCE(co stCP, 0)) AS CPCOUNT, forumMemberID
FROM tblplayers c
LEFT OUTER JOIN tblplayerabilit ies a ON a.playerID = c.forumMemberID
LEFT OUTER JOIN tbldoctrineabil ities b ON a.abilityID = b.abilityID
GROUP BY CP, forumMemberID
) b
SET a.CP = 15 - (b.CPCOUNT+a.CP )
WHERE a.forumMemberID = b.forumMemberID
AND (b.CPCOUNT+a.CP ) < 15
...