Index: openacs-4/packages/acs-admin/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/Attic/index-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-admin/www/index-oracle.xql	31 Dec 2003 01:03:44 -0000	1.4
+++ openacs-4/packages/acs-admin/www/index-oracle.xql	23 Feb 2009 21:30:11 -0000	1.5
@@ -8,9 +8,10 @@
     select s.node_id,
            site_node.url(node_id) as node_url,
            instance_name
-    from   site_nodes s, apm_packages p
+    from   site_nodes s, apm_packages p, apm_package_types t
     where  s.object_id = p.package_id
-    and    p.package_key = 'acs-subsite'
+    and    p.package_key = t.package_key
+    and    t.implements_subsite_p = 't'
 
       </querytext>
 </fullquery>