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
select tree_sortkey,item_id,tree_level(tree_sortkey) as tree_level
from cr_items
where item_id in ([join $object_id ","])
order by item_id
select tree_ancestor_p(:c_item,:tree_sortkey)
select tree_ancestor_p(:tree_sortkey,:c_item)
SELECT dct.pretty_name, dd.department_key
FROM dotlrn_departments dd, dotlrn_community_types dct
WHERE dct.community_type=dd.department_key