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 -r1.1 -r1.1.4.1 --- openacs-4/packages/download/www/admin/report-by-ip-oracle.xql 22 May 2001 04:17:45 -0000 1.1 +++ openacs-4/packages/download/www/admin/report-by-ip-oracle.xql 6 Dec 2002 11:31:28 -0000 1.1.4.1 @@ -4,9 +4,9 @@ - select min(u.last_name || ', ' || u.first_names) as user_name, + select min(d.user_id) as user_id, + min(u.last_name || ', ' || u.first_names) as user_name, min(u.email) as email, - min(d.user_id) as user_id, d.download_ip, nvl(min(d.download_hostname),'unavailable') as download_hostname, count(*) as num_downloads,