Index: openacs-4/packages/acs-admin/www/subsites-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/Attic/subsites-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-admin/www/subsites-oracle.xql	8 Sep 2015 11:42:29 -0000	1.1.2.1
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="subsite_admin_urls">      
+      <querytext>
+      
+    select s.node_id,
+           site_node.url(node_id) as node_url,
+           instance_name,
+	   p.package_id
+    from   site_nodes s, apm_packages p
+    where  s.object_id = p.package_id
+    and    p.package_key in ($package_keys)
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>