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);

## result

    name
-------------
 Foo Company
 Foo Company
 IBM
 IBM
 IBM