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';