EUNIS 2012 Tree View

SELECT habitat_type_tree FROM [EUNIS].[latest].[Habitat_Information] h1 WHERE habitat_category = 'EUNIS2012' AND habitat_unique_id NOT IN ('EUNIS2012_-') AND habitat_type_tree LIKE '%|%' 
ORDER BY habitat_type_tree