oracle8.1.6
select site_node.url(n.node_id)
from site_nodes n, site_nodes top, apm_packages p
where top.parent_id is null
and n.parent_id = top.node_id
and p.package_id = n.object_id
and p.package_key = 'categories'
select ci.item_id as assessment_id, cr.title, ci.publish_status
from cr_items ci, cr_revisions cr
where cr.revision_id = ci.latest_revision
and ci.content_type = 'as_assessments'
and ci.parent_id = :folder_id
and acs_permission.permission_p(ci.item_id, :user_id, 'admin')
order by cr.title