Objects by groupID

From EVEDev

This query will return all objects in a solarSystem that have a specifig groupID. For example, 6 as groupID will return all stars, 7 as groupID will return all planets, 8 as groupID will return all Moons, 9 as groupID will return all asteroid belts/ice fields and 10 as groupID will return all Stargates

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;