Expansion items
 

I know that there is a way to sort zones by expansion field... is there a field im missing for items that can be used to group items by expansion release? Thanks for any input!!

Short answer: No.

Long answer: You can cross reference the items, lootdrop_entries, npc_types, loottable, spawn2, spawngroup, and spawnentry in a query to select all the item IDs that drop in a specific zone. They won't be 'for that era', however, they will only be sorted by items that drop in those specific zones in the database you are running.

Ok, I was afraid of that....

I could use cross reference to figure out what items drop in all zones for expansion 8 for example... etc...

then I would eventually figure out what's left that are in the db, but do not drop, which would be the newer ones....

thanks so much Secrets for the quick response!!!

if you're just looking for items that are in the database that do not drop, the following query should give you a general idea. please note that it works under the assumption that all related tables (npc_types, spawn2, spawngroup, spawnentry, loottable, loottable_entries, lootdrop, and lootdrop_entries) are without error (meaning no entries with 0 chance/probability or invalid spawn/loot info). it also doesn't take into account items that are only obtainable via quests, tradeskills, or merchants.

Sweet, thanks c0ncrete!