{sql:SELECT her_core.watprn as 'id',  her_core.name as 'Name',geo_locations.ngr as 'NGR',her_core_site_type.period as 'Period',her_core_site_type.type as 'Type',her_status.status as 'Status',ggat_projects.value as 'Value', ggat_projects.rarity as 'Rarity'
FROM her_core
LEFT JOIN geo_locations ON her_core.watprn = geo_locations.watprn
LEFT JOIN her_core_site_type ON her_core.watprn = her_core_site_type.watprn
LEFT JOIN her_status ON her_core.watprn = her_status.watprn

LEFT JOIN her_condition ON her_core.watprn = her_condition.watprn

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`}