Skip to content

Instantly share code, notes, and snippets.

@sn0opy
Created July 1, 2014 08:25
Show Gist options
  • Save sn0opy/79c80cdaad9767b14393 to your computer and use it in GitHub Desktop.
Save sn0opy/79c80cdaad9767b14393 to your computer and use it in GitHub Desktop.
EVE: Find Level 4 Security agents in low sec (dirty)
SELECT
mapSolarSystems.security, solarSystemName
FROM
mapSolarSystems, agtAgents, staStations
WHERE
divisionID = 24
AND staStations.stationID = agtAgents.locationID
AND staStations.solarSystemID = mapSolarSystems.solarSystemID
AND agtAgents.level = 4
AND agtAgents.agentTypeID = 2
AND mapSolarSystems.security >= 0.05
AND mapSolarSystems.security <= 0.44
GROUP BY
solarSystemName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment