Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- eve=> SELECT s."solarSystemName", s."security", i.* FROM "industryCostIndices" i JOIN "mapSolarSystems" s ON (i."solarSystemID" = s."solarSystemID") WHERE i."activityID" = 4 AND "security" > 0.5 ORDER BY "costIndex" ASC;
- solarSystemName | security | solarSystemID | activityID | costIndex
- -------------------+----------+---------------+------------+---------------------
- Jita | 0.945913 | 30000142 | 4 | 0.0007536419414749
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement