All Skills published and displayed in their own groups such as Corporation Management etc...

From EVEDev
Jump to: navigation, search
SELECT groupname, typename, invGroups.groupid, invTypes.typeid
FROM invGroups
JOIN invTypes on invGroups.groupid = invTypes.groupid
WHERE categoryid = 16 AND invTypes.published = 1 AND invGroups.published = 1
ORDER BY groupname ASC, typename ASC;

UNIQ6c6458256d5de88e-sql-00000001-QINU

Personal tools