oracle8.1.6 select n.node_id, n.name, p.package_id, p.instance_name, pt.pretty_name as package_pretty_name, 0 as treelevel, (select count(*) from apm_parameters par where par.package_key = pt.package_key) as num_parameters from site_nodes n, apm_packages p, apm_package_types pt where n.parent_id = :subsite_node_id and p.package_id = n.object_id and pt.package_key = p.package_key order by lower(p.instance_name)