[Query Analyzer] ResetLevel Auto

UPDATE Character
SET clevel = 1, Resets = Resets + 1, PkTime = 0, PkCount = 0, PkLevel = 0
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 0) OR (class = 1) OR (class = 16) OR (class = 17) OR (class = 32) OR (class = 33) OR (class = 32) OR (class = 33) OR (class = 48)) AND (clevel >= 400) AND (ConnectStat = 0);