DELETE from _BlockedWhisperers where OwnerID in (select CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Items where ID64 In (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) and not ID64 = 0 DELETE FROM _Items where ID64 In (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')))) DELETE from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE from _Chest where UserJID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharSkill where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharSkillMastery where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharTrijobSafeTrade where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharTrijob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _ClientConfig where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _DeletedChar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharQuest where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharCollectionBook where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharNickNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _CharNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Friend where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _InventoryForAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Memo where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _StaticAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _InvCOS where CosID in (SELECT ID FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TimedJob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TrainingCampSubMentorHonorPoint where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _Friend where FriendCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _GuildMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _TrainingCampMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name') DELETE FROM _AccountJID WHERE JID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) DELETE FROM _Char where CharName16 = 'Char Name'