SELECT organizations.name FROM "organizations"
INNER JOIN "domain_memberships" ON "domain_memberships".domain_member_id = "organizations".id AND "domain_memberships".domain_member_type = E'Organization'
WHERE (domain_memberships.domain_id in (1,2,3)) GROUP BY domain_memberships.domain_id,organizations.name;