Index: openacs-4/packages/ecommerce/www/admin/problems/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/problems/index.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/ecommerce/www/admin/problems/index.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/problems/index.xql	26 May 2002 04:36:50 -0000	1.2
@@ -1,33 +1,19 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="unused_all">      
-      <querytext>
-      select count(*) from ec_problems_log
-      </querytext>
-</fullquery>
+  <fullquery name="problem_count">      
+    <querytext>
+      select count(*) 
+      from ec_problems_log
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="unresolved_count">      
+    <querytext>
+      select count(*) from 
+      ec_problems_log 
+      where resolved_date is null
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="unused_null">      
-      <querytext>
-      select count(*) from ec_problems_log where resolved_date is null
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="problems_select">      
-      <querytext>
-
- select 
-      l.*, 
-      u.first_names || ' ' || u.last_name as user_name
- from ec_problems_log l
-      LEFT JOIN cc_users u on (l.resolved_by = u.user_id)
-      $sql_clause
- order by problem_date asc
-
-      </querytext>
-</fullquery>
-
- 
-</queryset>
+</queryset>
\ No newline at end of file