SELECT * FROM `char` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`)
DELETE FROM `char` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`)

SELECT * FROM `inventory` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `inventory` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `friends` WHERE `friend_id` NOT IN (SELECT `char_id` FROM `char`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `friends` WHERE `friend_id` NOT IN (SELECT `char_id` FROM `char`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `chatlog` WHERE `src_charid` NOT IN (SELECT `char_id` FROM `char`) or `src_accountid` NOT IN (SELECT `account_id` FROM `login`)
DELETE FROM `chatlog` WHERE `src_charid` NOT IN (SELECT `char_id` FROM `char`) or `src_accountid` NOT IN (SELECT `account_id` FROM `login`)

SELECT * FROM `global_reg_value` WHERE `char_id` !=0 AND `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `global_reg_value` WHERE `char_id` !=0 AND `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `global_reg_value` WHERE `account_id` !=0 AND `account_id` NOT IN (SELECT `account_id` FROM `login`)
DELETE FROM `global_reg_value` WHERE `account_id` !=0 AND `account_id` NOT IN (SELECT `account_id` FROM `login`)

SELECT * FROM `guild` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `guild` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `guild_alliance` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`) OR `alliance_id` NOT IN (SELECT `guild_id` FROM `guild`)
DELETE FROM `guild_alliance` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`) OR `alliance_id` NOT IN (SELECT `guild_id` FROM `guild`)

SELECT * FROM `guild_expulsion` WHERE `name` NOT IN (SELECT `name` FROM `char`)
DELETE FROM `guild_expulsion` WHERE `name` NOT IN (SELECT `name` FROM `char`)

SELECT * FROM `guild_member` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `guild_member` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `guild_position` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)
DELETE FROM `guild_position` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)

SELECT * FROM `guild_skill` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)
DELETE FROM `guild_skill` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)

SELECT * FROM `guild_storage` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)
DELETE FROM `guild_storage` WHERE `guild_id` NOT IN (SELECT `guild_id` FROM `guild`)

SELECT * FROM `homunculus` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `homunculus` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `hotkey` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `hotkey` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `loginlog` WHERE `user` != "d565sdc1@Ragnarok-World" AND `user` != "lserver" AND `user` NOT IN (SELECT `userid` FROM `login` )
DELETE FROM `loginlog` WHERE `user` != "d565sdc1@Ragnarok-World" AND `user` != "lserver" AND `user` NOT IN (SELECT `userid` FROM `login` )

SELECT * FROM `mail` WHERE `to_account_id` NOT IN (SELECT `account_id` FROM `login`) OR `from_account_id` NOT IN (SELECT `account_id` FROM `login`) OR `to_char_name` NOT IN (SELECT `name` FROM `char`) OR `from_char_name` NOT IN (SELECT `name` FROM `char`)
DELETE FROM `mail` WHERE `to_account_id` NOT IN (SELECT `account_id` FROM `login`) OR `from_account_id` NOT IN (SELECT `account_id` FROM `login`) OR `to_char_name` NOT IN (SELECT `name` FROM `char`) OR `from_char_name` NOT IN (SELECT `name` FROM `char`)

SELECT * FROM `memo` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `memo` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `mvplog` WHERE `kill_char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `mvplog` WHERE `kill_char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `npclog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `npclog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `party` WHERE `party_id` NOT IN (SELECT `party_id` FROM `char`)
DELETE FROM `party` WHERE `party_id` NOT IN (SELECT `party_id` FROM `char`)

SELECT * FROM `sc_data` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `sc_data` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `skill` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `skill` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `skill_homunculus` WHERE `homun_id` NOT IN (SELECT `homun_id` FROM `homunculus`)
DELETE FROM `skill_homunculus` WHERE `homun_id` NOT IN (SELECT `homun_id` FROM `homunculus`)

SELECT * FROM `storage` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`)
DELETE FROM `storage` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`)

SELECT * FROM `zenylog` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`) OR `src_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `zenylog` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`) OR `src_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `char` WHERE `party_id` != 0 AND `party_id` NOT IN (SELECT `party_id` FROM `party`)
UPDATE `char` SET `party_id` = 0 WHERE `party_id` != 0 AND `party_id` NOT IN  (SELECT `party_id` FROM `party`)

UPDATE `homunculus` SET `class` = 7001 WHERE `class` = 6030

SELECT * FROM `atcommandlog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `atcommandlog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `branchlog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `branchlog` WHERE `account_id` NOT IN (SELECT `account_id` FROM `login`) OR `char_id` NOT IN (SELECT `char_id` FROM `char`)

SELECT * FROM `cart_inventory` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)
DELETE FROM `cart_inventory` WHERE `char_id` NOT IN (SELECT `char_id` FROM `char`)