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 (parent_community_id <> community_id or parent_community_id is null) and (community_id in (select community_id from dotlrn_community_applets applets where applet_id = (select applet_id from dotlrn_applets where 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';