select * from dotlrn_member_rels_full where user_id = :user_id and community_id = :community_id select * from dotlrn_member_rels_full where user_id = :user_id and community_id = :community_id update dotlrn_community_types set portal_id = :portal_id where community_type = :community_type update dotlrn_community_types set package_id= :package_id where community_type= :community_type update dotlrn_communities set package_id= :package_id where community_id= :community_id select dotlrn_communities.parent_community_id from dotlrn_communities where dotlrn_communities.community_id = :community_id select count(*) from dotlrn_communities_all where :parent_community_id in (select dc.parent_community_id from dotlrn_communities_all dc where dc.community_key = :community_key) select count(*) from dotlrn_communities_all where community_key = :community_key select node_id from site_nodes where object_id = (select package_id from dotlrn_community_types where community_type = :community_type) select node_id from site_nodes where object_id = (select package_id from dotlrn_communities where community_id = :community_id) update dotlrn_communities set portal_id = :portal_id, non_member_portal_id = :non_member_portal_id, admin_portal_id = :admin_portal_id where community_id = :community_id select role_two from acs_rel_types where rel_type = :rel_type select pretty_name from acs_rel_roles where role = (select role_two from acs_rel_types where rel_type = :rel_type) select segment_id from rel_segments where group_id = :community_id and rel_type= :rel_type select dotlrn_member_rels_approved.rel_id, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, dotlrn_member_rels_approved.user_id, registered_users.first_names, registered_users.last_name, registered_users.email from registered_users, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = registered_users.user_id order by dotlrn_member_rels_approved.rel_type, registered_users.last_name select dotlrn_member_rels_approved.rel_id, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, dotlrn_member_rels_approved.user_id, registered_users.first_names, registered_users.last_name, registered_users.email from registered_users, dotlrn_member_rels_approved, dotlrn_communities where dotlrn_communities.community_id = :subcomm_id and dotlrn_communities.parent_community_id = dotlrn_member_rels_approved.community_id and registered_users.user_id = dotlrn_member_rels_approved.user_id and registered_users.user_id not in (select dm.user_id from dotlrn_member_rels_approved dm where dm.community_id = :subcomm_id) order by dotlrn_member_rels_approved.rel_type select dotlrn_member_rels_approved.rel_id, dotlrn_member_rels_approved.rel_type, dotlrn_member_rels_approved.role, dotlrn_member_rels_approved.user_id, registered_users.first_names, registered_users.last_name, registered_users.email from registered_users, dotlrn_member_rels_approved where dotlrn_member_rels_approved.community_id = :community_id and dotlrn_member_rels_approved.user_id = registered_users.user_id and dotlrn_member_rels_approved.rel_type = :rel_type select count(*) from dual where exists (select 1 from dotlrn_member_rels_approved where community_id = :community_id and user_id = :user_id) select count(*) from dual where exists (select 1 from dotlrn_member_rels_full where community_id = :community_id and user_id = :user_id and member_state = 'needs approval') select rel_id from dotlrn_member_rels_full where community_id = :community_id and user_id = :user_id select dotlrn_communities_full.* from dotlrn_communities_full, dotlrn_member_rels_approved where dotlrn_communities_full.community_id = dotlrn_member_rels_approved.community_id and dotlrn_member_rels_approved.user_id = :user_id select dotlrn_communities.* from dotlrn_communities, dotlrn_member_rels_full where dotlrn_communities.community_type = :community_type and dotlrn_member_rels_full.user_id = :user_id and dotlrn_communities.community_id = dotlrn_member_rels_full.community_id select dotlrn_communities.* from dotlrn_communities where community_type = :community_type select community_type from dotlrn_community_types where package_id = :package_id select community_type from dotlrn_communities where community_id = :community_id select 1 from dual where exists (select 1 from dotlrn_communities where parent_community_id = :community_id) select community_id as subcomm_id from dotlrn_communities where parent_community_id = :community_id select community_id, community_key, pretty_name, url from dotlrn_communities_full where parent_community_id = :community_id order by pretty_name select package_id from dotlrn_community_types where community_type = :community_type select package_id from dotlrn_communities where community_id = :community_id select package_id from dotlrn_community_applets dca, dotlrn_applets da where community_id = :community_id and applet_key = :applet_key and dca.applet_id = da.applet_id select pretty_name from dotlrn_community_types where community_type = :community_type update dotlrn_communities set pretty_name = :pretty_name where community_id = :community_id select pretty_name from dotlrn_communities where community_id = :community_id select description from dotlrn_communities where community_id = :community_id select community_key from dotlrn_communities where community_id = :community_id select 1 from dotlrn_active_comms_not_closed where community_id = :community_id select 1 from dotlrn_active_comms_not_closed where community_id = :community_id and join_policy = 'open' select 1 from dotlrn_active_comms_not_closed where community_id = :community_id and join_policy = 'needs approval' delete from dotlrn_community_applets where community_id= :community_id and applet_id = :applet_id update dotlrn_communities set portal_id = :portal_id, non_member_portal_id = :non_member_portal_id, admin_portal_id = :admin_portal_id where community_id = :clone_id update dotlrn_communities set archived_p = 't' where community_id = :community_id update dotlrn_communities set archived_p = 'f' where community_id = :community_id select portal_id from dotlrn_communities where community_id = :community_id select non_member_portal_id from dotlrn_communities where community_id = :community_id select admin_portal_id from dotlrn_communities where community_id = :community_id insert into dotlrn_community_applets (community_id, applet_id, package_id, active_p) values (:community_id, :applet_id, :package_id, :active_p) delete from dotlrn_community_applets where community_id = :community_id and applet_id = :applet_id select impl_name from acs_sc_impls, acs_sc_bindings, acs_sc_contracts where acs_sc_impls.impl_id = acs_sc_bindings.impl_id and acs_sc_contracts.contract_id = acs_sc_bindings.contract_id and acs_sc_contracts.contract_name = 'dotlrn_applet' select applet_key from dotlrn_community_applets dca, dotlrn_applets da where community_id = :community_id and dca.applet_id = da.applet_id select applet_key from dotlrn_applets where status = 'active' select applet_key from dotlrn_community_applets dca, dotlrn_applets da where community_id = :community_id and active_p = 't' and dca.applet_id = da.applet_id and status = 'active' select 1 from dotlrn_community_applets dca, dotlrn_applets da where community_id = :community_id and da.applet_key = :applet_key and active_p = 't' and dca.applet_id = da.applet_id and status = 'active' select count(*) from dotlrn_community_types where supertype = :community_type select attribute_id, attribute_name from acs_attributes where object_type = 'dotlrn_community' select acs_attributes.attribute_name, acs_attribute_values.attr_value from acs_attributes, acs_attribute_values where acs_attribute_values.object_id = :community_id and acs_attribute_values.attribute_id = acs_attributes.attribute_id insert into acs_attribute_values (object_id, attribute_id, attr_value) values (:community_id, :attribute_id, :attribute_value) update acs_attribute_values set attr_value = :attribute_value where object_id = :community_id