postgresql7.1 select s.node_id, site_node__url(node_id) as node_url, instance_name from site_nodes s, apm_packages p where s.object_id = p.package_id and p.package_key = 'acs-subsite'