Index: openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	18 Jul 2001 00:03:07 -0000	1.2
+++ openacs-4/packages/ecommerce/tcl/ecommerce-widgets-procs-postgresql.xql	20 Jul 2001 21:53:59 -0000	1.3
@@ -30,5 +30,22 @@
 
       </querytext>
 </fullquery>
+
+
+<fullquery name="ec_mailing_list_widget.get_category_children">
+      <querytext>
+
+    select c.category_id, c.category_name, s.subcategory_id, s.subcategory_name, ss.subsubcategory_id, ss.subsubcategory_name
+      from ec_cat_mailing_lists m
+	LEFT JOIN ec_categories c on (m.category_id=c.category_id)
+	LEFT JOIN ec_subcategories s on (m.subcategory_id=s.subcategory_id)
+	LEFT JOIN ec_subsubcategories ss on (m.subsubcategory_id=ss.subsubcategory_id)
+    order by 
+	case when c.category_id is null then 0 else c.sort_key end, 
+	case when s.subcategory_id is null then 0 else s.sort_key end, 
+	case when ss.subcategory_id is null then 0 else ss.sort_key end
+
+      </querytext>
+</fullquery>
  
 </queryset>