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