These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Looking for list of T1BP with only minerals

First post
Author
Previous Topic Next Topic
Mad Vemane
University of Caille
Gallente Federation
#1 - 2015-10-28 04:56:59 UTC
Hey!

As said in the title, I am looking for an list of the item ID of T1 blueprint using only minerals component!

I hope one of you has this and is willing to share :)

Thanks a lot!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-10-28 18:16:02 UTC
https://www.fuzzwork.co.uk/resources/minonly.csv 

select distinct iam.typeid,typename from industryActivityMaterials iam join invTypes it on it.typeid=iam.typeid where iam.typeid not in (select typeID from industryActivityMaterials where materialtypeid not in (34,35,36,37,38,39,40,11399) and activityid=1)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Mad Vemane
University of Caille
Gallente Federation
#3 - 2015-10-28 20:27:32 UTC
Worked out great Big smile
Thanks a lot!!