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, community_type, pretty_name as name, parent_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 pretty_name
from dotlrn_communities_all
where community_id = :parent_community_id