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 ra.regionName, a.solarSystemName;