{sql:SELECT her_core.watprn as 'id',  her_core.name as 'Name',her_core.summary as 'Summary',geo_locations.ngr as 'NGR',geo_locations.east as 'X',geo_locations.nrth as 'Y',her_core_site_type.period as 'Period',her_core_site_type.type as 'Type',her_core_site_type.broadclass as 'Broadclass',her_status.status as 'Status',her_status.reference as 'Status Reference',geo_locations.unitary as 'Unitary Authority',geo_locations.community as 'Community', ('http://www.walesher1974.org/her/groups/GGAT/media/'+her_source1.url) as Link
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_source1_link ON her_source1_link.watprn = her_core.watprn

LEFT JOIN her_source1 ON her_source1_link.source_id = her_source1.rowid

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

{sql:SELECT her_event.watprn as 'id',  her_event.name as 'Name', her_source1.url as 'Report Link'
FROM her_event

LEFT JOIN her_event ON her_source1_link.watprn = her_event.watprn
LEFT JOIN her_source1 ON her_source1_link.source_id = her_source1.rowid
where `her_event`.`watprn` IN(search_selection(`her_core`))}