Index: openacs-4/packages/download/www/admin/report-by-user-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/report-by-user-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/www/admin/report-by-user-oracle.xql	22 May 2001 04:17:45 -0000	1.1
+++ openacs-4/packages/download/www/admin/report-by-user-oracle.xql	16 Jan 2003 13:46:20 -0000	1.2
@@ -4,17 +4,16 @@
 <fullquery name="download_table">
       <querytext>
       
-    select min(u.last_name || ', ' || u.first_names) as user_name,
+    select d.user_id,
+           min(u.last_name || ', ' || u.first_names) as user_name,
            min(u.email) as email,
-           d.user_id,
-           count(*) as num_downloads,
-           min('$downloaded') as downloaded
+           count(*) as num_downloads
      from download_downloads_repository d, cc_users u
-     where d.repository_id = $repository_id and
+     where d.repository_id = :repository_id and
            d.user_id = u.user_id
            [ad_dimensional_sql $dimensional where]
      group by d.user_id
-     order by 2 desc
+     order by 2
 
       </querytext>
 </fullquery>