select segment_id
from rel_segments
where segment_name = 'dotLRN Users'
select theme_id
from dotlrn_users
where user_id = :user_id
update dotlrn_user_profile_rels
set theme_id = :theme_id
where rel_id = (select rel_id
from dotlrn_users
where user_id = :user_id)
select portal_id
from dotlrn_users
where user_id = :user_id
select dotlrn_user_types.group_id
from dotlrn_user_types
where dotlrn_user_types.type = :type
insert into dotlrn_portal_types_map
(type, portal_id)
values
(:type, :portal_id)
select type from dotlrn_portal_types_map where portal_id = :portal_id
select portal_id from dotlrn_portal_types_map where type = :type
select rel_id, rel_type, object_id_one
from acs_rels
where object_id_two = :from_user_id
and object_id_one not in (select object_id_one
from acs_rels
where object_id_two = :to_user_id )
select rel_id, rel_type, object_id_one
from acs_rels
where object_id_two = :user_id