MS SQL query to get solar systems as clickable Links

SELECT '<tr><td><a href=javascript:CCPEVE.showInfo(5,',
       solarSystemID,
       ')>',
       solarSystemName,
       '</a></td><td><a href=javascript:CCPEVE.showInfo(4,',
       constellationID,
       ')>',

  (SELECT constellationName
   FROM mapConstellations AS c
   WHERE s.constellationID = c.constellationID) AS 'constellationName',
       '</a></td><td></td><td>Null</td>' AS 'Filler',
       '<td><a href=javascript:CCPEVE.showInfo(3,',
       regionID,
       ')>',

  (SELECT regionName
   FROM mapRegions AS r
   WHERE s.regionID= r.regionID) AS 'regionName',
       '</a></td></tr>'
FROM mapSolarSystems AS s