List of Tech I Manufacturables (sql dump)

Industry Gameplay Center Science & Industry
1

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;

select 
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!

2

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

3

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

4

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