SELECT live_revision as revision_id, item_id FROM acs_rels a, cr_items c WHERE a.object_id_two = c.item_id AND a.rel_type = 'user_portrait_rel' AND a.object_id_one = :current_user_id AND c.live_revision is not NULL select description from cr_revisions where revision_id = :revision_id select first_names, last_name from persons where person_id=:user_id