From EVEDev
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;
| lowsec | region |
|---|
| Adeel | Everyshore |
| Basgerin | Sinq Laison |
| Chardalane | Placid |
| Ebodold | Heimatar |
| Estaunitte | Essence |
| Gyerzen | Tash-Murkon |
| Hedgiviter | Heimatar |
| Horkkisen | The Citadel |
| Mai | Domain |
| Nourbal | Khanid |
| Olfeim | Heimatar |
| Pakkonen | Lonetrek |
| Ravarin | Sinq Laison |
| Thakala | Devoid |
| Zanka | Domain |