oracle8.1.6 select r.revision_id, a.display, r.mime_type from cr_items i, cr_wp_image_attachments a, cr_revisions r where i.item_id = :attach_item_id and i.live_revision = r.revision_id and r.revision_id = a.attach_id(+)