DELETE FROM players WHERE lastlogin < UNIX_TIMESTAMP() - 30*24*60*60;
DELETE FROM player_items WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_skills WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_deaths WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_storage WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_viplist WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM player_depotitems WHERE player_id NOT IN (SELECT id FROM players);
DELETE FROM accounts WHERE id NOT IN (SELECT account_id FROM players);