[sql] Запрос на удаление чаров

DELETE FROM characters where level <= 30;
-- claning other
DELETE FROM character_friends WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_hennas WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_macroses WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_quests WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_recipebook WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_shortcuts WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_skills_save WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_subclasses WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM character_raid_points WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT charId 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);
UPDATE clan_subpledges SET leader_id = 0 where leader_id NOT IN (SELECT charid from characters);
DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT charId FROM characters));
DELETE FROM items WHERE owner_id NOT IN (SELECT charId FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM seven_signs WHERE charId NOT IN (SELECT charId FROM characters);
UPDATE characters SET clanid = 0, title = "", clan_privs = 0 where clanid NOT IN (SELECT clan_id FROM clan_data);
UPDATE clanhall SET ownerId = 0, paidUntil = 0 where ownerId NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM forums WHERE forum_owner_id NOT IN (SELECT clan_id FROM clan_data) AND forum_owner_id != 0;
DELETE FROM posts WHERE post_ownerid NOT IN (SELECT charId FROM characters);
DELETE FROM topic WHERE topic_ownerid NOT IN (SELECT charId FROM characters);
DELETE FROM olympiad_nobles WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM heroes WHERE charId NOT IN (SELECT charId FROM characters);
DELETE FROM item_attributes WHERE itemId NOT IN (SELECT object_id FROM items);
DELETE FROM siege_clans WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM obj_restrictions WHERE obj_Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player1Id NOT IN (SELECT charId FROM characters);
DELETE FROM couples WHERE player2Id NOT IN (SELECT charId FROM characters);
DELETE FROM characters_custom_data WHERE charId NOT IN (SELECT charId FROM characters);