Published Blueprints

From EVEDev

[edit] SQL

 
 SELECT blueprintType.typeID,
       blueprintType.typeName Blueprint,
       productType.typeID,
       productType.typeName Item,
       productGraphic.iconFile ItemGraphic,
       productGroup.groupName ItemGroup,
       productCategory.categoryName ItemCategory,
       blueprints.productionTime,
       blueprints.techLevel,
       blueprints.researchProductivityTime,
       blueprints.researchMaterialTime,
       blueprints.researchCopyTime,
       blueprints.researchTechTime,
       blueprints.productivityModifier,
       blueprints.materialModifier,
       blueprints.wasteFactor,
       blueprints.maxProductionLimit
 FROM invBlueprintTypes AS blueprints
 INNER JOIN invTypes AS blueprintType        ON blueprints.blueprintTypeID = blueprintType.typeID
 INNER JOIN invTypes AS productType          ON blueprints.productTypeID   = productType.typeID
 INNER JOIN invGroups AS productGroup        ON productType.groupID        = productGroup.groupID
 INNER JOIN invCategories AS productCategory ON productGroup.categoryID    = productCategory.categoryID
 INNER JOIN eveGraphics AS blueprintGraphic  ON blueprintType.graphicID    = blueprintGraphic.graphicID
 INNER JOIN eveIcons AS productGraphic       ON productType.iconID         = productGraphic.iconID
 WHERE blueprintType.published = 1
 

[edit] Example

Example limited to 5 records and most of the columns from invBlueprintTypes removed for clarity

typeID	Blueprint	Item	ItemGraphic	ItemGroup	ItemCategory	productionTime	techLevel	maxProductionLimit
683	Bantam Blueprint	Bantam		Frigate	Ship	6000	1	30
684	Condor Blueprint	Condor		Frigate	Ship	6000	1	30
685	Griffin Blueprint	Griffin		Frigate	Ship	6000	1	30
686	Osprey Blueprint	Osprey		Cruiser	Ship	12000	1	15
687	Caracal Blueprint	Caracal		Cruiser	Ship	12000	1	15