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.3 -r1.4
--- openacs-4/packages/acs-admin/www/index-oracle.xql	28 Aug 2003 11:59:01 -0000	1.3
+++ openacs-4/packages/acs-admin/www/index-oracle.xql	31 Dec 2003 01:03:44 -0000	1.4
@@ -5,11 +5,12 @@
 <fullquery name="subsite_admin_urls">      
       <querytext>
       
-    select site_node.url(node_id) || 'admin/' as admin_url, instance_name
-    from site_nodes s, apm_packages p
-    where s.object_id = p.package_id
-    and p.package_key = 'acs-subsite'
-    order by upper(instance_name), instance_name
+    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'
 
       </querytext>
 </fullquery>