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;