DELETE FROM `account` where `id` not in (select account from `characters`.`characters`);   
DELETE FROM `account` WHERE `last_login`>90;   
DELETE FROM `account` where `id` not in (select `account` from `characters`.`characters`) AND gmlevel = '0';   
DELETE FROM `account_banned`;   
DELETE FROM `characters` where level<3;   
DELETE FROM `character_action` where guid not in (select guid from `characters`);   
DELETE FROM `character_aura` where guid not in (select guid from `characters`);   
DELETE FROM `character_gifts` where guid not in (select guid from `characters`);   
DELETE FROM `character_homebind` where guid not in (select guid from `characters`);    
DELETE FROM `character_inventory` where guid not in (select guid from `characters`);   
DELETE FROM `character_pet` where owner not in (select guid from `characters`);    
DELETE FROM `character_queststatus` where guid not in (select guid from `characters`);   
DELETE FROM `character_reputation` where guid not in (select guid from `characters`);    
DELETE FROM `character_social` where guid not in (select guid from `characters`);    
DELETE FROM `character_spell` where guid not in (select guid from `characters`);   
DELETE FROM `character_spell_cooldown` where guid not in (select guid from `characters`);    
DELETE FROM `character_ticket` where guid not in (select guid from `characters`);   
DELETE FROM `character_tutorial` where account not in (select account from `characters`);    
DELETE FROM `corpse` where `player` not in (select guid from `characters`);   
DELETE FROM `character_inventory` where guid not in (SELECT guid FROM `characters`);   
DELETE FROM `item_instance` where owner_guid not in (SELECT guid FROM `characters`);   
DELETE FROM `account_data` where `account` not in (select account from `characters`);   
DELETE FROM `character_account_data` where `guid` not in (select guid from `characters`);   
DELETE FROM `character_achievement` where `guid` not in (select guid from `characters`);   
DELETE FROM `character_achievement_progress` where `guid` not in (select guid from `characters`);   
DELETE FROM `character_talent` where `guid` not in (select guid from `characters`);