########################## ASCENT PRUNER BY SILENT ########################### DELETE ACCOUNTS THAT HAVEN'T LOGGED IN (IN A CERTAIN TIME AMOUNT) -- EDIT THE DATE!DELETE FROM `accounts` WHERE `lastlogin` < '2007-08-01 00:00:00';# DELETE CHARACTERS LOWER THAN XDELETE FROM `characters` where level <= "1";# DELETE ACCOUNTS WITHOUT CHARACTERS AND CHARACTERS WITHOUT ACCOUNTSDELETE FROM `characters` WHERE `acct` NOT IN (SELECT `acct` FROM `accounts`);DELETE FROM `accounts` WHERE `acct` NOT IN (SELECT `acct` FROM `characters`);# DELETE PETS WITHOUT CHARACTERS AND PET SPELLS WITHOUT PETSDELETE FROM `playerpets` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `playerpetspells` WHERE `petnumber` NOT IN (SELECT `petnumber` FROM `playerpets`);# DELETE ITEMS, SUMMON SPELLS AND QUEST LOGS WITHOUT CHARACTERSDELETE FROM `playeritems` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `playersummonspells` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `questlog` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);# DELETE GUILDS WITHOUT LEADERS AND CHARTERS WITHOUT GUILDSDELETE FROM `guilds` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `charters` WHERE `leaderGuid` NOT IN (SELECT `leaderGuid` FROM `guilds`);# DELETE CORPSES AND AUCTIONS WITHOUT CHARACTERSDELETE FROM `corpses` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `auctions` WHERE `owner` NOT IN (SELECT `guid` FROM `characters`);# DELETE CHARTERS AND GM TICKETS WITHOUT CHARACTERSDELETE FROM `charters` WHERE `leaderGuid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `gm_tickets` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);# DELETE MAIL WITHOUT CHARACTERSDELETE FROM `mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);DELETE FROM `mailbox` WHERE `sender_guid` NOT IN (SELECT `guid` FROM `characters`);