select c.item_id
from acs_rels a, cr_items c
where a.object_id_two = c.item_id
and a.object_id_one = :user_id
and a.rel_type = 'user_portrait_rel'
select et.task_name,
et.number_of_members,
et.due_date,
et.weight,
et.online_p,
et.late_submit_p,
et.requires_grade_p,
crr.lob, crr.content,
crr.content_length,
crr.title,
crr.description,
crr.mime_type,
cri.storage_type
from evaluation_tasksi et,
cr_revisions crr,
cr_items cri
where task_id = :from_task_id
and et.task_id = crr.revision_id
and cri.item_id = crr.item_id
update cr_revisions
set content = :content,
content_length = :content_length,
lob = :lob
where revision_id = :revision_id
update cr_items
set name = :item_name,
storage_type = :storage_type
where item_id = :item_id
update cr_items
set name = :item_name,
storage_type = :storage_type
where item_id = :item_id
update cr_items
set name = :item_name,
storage_type = :storage_type
where item_id = :item_id
select eg.grade_id
from evaluation_tasks est, evaluation_grades eg, cr_items cri
where est.task_id = :task_id
and est.grade_item_id = eg.grade_item_id
and cri.live_revision = eg.grade_id
select et.task_name, et.number_of_members, et.task_item_id
from evaluation_tasks et
where et.task_id = :task_id
$sql_query
select eg.grade_name,
et.task_name
from evaluation_grades eg,
evaluation_tasks et,
cr_items cri
where et.task_id = :task_id
and et.grade_item_id = eg.grade_item_id
and cri.live_revision = eg.grade_id
select lob
from cr_revisions
where revision_id = :revision_id