evesde.sql

# slots

SELECT
  "attributeName"                                  AS name,
  coalesce(attrib."valueFloat", attrib."valueInt") AS value
FROM evesde."dgmTypeAttributes" AS attrib
  INNER JOIN evesde."invTypes" AS type
    ON attrib."typeID" = type."typeID"
  INNER JOIN evesde."dgmAttributeTypes" AS attribtypes
    ON attrib."attributeID" = attribtypes."attributeID"
  WHERE "attributeName" IN ('lowSlots','medSlots','hiSlots','rigSlots','maxSubSystems','lowSlotModifier','medSlotModifier','hiSlotModifier')
  AND type."typeID" = 582