gistfile1.sql

-- Find required skills for Sin
SELECT skill.typeName, skillLevel.valueInt
FROM dgmTypeAttributes AS attr
INNER JOIN dgmAttributeTypes AS attrType
   ON attr.attributeID = attrType.attributeID
   AND attrType.attributeName LIKE 'requiredSkill_'
INNER JOIN invTypes AS skill
   ON skill.typeID = attr.valueInt
INNER JOIN dgmTypeAttributes AS skillLevel
   ON skillLevel.typeID = attr.typeID
INNER JOIN dgmAttributeTypes AS skillLevelType
   ON skillLevel.attributeID = skillLevelType.attributeID
   AND skillLevelType.attributeName = attrType.attributeName || 'Level'
WHERE attr.typeID = 22430;