Index: openacs-4/packages/ecommerce/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/ecommerce/www/index-postgresql.xql	12 Sep 2002 22:15:01 -0000	1.3
+++ openacs-4/packages/ecommerce/www/index-postgresql.xql	19 Sep 2002 23:40:46 -0000	1.4
@@ -13,6 +13,23 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_produc_recs">      
+    <querytext>
+      select p.product_id, p.product_name, p.dirname, r.recommendation_text, o.offer_code
+      from ec_product_recommendations r, ec_products_displayable p left outer join ec_user_session_offer_codes o on 
+          (p.product_id = o.product_id and user_session_id = :user_session_id)
+      where p.product_id=r.product_id
+      and category_id is null 
+      and subcategory_id is null 
+      and subsubcategory_id is null
+      and (r.user_class_id is null or r.user_class_id in (select user_class_id
+          from ec_user_class_user_map 
+          where user_id = :user_id
+          $user_class_approved_p_clause))
+      and r.active_p='t'
+    </querytext>
+  </fullquery>
+
   <fullquery name="get_tl_products">      
     <querytext>
       select p.product_id, p.product_name, p.one_line_description, o.offer_code