SELECT
	org.id               AS id,
	org.legalshortname   AS legalshortname,
	org.legalname        AS legalname,
	org.websiteurl       AS websiteurl,
	org.logourl          AS logourl,
	org.country          AS country,
	org.collectedfrom    AS collectedfrom,
	org.dateofcollection AS dateofcollection,
	org.provenanceaction AS provenanceaction
FROM
	dsm_organizations org
	LEFT OUTER JOIN dsm_service_organization dso ON (org.id = dso.organization)
WHERE 
	dso.service = :dsId
