Other Habitats - Species

select distinct
habitat_unique_id,
scientific_name,
species_group_common_name,
id_eunis,
relationship_code,
relationship_description
from EUNIS.latest.Habitat_Indicator_Species
order by relationship_code asc