Natura 2000 - birds breeding habitat

SELECT 
ltrim(str(id_eunis,10)) as id_eunis,
string_agg(name_ecosystem,', ') as name_ecosystem
FROM [EUNIS].[latest].[Species_Preferred_Ecosystem_Birds]
WHERE id_association='P' AND id_season='B'
GROUP BY id_eunis