postgresql7.4
select content_revision__get_content(ets.solution_id) as content,
crr.title,
crr.item_id,
cri.storage_type
from evaluation_tasks_sols ets, cr_items cri, cr_revisions crr
where ets.solution_id = :solution_id
and ets.solution_id = crr.revision_id
and crr.item_id = cri.item_id
content_revision__content_copy(:solution_id, :revision_id)