select object_type from acs_objects where object_id = :folder_id select parent_id from cr_items where item_id = :item_id select mime_type from cr_mime_types where file_extension = :file_extension insert into cr_mime_types (mime_type, file_extension) values (:mime_type, :extension) 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 * from (select cr_items.item_id as object_id, cr_items.name from cr_items where cr_items.parent_id = :folder_id union all select fs_simple_objects.object_id, fs_simple_objects.name from fs_simple_objects where fs_simple_objects.folder_id = :folder_id) contents where exists (select 1 from acs_object_party_privilege_map m where m.object_id = contents.object_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_objects.* from fs_objects where fs_objects.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 content from cr_revisions where revision_id = $live_revision select filename from cr_revisions where revision_id = :live_revision