{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'
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

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