<?xml version="1.0"?> <queryset> <rdbms><type>oracle</type><version>8.1.6</version></rdbms> <fullquery name="revisions_get"> <querytext> select r.revision_id, ao.creation_date as creation_date, ao.creation_ip, i.live_revision, p.first_names || ' ' || p.last_name as full_name from cr_revisions r, cr_items i, acs_objects ao, persons p where r.item_id = :pres_item_id and ao.object_id = r.revision_id and i.item_id = r.item_id and p.person_id = ao.creation_user order by creation_date </querytext> </fullquery> </queryset>