Ships and slots

From EVEDev

How many high/mid/low/rig slots does a ship have?

SELECT TRIM(attribtypes.attributename),
       attrib.valueint
FROM dgmTypeAttributes AS attrib
     INNER JOIN invTypes AS type
       ON attrib.typeID = type.typeID
     INNER JOIN dgmAttributeTypes AS attribtypes
       ON attrib.attributeID = attribtypes.attributeID
WHERE attribtypes.attributename IN ('lowSlots', 'medSlots', 'hiSlots', 'rigSlots')
      AND type.typeName = <ship name>;