postgresql7.1 select i.item_id, title, party__name(owner_id) as owner_name, publish_date, publish_status, live_revision from glossariesx g, cr_items i where i.content_type = 'glossary' and i.item_id = g.item_id and acs_permission__permission_p(i.item_id, :user_id, 'glossary_admin') = 't' and g.package_id = :package_id and g.revision_id = content_item__get_latest_revision(i.item_id) order by title