Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM characters WHERE OnlineStatus NOT IN (DATE_SUB(NOW(), INTERVAL 90 DAY));
- DELETE FROM `arena_team` WHERE captainguid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `arena_team_member` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `auctionhouse` WHERE auctioneerguid NOT IN (SELECT guid 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_action` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_aura` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_banned` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_battleground_data` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_battleground_random` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_declinedname` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_equipmentsets` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_gifts` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_glyphs` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_homebind` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_instance` 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_pet_declinedname` WHERE `owner` NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus_daily` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus_rewarded` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_queststatus_weekly` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_reputation` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_skills` 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_stats` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `character_talent` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `corpse` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `creature_respawn` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `gameobject_respawn` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `gm_tickets` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `group_instance` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `group_member` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `groups` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `guild_bank_eventlog` WHERE PlayerGuid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `guild_eventlog` WHERE PlayerGuid1 NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `guild_eventlog` WHERE PlayerGuid2 NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `guild_member` WHERE guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `item_instance` WHERE owner_guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `item_refund_instance` WHERE player_guid NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `mail_items` WHERE receiver NOT IN (SELECT guid FROM `characters`);
- DELETE FROM `petition` WHERE ownerguid NOT IN (SELECT guid FROM `characters`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement