Objects by groupID

From EVEDev

This query will return all objects in a solarSystem that have a specifig groupID. For example, 7 as groupID will return all planets.

SELECT itemName FROM mapDenormalize
WHERE solarSystemID = (SELECT solarSystemID FROM mapSolarSystems WHERE solarSystemName = 'SOLARSYSTEM') AND groupID = GROUPNUM;

To see a list of all available groups run this query:

SELECT * FROM invGroups;