postgresql7.2
SELECT
r.title as resource_title,
r.description as resource_description,
r.revision_id as resource_revision_id,
r.item_id as resource_item_id
FROM
rl_resources_revisionsx r, cr_items i
WHERE
r.item_id = :resource_item_id and
i.live_revision = r.revision_id
SELECT
min(revision_id) as oldest_revision
FROM
rl_resources_revisionsx r
WHERE
r.item_id = '$res(resource_item_id)'
SELECT
to_char(r.creation_date,'Month DD YYYY') as creation_date,
c.first_names || ' ' || c.last_name as full_name
FROM
rl_resources_revisionsx r, cc_users c
WHERE
r.revision_id = :oldest_revision and
r.creation_user = c.user_id
select
short_name
FROM
rl_resource_category c,
rl_resource_category_map m,
rl_resources_revisionsx r
WHERE
m.resource_item_id = r.item_id and
c.category_id = m.category_id and
r.revision_id = $res(resource_revision_id)