EVE Technology Lab

Working on a fitting tool for my alliance and have managed to get through the static data import and found the query to work out the number of low / mid / high slots for a particular ship...

SELECT
   TRIM(attribtypes.attributename),
   coalesce(attrib.valueFloat, attrib.valueInt) as value
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 = 'Stratios';

Which works fine - BUT it doesn't work for T3D's because obviously the subsystems effect the number of slots.
Is there any query that can work that out based on subsystems fitted?

Thanks