Forum OpenACS Development: Re: OpenACS Permissions System - Performance Improvement Work

C is the right way although the where clause should be
 WHERE
        p.project_id = i.live_revision and
        s.status_id = p.status_id 
    and exists(select 1 from acs_object_party_privilege_map ppm where ppm.object_id = p.project_id and ppm.party_id = -1 and ppm.privilege = 'admin');
i.e. no reason for the select there.