[SQL] DELETE FROM player.player WHERE  id < '458000' and last_play < '2010-06-01 00:00:00';
Affected rows: 1730
Time: 1.221ms

[SQL]
TRUNCATE player.player_deleted;
Affected rows: 0
Time: 2.387ms

[SQL]
DELETE FROM player.item WHERE owner_id NOT IN (SELECT id FROM player.player) and window != 'MALL' and window != 'SAFEBOX';
Affected rows: 358
Time: 9.594ms

[SQL]
DELETE FROM player.guild_member WHERE guild_id NOT IN (SELECT id FROM player.guild);
Affected rows: 3
Time: 0.058ms

[SQL]
DELETE FROM player.guild_member WHERE pid NOT IN (SELECT id FROM player.player);
Affected rows: 0
Time: 0.061ms

[SQL]
DELETE FROM player.guild WHERE id NOT IN (SELECT guild_id FROM player.guild_member);
Affected rows: 3
Time: 0.046ms

[SQL]
DELETE FROM player.guild WHERE level=1 AND win=0 AND draw=0 AND loss=0;
Affected rows: 42
Time: 0.044ms

[SQL]
DELETE FROM player.guild_comment WHERE guild_id NOT IN (SELECT id FROM player.guild);
Affected rows: 3
Time: 0.047ms

[SQL]
DELETE FROM player.guild_war_reservation WHERE guild1 NOT IN (SELECT id FROM player.guild) OR guild2 NOT IN (SELECT id FROM player.guild);
Affected rows: 1806
Time: 0.335ms

[SQL]
DELETE FROM player.guild_grade WHERE guild_id NOT IN (SELECT id FROM player.guild);
Affected rows: 720
Time: 0.185ms

[SQL]
UPDATE player.land SET guild_id=0 WHERE guild_id NOT IN (SELECT id FROM player.guild);
Affected rows: 0
Time: 0.045ms

[SQL]
DELETE FROM account.account WHERE id NOT IN (SELECT account_id FROM player.player);
Affected rows: 6766
Time: 0.698ms

[SQL]
DELETE FROM player.quest WHERE dwPID NOT IN (SELECT id FROM player.player);
Affected rows: 224
Time: 5.778ms

[SQL]
DELETE FROM player.safebox WHERE account_id NOT IN (SELECT account_id FROM player.player);
Affected rows: 0
Time: 0.095ms

[SQL]
DELETE FROM player.item WHERE owner_id NOT IN (SELECT id FROM account.account) and window = 'SAFEBOX';
Affected rows: 0
Time: 7.449ms

[SQL]
DELETE FROM player.item WHERE owner_id NOT IN (SELECT id FROM account.account) and window = 'MALL';
Affected rows: 54
Time: 7.421ms

[SQL]
UPDATE player.player_index SET pid1=0 WHERE pid1 NOT IN (SELECT id FROM player.player);
Affected rows: 574
Time: 0.201ms

[SQL]
UPDATE player.player_index SET pid2=0 WHERE pid2 NOT IN (SELECT id FROM player.player);
Affected rows: 415
Time: 0.200ms

[SQL]
UPDATE player.player_index SET pid3=0 WHERE pid3 NOT IN (SELECT id FROM player.player);
Affected rows: 314
Time: 0.205ms

[SQL]
UPDATE player.player_index SET pid4=0 WHERE pid4 NOT IN (SELECT id FROM player.player);
Affected rows: 419
Time: 0.205ms

[SQL]
DELETE FROM player.player_index WHERE pid1=0 AND pid2=0 AND pid3=0 AND pid4=0;
Affected rows: 1435
Time: 0.081ms