Index: openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql,v
diff -u -N -r1.5 -r1.6
--- openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql	14 Dec 2003 11:57:27 -0000	1.5
+++ openacs-4/packages/acs-subsite/tcl/subsite-procs-oracle.xql	18 Feb 2005 19:08:52 -0000	1.6
@@ -72,4 +72,17 @@
         </querytext>
     </fullquery>
  
+    <partialquery name="subsite::get_url.orderby">
+        <querytext>
+        and rownum < 2
+        order by decode(host, :search_vhost, 1, 0) desc
+        </querytext>
+    </partialquery>
+ 
+    <partialquery name="subsite::get_url.simple_search">
+        <querytext>
+        and rownum < 2
+        </querytext>
+    </partialquery>
+ 
 </queryset>