Assembly Lines for Blueprint

Each blueprint has one or more assembly lines in which it can be built. Some assembly lines have a bonus to build time, or a penalty to the amount of materials required. This query will show a list of assembly lines for a given blueprint, along with their time and material multipliers.

 SELECT at.assemblyLineTypeName,
  at.baseTimeMultiplier * d.timeMultiplier,
  at.baseMaterialMultiplier * d.materialMultiplier
 FROM ramAssemblyLineTypes AS at
  INNER JOIN ramAssemblyLineTypeDetailPerCategory AS d
   ON at.assemblyLineTypeID = d.assemblyLineTypeID
  INNER JOIN invCategories AS c
   ON d.categoryID = c.categoryID
  INNER JOIN invGroups AS g
   ON c.categoryID = g.categoryID
  INNER JOIN invTypes AS t
   ON g.groupID = t.groupID
 WHERE at.activityID = 1 -- Manufacturing
  AND t.typeID = ?001 -- productTypeID
UNION
 SELECT at.assemblyLineTypeName,
  at.baseTimeMultiplier * d.timeMultiplier,
  at.baseMaterialMultiplier * d.materialMultiplier
 FROM ramAssemblyLineTypes AS at
  INNER JOIN ramAssemblyLineTypeDetailPerGroup AS d
   ON at.assemblyLineTypeID = d.assemblyLineTypeID
  INNER JOIN invGroups AS g
   ON d.groupID = g.groupID
  INNER JOIN invTypes AS t
   ON g.groupID = t.groupID
 WHERE at.activityID = 1 -- Manufacturing
  AND t.typeID = ?001 -- productTypeID
ORDER BY assemblyLineTypeName ASC;