Bern Convention Resolution No 4 Tree View

SELECT habitat_type_tree from [EUNIS].[latest].[Habitat_Legal_Status_Mentioned] lsm, eunis.latest.habitat_information h where h.habitat_unique_id=lsm.habitat_unique_id and lsm.id_dc=2467 order by habitat_type_tree