Index: openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list.xql	15 May 2001 16:59:00 -0000	1.1
+++ openacs-4/packages/acs-subsite/www/admin/groups/elements-display-list.xql	11 Aug 2001 21:31:03 -0000	1.2
@@ -3,11 +3,10 @@
 
 <fullquery name="relations_query">      
       <querytext>
-      FIX ME REMOVE OPTIMIZATION HINT
 
 select r.rel_id, 
        party_names.party_name as element_name
-from (select /*+ ORDERED */ DISTINCT rels.rel_id, object_id_two
+from (select DISTINCT rels.rel_id, object_id_two
       from $extra_tables acs_rels rels, all_object_party_privilege_map perm
       where perm.object_id = rels.rel_id
         and perm.party_id = :user_id
@@ -16,7 +15,7 @@
         and rels.object_id_one = :group_id $extra_where_clauses) r, 
      party_names 
 where r.object_id_two = party_names.party_id
-order by lower(element_name)
+order by element_name
 
       </querytext>
 </fullquery>