{sql:SELECT her_core.watprn as 'id',  her_core.name as 'Name',ggat_projects.effect as 'Effect', ggat_projects.mitigation as 'Mitigation'
FROM her_core

LEFT JOIN ggat_projects ON her_core.watprn = ggat_projects.watprn

where `her_core`.`watprn` IN(search_selection(`her_core`))

group by `her_core`.`watprn`}