Skills for a career

From EVEDev

-- skills for a career
SELECT
   skills.skillTypeID,
   invTypes.typeName,
   invTypes.groupID,
   invGroups.groupName,
   sum(skills.levels) as levels,
   dgmTypeAttributes.valueFloat as rank
FROM (
   SELECT
       skilltypeID, levels
   FROM
       chrRaceSkills
   WHERE
       chrRaceSkills.raceID = 1
   UNION ALL SELECT
       skillTypeID, levels
   FROM
       chrCareerSkills
   WHERE
       chrCareerSkills.careerID = 11
   UNION ALL SELECT
       skillTypeID, levels
   FROM
       chrCareerSpecialtySkills
   WHERE
       chrCareerSpecialtySkills.specialtyID = 12
) AS skills
INNER JOIN
   invTypes ON (invTypes.typeID = skills.skillTypeID)
INNER JOIN
   invGroups ON (invGroups.groupID = invTypes.groupID)
INNER JOIN
   dgmTypeAttributes ON (skills.skillTypeID = dgmTypeAttributes.typeID)
INNER JOIN
   dgmAttributeTypes ON (dgmTypeAttributes.attributeID = dgmAttributeTypes.attributeID)
WHERE
   dgmTypeAttributes.attributeID = 275
GROUP BY
   skills.skillTypeID
ORDER BY
   invGroups.groupName;

---

MySQL returned an error: Table 'evedb.chrRaceSkills' doesn't exist!

---