Index: openacs-4/packages/ecommerce/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/index.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/ecommerce/www/index.xql 26 May 2002 04:36:50 -0000 1.2 +++ openacs-4/packages/ecommerce/www/index.xql 12 Sep 2002 22:15:01 -0000 1.3 @@ -35,15 +35,4 @@ - - - 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 - - -