Belt count and true security status for Solar Systems in the same constellation

From EVEDev

 
SELECT m.solarsystemName, m.`security`, count(*) AS belts
FROM mapdenormalize d, mapsolarsystems m, mapconstellations c
WHERE d.typeID=15
AND m.solarSystemID=d.solarSystemID
AND c.constellationID=m.constellationID
AND c.constellationName='XPBM-F'
GROUP BY d.solarSystemID;