select object_type
from acs_objects
where object_id = :folder_id
select parent_id
from cr_items
where item_id = :item_id
select item_id
from cr_items
where parent_id = :parent_id
and name = :name
select count(*)
from dual
where exists (select 1
from fs_objects
where object_id = :object_id)
select name
from fs_objects
where object_id = :object_id
select count(*)
from dual
where exists (select 1
from fs_folders
where folder_id = :object_id)
select cr_items.item_id as object_id,
cr_items.name
from cr_items
where cr_items.parent_id = :folder_id
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = cr_items.item_id
and m.party_id = :user_id
and m.privilege = 'read')
select count(*)
from fs_objects
where parent_id = :folder_id
select fs_objects.*
from fs_objects
where fs_objects.object_id = :object_id
select fs_urls_full.*
from fs_urls_full
where fs_urls_full.object_id = :object_id
select fs_objects.*,
cr_items.storage_type,
cr_items.storage_area_key,
cr_revisions.title
from fs_objects,
cr_items,
cr_revisions
where fs_objects.object_id = :object_id
and fs_objects.object_id = cr_items.item_id
and fs_objects.live_revision = cr_revisions.revision_id
select filename
from cr_revisions
where revision_id = :live_revision