#Clean accounts;
delete FROM accounts WHERE login NOT IN (SELECT account_name FROM characters); 
#Clean Character_friends;
delete FROM character_friends WHERE char_id NOT IN (SELECT obj_Id FROM characters);
#Clean character_hennas;
delete FROM character_hennas WHERE char_obj_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean character_macroses;
delete FROM character_macroses WHERE char_obj_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean character_quests;
delete FROM character_quests WHERE char_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean character_recipebook;
delete FROM character_recipebook WHERE char_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean character_shortcuts;
delete FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean character_skills;
delete FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
#Clean character_skills_save;
delete FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters); 
#Clean items;
delete FROM items WHERE owner_id NOT IN (SELECT obj_Id FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
#Clean pets;
delete FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT obj_Id FROM characters)); 
#Clean seven signs
delete FROM seven_signs WHERE char_obj_id NOT IN (SELECT characters.obj_Id FROM characters);
#Clean clan_data;
delete FROM clan_data WHERE leader_id NOT IN (SELECT characters.obj_Id FROM characters);
update characters SET clanid='0' WHERE clanid NOT IN ( SELECT clan_id FROM clan_data );
update characters SET title=(NULL) WHERE clanid=0;