SELECT object_type FROM acs_objects WHERE object_id= :object_id SELECT name as object_name FROM forums_forums WHERE forum_id=:object_id SELECT faq_name as object_name FROM faqs WHERE faq_id = :object_id SELECT title as object_name FROM acs_objects WHERE object_id = :object_id SELECT pretty_name as object_name FROM static_portal_content WHERE content_id = :object_id; SELECT title as object_name FROM acs_objects WHERE object_id = :object_id SELECT title as object_name FROM acs_objects WHERE object_id = :object_id SELECT community_id FROM dotlrn_communities_all WHERE community_id <> :comm_id and community_type='dotlrn_club' and (parent_community_id <> community_id or parent_community_id is null) and (community_id in (SELECT dca.community_id FROM dotlrn_community_applets dca, dotlrn_applets da WHERE dca.applet_id = da.applet_id and da.applet_key= :object_type)) SELECT community_id FROM dotlrn_communities_all dca, dotlrn_classes dc, dotlrn_departments dd WHERE dca.community_id <> :comm_id and dca.community_type = dc.class_key and dc.department_key=dd.department_key and dd.department_key=:department_key and (parent_community_id <> community_id or parent_community_id is null) and (community_id in (SELECT dca.community_id FROM dotlrn_community_applets dca, dotlrn_applets da WHERE dca.applet_id = da.applet_id and da.applet_key=:object_type)) SELECT community_id FROM dotlrn_communities_all dca WHERE dca.community_id <> :comm_id and dca.community_type <> 'dotlrn_club' and (parent_community_id <> community_id or parent_community_id is null) and (community_id in (SELECT dca.community_id FROM dotlrn_community_applets dca, dotlrn_applets da WHERE dca.applet_id = da.applet_id and da.applet_key=:object_type)) SELECT community_id as dest_community_id, community_type, pretty_name as name, parent_community_id FROM dotlrn_communities_all WHERE community_id in ([join $communities_list_p ","]) SELECT pretty_name FROM dotlrn_communities_all WHERE community_id = :parent_community_id SELECT object_id as trash_id FROM acs_objects WHERE object_type='trash' and title IS NULL and context_id IS NULL and package_id IS NULL; SELECT b.object_id as trash_package_id FROM acs_objects as a,acs_objects as b WHERE a.context_id=:community_id and a.object_type='apm_package' and a.object_id=b.context_id and b.title='Datamanager';