Не коректное! Много мусора останется!
Код:
DELETE FROM `character_inventory` WHERE `item_template` IN ('entry');
Коректное!
Код:
DELETE FROM `item_instance` WHERE `guid` in (SELECT item FROM `character_inventory` WHERE item_template IN ('entry');
DELETE FROM `character_inventory` WHERE item_template IN ('entry');