Index: openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql	16 Jan 2003 13:46:35 -0000	1.11
+++ openacs-4/packages/ecommerce/tcl/ecommerce-procs-postgresql.xql	28 Aug 2003 09:41:53 -0000	1.12
@@ -40,6 +40,14 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="ec_mailing_list_link_for_a_product.mailing_categories">      
+    <querytext>
+      select category_id, subcategory_id, subsubcategory_id, product_id 
+      from ($common_sql) as dummy 
+      limit 1
+    </querytext>
+  </fullquery>
+
   <fullquery name="ec_add_to_cart_link.get_product_info_1">      
     <querytext>
       select case when current_timestamp > available_date  then 1 when current_timestamp-available_date is NULL then 1 else 0 end as available_p,