List of Tech I Manufacturables (sql dump)

Hello guys!

Not sure if this is the right place to ask, but I have downloaded the latest SQL dump of the Eve Online database and am trying to figure out how to determine if a specific item is manufacturable or not.

I can get a list of all Tech I items with;

typename, metaGroupName 
FROM invMetaTypes,invTypes,invMetaGroups
WHERE invTypes.typeID = invMetaTypes.typeID
AND invMetaTypes.metaGroupID = 1 
AND invMetaGroups.metaGroupID = invMetaTypes.metaGroupID

I am now looking for a way to limit this list to only show Tech I items that can be manufactured via a blueprint.

Any help would be greatly appreciated!

I’m not much on the programming side of things, but T1 items are actually meta 0 items not meta 1

assuming you got the dump from me, you want to join in industryActivityProducts, on producttypeid (for things which can be made)

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.