select first_names, last_name from persons where person_id = :user_id select description from cr_revisions where revision_id = (select live_revision from cr_items c, acs_rels a where c.item_id = a.object_id_two and a.object_id_one = :user_id and a.rel_type = 'user_portrait_rel') update cr_revisions set description=:description where revision_id = (select live_revision 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')