select crr.title, crr.item_id
from evaluation_tasks_sols ets, cr_revisions crr
where ets.solution_id = :solution_id
and crr.revision_id = ets.solution_id
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id
update cr_revisions
set content_length = :content_length
where revision_id = :revision_id
select task_item_id
from evaluation_tasks
where task_id = :task_id
update cr_revisions
set content = :url
where revision_id = :revision_id