oracle8.1.6 select site_node.url(n.node_id) as package_url, p.package_key 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 in ('users-selection', 'categories', 'mail-links', 'mailing-lists')