All lowsec dead-end systems

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;