Advanced Armor Layering

EVE Technology and Research Center Third Party Developers
1

ol

I am running the following query to get back groups and skills:

  SELECT 
       t."typeID",
       t."typeName",
       g."groupID",
       g."groupName"
  FROM "invTypes" t
  JOIN "invGroups" g ON g."groupID" = t."groupID"
  JOIN "invCategories" c on c."categoryID" = g."categoryID"
  WHERE g."categoryID" = 16      -- The “Skill” category
  AND t."published" = true     -- Optional: only published skills
  ORDER BY g."groupName" asc;

I cannot find the Advanced Armor Layering in the results. Where is that skill ? I might be missing something…

Thanks

2

You’re pulling this data from a source - is the source up-to-date?

It’s present in the current SDE under category 16 (skills) and is published, so if it’s in the db you’re trying to pull that data from, it should load.