Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2014
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. 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;
  2. solarSystemName | security | solarSystemID | activityID | costIndex
  3. -------------------+----------+---------------+------------+---------------------
  4. Jita | 0.945913 | 30000142 | 4 | 0.0007536419414749
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement