Index: openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/Attic/by-order-state-and-time.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql	11 Jul 2001 23:21:03 -0000	1.2
+++ openacs-4/packages/ecommerce/www/admin/orders/by-order-state-and-time.xql	22 Jul 2001 05:08:55 -0000	1.3
@@ -6,7 +6,7 @@
       <querytext>
 
 select o.order_id, o.confirmed_date, o.order_state, ec_total_price(o.order_id) as price_to_display, o.user_id, u.first_names, u.last_name, count(*) as n_items
-from ec_orders o, cc_users u, ec_items i
+from ec_orders o
     JOIN ec_items i using (order_id)
     LEFT JOIN cc_users u on (o.user_id=u.user_id)
 $confirmed_query_bit $order_state_query_bit