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 dct.pretty_name, dd.department_key
FROM dotlrn_departments dd, dotlrn_community_types dct
WHERE dct.community_type=dd.department_key