Defining items by expansion

[Shin Noir]

I have a couple ugly queries you can do to at least see stat giving items with outliers per zone, like..

SELECT i.id, i.NAME, i.classes, i.slots, i.hp, i.mana, s2.zone FROM items i
INNER JOIN lootdrop_entries lde ON lde.item_id = i.id
INNER JOIN lootdrop ld ON ld.id = lde.lootdrop_id
INNER JOIN loottable_entries lte ON lte.lootdrop_id = ld.id
INNER JOIN loottable lt ON lt.id = lte.loottable_id
INNER JOIN npc_types nt ON nt.loottable_id = lt.id
INNER JOIN spawnentry se ON se.npcid = nt.id
INNER JOIN spawn2 s2 ON s2.spawngroupid = se.spawngroupid	
WHERE slots > 0 AND s2.zone = 'ecommons' GROUP BY i.id;

They're really intense queries, but at least gets the obvious ones out.. Heh.