all-sites-natura2000-search-listing

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