postgresql7.1
select site_node__url(n2.node_id) as url, n2.object_id,
acs_object__name(n2.object_id) as object_name,
tree_level(n2.tree_sortkey) as level
from (select * from site_nodes where node_id = :node_id) n1,
site_nodes n2
where n1.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey)
and tree_ancestor_p(n2.tree_sortkey, n1.tree_sortkey)
order by level asc