Objects in a SolarSystem

From EVEDev

Jump to: navigation, search

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;
 
typeNameitemName
Planet (Temperate)New Caldari I (Matigu)
Planet (Temperate)New Caldari II (Matias)
Planet (Temperate)New Caldari Prime
Planet (Ice)New Caldari III (Orieku)
MoonNew Caldari I (Matigu) - Moon 1
MoonNew Caldari III (Orieku) - Moon 1
MoonNew Caldari Prime - Moon 1
MoonNew Caldari Prime - Moon 2
MoonNew Caldari Prime - Moon 3
MoonNew Caldari V (Oniteseru) - Moon 1
MoonNew Caldari V (Oniteseru) - Moon 2
MoonNew Caldari V (Oniteseru) - Moon 3
Asteroid BeltNew Caldari II (Matias) - Asteroid Belt 1
Asteroid BeltNew Caldari III (Orieku) - Asteroid Belt 1
Stargate (Caldari System)Stargate (Jita)
Stargate (Caldari System)Stargate (Niyabainen)
Station (Caldari 1)New Caldari V (Oniteseru) - Moon 2 - House of Records Archives
Station (Caldari 3)New Caldari Prime - Moon 1 - Chief Executive Panel Bureau
Planet (Oceanic)New Caldari V (Oniteseru)
Sun G3 ( Pink Small )New Caldari - Star
Caldari Mining StationNew Caldari I (Matigu) - Poksu Mineral Group Mineral Reserve
Caldari Mining StationNew Caldari Prime - Moon 1 - Poksu Mineral Group Mineral Reserve
Caldari Food Processing Plant StationNew Caldari II (Matias) - Kaalakiota Corporation Factory
Stargate (Caldari Constellation)Stargate (Hirtamon)
Stargate (Caldari Constellation)Stargate (Josameto)
Stargate (Caldari Region)Stargate (Alikara)
Stargate (Caldari Region)Stargate (Malkalen)
Retrieved from "http://wiki.eve-id.net/Objects_in_a_SolarSystem"
Personal tools