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