postgresql7.1
select fs_objects.object_id, fs_objects.name, fs_objects.title
from fs_objects
where fs_objects.type='folder'
and fs_objects.parent_id = :parentfolderid
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = fs_objects.object_id
and m.party_id = :viewing_user_id
and m.privilege = 'read') order by fs_objects.title
select count(*) from fs_objects where parent_id = :object_id and type='folder'