Low sec dead-end systems bordering high sec

From EVEDev

Jump to: navigation, search
 
SELECT a.solarSystemName AS lowsec, ra.regionName AS region
FROM (
    SELECT m.`fromSolarSystemID` AS fromID, m.`toSolarSystemID` AS toID
    FROM mapSolarSystemJumps m
    GROUP BY fromID
    HAVING count(fromID)=1)
    AS deadEnds,
    mapSolarSystems a,
    mapSolarSystems b,
    mapRegions ra
WHERE a.solarSystemID=deadEnds.fromID
AND a.`security` < 0.45
AND a.`security` > 0
AND b.solarSystemID=deadEnds.toID
AND b.`security` >= 0.45
AND ra.regionID=a.regionID
ORDER BY a.solarSystemName;
 
lowsecregion
AdeelEveryshore
BasgerinSinq Laison
ChardalanePlacid
EbodoldHeimatar
EstaunitteEssence
GyerzenTash-Murkon
HedgiviterHeimatar
HorkkisenThe Citadel
MaiDomain
NourbalKhanid
OlfeimHeimatar
PakkonenLonetrek
RavarinSinq Laison
ThakalaDevoid
ZankaDomain
Personal tools