Index: openacs.org-dev/packages/ecommerce/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/ecommerce/www/index.xql,v
diff -u -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/ecommerce/www/index.xql	9 Jul 2002 17:35:05 -0000	1.1.1.1
+++ openacs.org-dev/packages/ecommerce/www/index.xql	8 Oct 2002 15:47:06 -0000	1.1.1.2
@@ -18,32 +18,4 @@
     </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
-      from ec_products_searchable 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 not exists (select 1 
-          from ec_category_product_map m
-          where p.product_id = m.product_id)
-      order by p.product_name
-    </querytext>
-  </fullquery>
-
 </queryset>