DELETE FROM `account_data` WHERE `account_name` NOT IN (SELECT `login` FROM `accounts`);
-- character data
DELETE FROM `characters` WHERE `account_name` NOT IN (SELECT `login` FROM `accounts`);
UPDATE `auction` SET `sellerId`=0,`sellerName`='NPC',`sellerClanName`='NPC Clan',`currentBid`=0 WHERE `sellerId`!=0 AND `sellerId` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `auction_bid` WHERE `bidderId` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `auction_watch` WHERE `charObjId` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `boxaccess` WHERE `charname` NOT IN (SELECT `char_name` FROM `characters`);
DELETE FROM `character_friends` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`) OR `friend_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_hennas` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_macroses` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_quests` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_recipebook` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_recommends` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`) OR `target_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_shortcuts` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_skills` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_skills_save` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `character_subclasses` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `cursed_weapons` WHERE `playerId` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `heroes` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `items` WHERE `owner_id` NOT IN (SELECT `obj_Id` FROM `characters`) AND `loc`!='CLANWH';
DELETE FROM `augmentations` WHERE `item_id` NOT IN (SELECT `object_id` FROM `items`);
DELETE FROM `olympiad_nobles` WHERE `char_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `pets` WHERE `item_obj_id` NOT IN (SELECT `object_id` FROM `items`);
DELETE FROM `posts` WHERE `post_ownerid` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `seven_signs` WHERE `char_obj_id` NOT IN (SELECT `obj_Id` FROM `characters`);
-- clan data
DELETE FROM `clan_data` WHERE `leader_id` NOT IN (SELECT `obj_Id` FROM `characters`);
DELETE FROM `clan_privs` WHERE `clan_id` NOT IN (SELECT `clan_id` FROM `clan_data`);
DELETE FROM `clan_skills` WHERE `clan_id` NOT IN (SELECT `clan_id` FROM `clan_data`);
DELETE FROM `clan_subpledges` WHERE `clan_id` NOT IN (SELECT `clan_id` FROM `clan_data`);
DELETE FROM `clan_wars` WHERE `clan1` NOT IN (SELECT `clan_name` FROM `clan_data`) OR `clan2` NOT IN (SELECT `clan_name` FROM `clan_data`);
UPDATE `clanhall` SET `ownerId`=0,`desc`='(MEMO)',`paidUntil`=0 WHERE `ownerId`!=0 AND `ownerId` NOT IN (SELECT `clan_id` FROM `clan_data`);
DELETE FROM `clanhall_functions` WHERE `hall_id` NOT IN (SELECT `id` FROM `clanhall` WHERE `ownerId`!=0);
DELETE FROM `items` WHERE `owner_id` NOT IN (SELECT `clan_id` FROM `clan_data`) AND `loc`='CLANWH';
DELETE FROM `siege_clans` WHERE `clan_id` NOT IN (SELECT `clan_id` FROM `clan_data`);
UPDATE `characters` SET `clanid`=0,`clan_privs`=0 WHERE `clanid` NOT IN (SELECT `clan_id` FROM `clan_data`) AND `clanid`!=0;