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 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 count(*) from cr_items where name=:name and parent_id=:parent_id select item_id from cr_items where name=:name and parent_id=:parent_id select parent_id from cr_items where item_id=:item_id select i.name as title, r.title as version_name from cr_items i, cr_revisions r where i.item_id = r.item_id and r.revision_id = :version_id update cr_folders set description=:description where folder_id = :folder_id select storage_type from cr_items where item_id=:item_id select package__id from acs_objects where object_id = :file_id select storage_type from cr_items where item_id=:item_id update cr_items set live_revision=:revision_id where item_id=:item_id update cr_revisions set content = :cr_file, content_length = :file_size where revision_id = :revision_id select count(*) from cr_items where name=:name and parent_id=:parent_id select i.name, i.latest_revision as file_rev_id, r.title from cr_items i, cr_revisions r where i.item_id = :file_id and r.revision_id = i.latest_revision update cr_revisions set title = :title where revision_id = :new_file_rev_id select symlink_id from cr_symlinks where target_id=:item_id select i.name, i.latest_revision as file_rev_id, r.title from cr_items i, cr_revisions r where i.item_id = :file_id and r.revision_id = i.latest_revision update cr_revisions set title = :title where revision_id = :new_file_rev_id select coalesce(title,name) as prettyname from fs_objects where object_id = :object_id