These forums have been archived and are now read-only.
The new forums are live and can be found at https://forums.eveonline.com/
Skill relationships
SELECT i.typeID as itemID, ip.typeID as prerqSkillID, dtal.valueInt as prerqSkillLevelInt, dtal.valueFloat as prerqSkillLevelFloat FROM invGroups g LEFT JOIN invTypes i ON i.groupID = g.groupID LEFT JOIN dgmTypeAttributes dta ON dta.typeID = i.typeID AND dta.attributeID IN (182, 183, 184, 1285, 1289, 1290) LEFT JOIN dgmTypeAttributes dtal ON dtal.typeID = dta.typeID AND ( (dtal.attributeID = 277 AND dta.attributeID = 182) OR (dtal.attributeID = 278 AND dta.attributeID = 183) OR (dtal.attributeID = 279 AND dta.attributeID = 184) OR (dtal.attributeID = 1286 AND dta.attributeID = 1285) OR (dtal.attributeID = 1287 AND dta.attributeID = 1289) OR (dtal.attributeID = 1288 AND dta.attributeID = 1290) ) JOIN invTypes ip ON ip.typeID = dta.valueInt OR ip.typeID = dta.valueFloat WHERE i.typeID NOT IN (19430, 9955) AND i.published = 1 AND g.categoryID NOT IN (0,1,2,3,25) ORDER BY g.groupName DESC
EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI