Published Blueprints

From EVEDev

[edit] SQL

 
 SELECT blueprintType.typeID,
       blueprintType.typename Blueprint,
       productType.typeID,
       productType.typename Item,
       productGraphic.icon 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.chanceOfReverseEngineering,
       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 eveGraphics AS productGraphic    ON productType.graphicID      = productGraphic.graphicID
 WHERE blueprintType.published = 1
 

[edit] Example

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

---

Error while connecting to host "" !

---