postgresql9.0 select p.package_id, p.instance_name, n.node_id, n.name from site_nodes n, apm_packages p, apm_package_types t where n.parent_id = :subsite_node_id and p.package_id = n.object_id and t.package_key = p.package_key and t.package_type = 'apm_application' and acs_permission__permission_p(p.package_id, :user_id, 'read') order by upper(instance_name)