select creation_user as homework_user_id from acs_objects where object_id = :homework_file_id update acs_objects set context_id = null where object_id = :file_id update cr_revisions set content = :tmp_filename, content_length = :tmp_size where revision_id = :revision_id select f.name, folder.label as folder_name, p.first_names || ' ' || p.last_name as student_name from cr_items f, cr_folders folder, persons p, acs_objects o where f.item_id = :file_id and o.object_id = :file_id and folder.folder_id = :folder_id and p.person_id = o.creation_user select f.name, folder.label as folder_name, p.first_names || ' ' || p.last_name as admin_name from cr_items f, cr_folders folder, persons p where item_id = :homework_file_id and folder.folder_id = :folder_id and p.person_id = :user_id