Index: openacs-4/packages/download/www/admin/report-one-ip-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/report-one-ip-oracle.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/download/www/admin/report-one-ip-oracle.xql	23 May 2001 16:35:03 -0000	1.2
+++ openacs-4/packages/download/www/admin/report-one-ip-oracle.xql	6 Dec 2002 11:31:28 -0000	1.2.4.1
@@ -4,14 +4,14 @@
 <fullquery name="download_table">
       <querytext>
 
-    select da.archive_name, 
+    select u.user_id,
+           u.last_name || ', ' || u.first_names as user_name,
+           u.email,
+           da.archive_name, 
            da.archive_id, 
            dar.revision_id,
            dar.version_name,
            d.download_date,
-           u.last_name || ', ' || u.first_names as user_name,
-           u.user_id,
-           u.email,
            nvl(d.download_hostname,'unavailable') as download_hostname,
            nvl2(d.reason_id, dr.reason, d.reason) as reason
       from download_archives_obj da, download_arch_revisions_obj dar, download_downloads d, download_reasons dr, cc_users u