Index: openacs-4/packages/ims-ent/tcl/ims-ent-dotlrn-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ims-ent/tcl/ims-ent-dotlrn-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ims-ent/tcl/ims-ent-dotlrn-procs.xql	16 Jun 2004 23:06:45 -0000	1.2
+++ openacs-4/packages/ims-ent/tcl/ims-ent-dotlrn-procs.xql	18 Jun 2004 01:37:50 -0000	1.3
@@ -81,16 +81,16 @@
 
   <fullquery name="ims_enterprise::ims_dotlrn::groups::guess_term.get_best_term">
     <querytext>
-      select term_id
+      (select term_id
       from dotlrn_terms
       where start_date >= :start_date
       and end_date <= :end_date
-      order by end_date DESC
+      order by end_date DESC)
       UNION
-      select term_id
+      (select term_id
       from dotlrn_terms
       where end_date >= now()
-      order by end_date DESC
+      order by end_date DESC)
       limit 1
     </querytext>
   </fullquery>