Efficient Way to Clean Up Database (Items Mainly) by Zone?

[Lane]

Hey all!

I have made some solid efforts into recreating a classic database, however, it's a very time consuming task! As items aren't listed in the database by zone (man I wish there was a column for that!) I've gone through items either line by line, or #aggrozone the entire zone, gone through NPC's and their loottables/drops.

Is there an easier way to do this? I found a query on these forums from 10+ years ago, but wasn't sure if I could apply this to HeidiSQL.

I also don't use EOC or GeorgeS Tools, so not sure if I should go that approach if they have this option.

My goal is to first remove all non classic-kunark-velious NPC's, then remove out of era NPC's, then fix quests.

After a few weeks I'm seemingly done with most of Faydwer, however, have a long way to go. Thanks for the help!