All pastes #946037 Raw Edit
Someone

public text v1 · immutable
·published 2008-03-17 11:35 UTC
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 1 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 1);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 50 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 50);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 100 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 100);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 150 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 150);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 200 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 200);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 250 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 250);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 300 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 300);
DELETE FROM `db_character`.`item_instance` WHERE SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',15),' ',-1) > 350 AND SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',4),' ',-1) NOT IN (SELECT `entry` FROM `db_world`.`item_template` WHERE `stackable` > 350);
DELETE FROM `character_inventory` WHERE `item` NOT IN (SELECT `guid` FROM `item_instance`);
DELETE FROM `guild_bank_item` WHERE `item_guid` NOT IN (SELECT `guid` FROM `item_instance`);