Index: openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/Attic/manage-memberships-postgresql.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql	24 Jul 2004 08:34:10 -0000	1.2
+++ openacs-4/packages/dotlrn/www/manage-memberships-postgresql.xql	12 Dec 2005 15:14:41 -0000	1.2.2.1
@@ -23,7 +23,8 @@
                  dotlrn_member_rels_full
             where dotlrn_member_rels_full.user_id = :user_id
             and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id
-            order by dotlrn_class_instances_full.pretty_name,
+            order by dotlrn_class_instances_full.active_start_date,
+		     dotlrn_class_instances_full.pretty_name,
                      dotlrn_class_instances_full.community_key
         </querytext>
     </fullquery>
@@ -113,8 +114,10 @@
                             from dotlrn_member_rels_full
                             where dotlrn_member_rels_full.user_id = :user_id
                             and dotlrn_member_rels_full.community_id = dotlrn_class_instances_full.class_instance_id)
-            order by dotlrn_class_instances_full.pretty_name,
+            order by dotlrn_class_instances_full.active_start_date,
+		     dotlrn_class_instances_full.pretty_name,
                      dotlrn_class_instances_full.community_key
+
         </querytext>
     </fullquery>