all-sites-emerald-search-listing

select code_site as site_code,
	site_name,
	country_name,
	site_type,
	CONCAT('/sites/emerald/', code_site) as site_link
from EUNIS.latest.Site_Information
where site_type = 'Emerald site'
order by country_name