postgresql
7.2
SELECT
p.customer_id,
c.name as customer_name
FROM
pm_projectsx p
LEFT JOIN organizations c ON p.customer_id = c.organization_id
WHERE
p.project_id = :original_project_id
and exists (select 1 from acs_object_party_privilege_map ppm
where ppm.object_id = :original_project_id
and ppm.privilege = 'read'
and ppm.party_id = :user_id)