habitats-annex1-search-listing

select 
    code_2000,
    TRIM(REPLACE(REPLACE(scientific_name, '[', ''), ']', '')) as scientific_name,
	habitat_unique_id,
	habitat_category,
	CONCAT('/habitats/', habitat_unique_id) as habitat_link
from EUNIS.latest.Habitat_Information
where habitat_category = 'ANNEX1' and code_2000 != '' and id_dc is not null
order by code_2000