habitats-res4-search-listing

select
    TRIM(REPLACE(REPLACE(h.scientific_name, '[', ''), ']', '')) as scientific_name,
    h.habitat_category,
    h.habitat_unique_id,
    h.eunis_habitat_code,
    CONCAT('/habitats_res4/', h.habitat_unique_id) AS habitat_link
from EUNIS.latest.Habitat_Information h
join EUNIS.latest.Habitat_legal_status_mentioned ls
    on h.habitat_unique_id = ls.habitat_unique_id
   and ls.id_dc = 2467
ORDER BY eunis_habitat_code