habitats-eunis2012-search-listing

select
    TRIM(REPLACE(REPLACE(scientific_name, '[', ''), ']', '')) as scientific_name,
	habitat_unique_id,
        eunis_habitat_code,
	habitat_category,
	CONCAT('/habitats_eunis2012/', habitat_unique_id) as habitat_link
from EUNIS.latest.Habitat_Information
where habitat_category = 'EUNIS2012' and TRIM(eunis_habitat_code) != '-'
order by eunis_habitat_code