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