oracle8.1.6 select first_names, last_name, email, nvl(screen_name,'< none set up >') as screen_name, creation_date, creation_ip, last_visit, member_state, email_verified_p, url from cc_users where user_id = :user_id select live_revision as revision_id, nvl(title,'view this portrait') portrait_title from acs_rels a, cr_items c, cr_revisions cr where a.object_id_two = c.item_id and c.live_revision = cr.revision_id and a.object_id_one = :user_id and a.rel_type = 'user_portrait_rel' select at.pretty_name, at.pretty_plural, a.creation_date, acs_object.name(a.object_id) object_name from acs_objects a, acs_object_types at where a.object_type = at.object_type and a.creation_user = :user_id order by object_name, creation_date