<?xml version="1.0"?>
<queryset>


  <fullquery name="get_portrait_info">      
      <querytext>
      
    select cr.publish_date, cr.title as portrait_title, cr.description as portrait_description
    from cr_revisions cr, cr_items ci, acs_rels a
    where cr.revision_id = ci.live_revision
    and ci.item_id = a.object_id_two
    and a.object_id_one = :user_id
    and a.rel_type = 'user_portrait_rel'
    
      </querytext>
</fullquery>

 
</queryset>