Objects in a SolarSystem

This query will return all objects present in a SolarSystem. Note that such a query might take a while.

 
SELECT it.typeName, md.itemName FROM mapDenormalize AS md
  INNER JOIN invTypes AS it ON md.typeID=it.typeID
  WHERE solarSystemID =
    (SELECT solarSystemID FROM mapSolarSystems
      WHERE solarSystemName = 'New Caldari') --SOLARSYSTEM NAME HERE
  ORDER BY md.typeID, itemName;
 

UNIQ2e72ee7551bb8629-sql-00000001-QINU