Skip to content

Instantly share code, notes, and snippets.

@bastianh
Created Oct 19, 2015
Embed
What would you like to do?
# 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment