Ships and slots

From EVEDev

How many high/mid/low/rig/subsystem slots does a ship have (for T3 ships you need to query each subsystem instead)?

SELECT TRIM(attribtypes.attributename),
    attrib.valueint,
    attrib.valuefloat
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', 
    'maxSubSystems', 'lowSlotModifier','medSlotModifier','hiSlotModifier')
AND type.typeName = <ship/subsystem name>;