All pastes #185324 Raw Edit

Something

public text v1 · immutable
#185324 ·published 2006-09-28 20:55 UTC
rendered paste body
select t1.solarSystemName,t2.solarSystemName,sqrt(pow(t1.x-t2.x,2)+pow(t1.x-t2.x,2)+pow(t1.x-t2.x,2))/9.4605284e15 as distance from (SELECT solarSystemID,solarSystemName,security,x,y,z FROM mapSolarSystems where regionID = 10000009) t1 join (select solarSystemID,solarSystemName,security,x,y,z from mapSolarSystems where security >= 0.45) t2