########################## 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 X
DELETE FROM `characters` where level <= "1";

# DELETE ACCOUNTS WITHOUT CHARACTERS AND CHARACTERS WITHOUT ACCOUNTS
DELETE 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 PETS
DELETE 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 CHARACTERS
DELETE 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 GUILDS
DELETE 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 CHARACTERS
DELETE 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 CHARACTERS
DELETE 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 CHARACTERS
DELETE FROM `mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);
DELETE FROM `mailbox` WHERE `sender_guid` NOT IN (SELECT `guid` FROM `characters`);