oracle8.1.6 select cr.publish_date, nvl(cr.title,'your portrait') as portrait_title 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'