Index: openacs-4/packages/acs-admin/www/users/one-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one-oracle.xql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/acs-admin/www/users/one-oracle.xql	7 Aug 2017 23:47:45 -0000	1.7
+++ openacs-4/packages/acs-admin/www/users/one-oracle.xql	22 Nov 2017 14:24:37 -0000	1.8
@@ -3,18 +3,6 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-<fullquery name="get_item_id">      
-      <querytext>
-      select live_revision as revision_id, nvl(title,'view this portrait') portrait_title
-from acs_rels a, cr_items c, cr_revisions cr 
-where a.object_id_two = c.item_id
-and c.live_revision = cr.revision_id
-and a.object_id_one = :user_id
-and a.rel_type = 'user_portrait_rel'
-      </querytext>
-</fullquery>
-
- 
 <fullquery name="user_contributions">      
       <querytext>
       select at.pretty_name, at.pretty_plural, a.creation_date, acs_object.name(a.object_id) object_name
@@ -24,6 +12,5 @@
 order by pretty_name, creation_date desc, object_name
       </querytext>
 </fullquery>
-
  
 </queryset>