Natura 2000 - species suitable habitat

SELECT 
ltrim(str(id_eunis,10)) as id_eunis,
string_agg(name_ecosystem,', ') as name_ecosystem
FROM [EUNIS].[latest].[Species_Preferred_Ecosystem_Non_Birds]
WHERE id_association='S'
GROUP BY id_eunis