SQL:All published skills ordered by skill-group

From EVEDev

 
    SELECT groups.groupID,
        groups.groupName AS groupName,
        invTypes.typeName AS skillName,
        invTypes.description,
        invTypes.typeID
    FROM ( SELECT * FROM invGroups WHERE categoryID = 16 AND published = 1 ) AS groups
    INNER JOIN invTypes ON ( invTypes.groupID = groups.groupID AND invTypes.published = 1 )
    ORDER BY groupName;
 

You can, of course, add as many invTypes requirements for this query to the SELECT clause.

---

Error while connecting to host "" !

---