# List of Tech I Manufacturables (sql dump)

**URL:** <https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050>\
**Category:** Science & Industry\
**Created:** [August 14, 2018, 3:42pm UTC](https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050 "2018-08-14T15:42:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeyo\_Xadi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/jeyo_xadi/32/90588_2.png) [@Jeyo\_Xadi](https://forums.eveonline.com/u/Jeyo_Xadi)\
**Post date:** [August 14, 2018, 3:42pm UTC](https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050/1 "2018-08-14T15:42:56Z")

</div>

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;

```auto
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!

---

<div class="post-metadata">

**Author:** ![Omnathious\_Deninard](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/omnathious_deninard/32/266675_2.png) [@Omnathious\_Deninard](https://forums.eveonline.com/u/Omnathious_Deninard)\
**Post date:** [August 14, 2018, 6:40pm UTC](https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050/2 "2018-08-14T18:40:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Steve\_Ronuken](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/steve_ronuken/32/373894_2.png) [@Steve\_Ronuken](https://forums.eveonline.com/u/Steve_Ronuken)\
**Post date:** [August 14, 2018, 7:49pm UTC](https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050/3 "2018-08-14T19:49:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [November 12, 2018, 7:53pm UTC](https://forums.eveonline.com/t/list-of-tech-i-manufacturables-sql-dump/98050/4 "2018-11-12T19:53:07Z")

</div>

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