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 update cr_revisions set content = :filename, mime_type = :mime_type, 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