postgresql7.1
select item_id,
live_revision,
publish_title,
html_p,
publish_date,
publish_body,
'' || item_creator || '' as creator_link
from news_items_live_or_submitted
where item_id = :item_id
select content
from cr_revisions
where revision_id = :live_revision