ANNEX1 Tree view

SELECT id_habitat, replace(habitat_type_tree,'ANNEX1_$ - All Annex I habitats|','') habitat_type_tree
FROM [EUNIS].[latest].[Habitat_Information] h1 WHERE habitat_category = 'ANNEX1' and id_habitat>10000
order by habitat_type_tree