Index: openacs-4/packages/download/www/admin/report-by-ip-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/report-by-ip-oracle.xql,v
diff -u -N -r1.1.4.1 -r1.1.4.2
--- openacs-4/packages/download/www/admin/report-by-ip-oracle.xql	6 Dec 2002 11:31:28 -0000	1.1.4.1
+++ openacs-4/packages/download/www/admin/report-by-ip-oracle.xql	3 Jan 2003 17:29:47 -0000	1.1.4.2
@@ -4,19 +4,15 @@
 <fullquery name="download_table">
       <querytext>
       
-    select min(d.user_id) as user_id,
-           min(u.last_name || ', ' || u.first_names) as user_name,
-           min(u.email) as email,
-           d.download_ip,
+    select d.download_ip,
            nvl(min(d.download_hostname),'unavailable') as download_hostname,
-           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.download_ip
-     order by 2 desc
+     order by 2
 
       </querytext>
 </fullquery>