oracle8.1.6 select content_item.get_latest_revision(:comment_id) from dual select g.object_id, g.comment_id, content_item.get_live_revision(g.comment_id) as live_revision, r.revision_id, r.title, r.content, r.mime_type, o.creation_user, o.creation_date, acs_object.name(o.creation_user) as author from general_comments g, cr_revisions r, acs_objects o where g.comment_id = o.object_id and g.comment_id = r.item_id and r.revision_id = :revision_id select g.object_id, g.comment_id, r.revision_id as live_revision, r.revision_id, r.title, r.content, r.mime_type, o.creation_user, o.creation_date, acs_object.name(o.creation_user) as author from general_comments g, acs_objects o, cr_revisions r where g.comment_id = :comment_id and g.comment_id = o.object_id and g.comment_id = r.item_id and r.revision_id = content_item.get_live_revision(:comment_id) select r.revision_id, to_char(o.creation_date, 'MM-DD-YY HH24:MI:SS') as revision_date from cr_revisions r, acs_objects o where r.item_id = :comment_id and o.object_id = r.revision_id order by o.creation_date desc