habitats-eunisrevised-search-listing

select
    TRIM(REPLACE(REPLACE(scientific_name, '[', ''), ']', '')) as scientific_name,
	habitat_unique_id,
eunis_habitat_code,
	habitat_category,
	CONCAT('/habitats_eunis_revised/', habitat_unique_id) as habitat_link
from EUNIS.latest.Habitat_Information
where habitat_category = 'EUNISrev'
order by eunis_habitat_code