postgresql7.1 select content_item__set_live_revision( :revision_id ); select item_id, content_item__is_publishable( item_id ) as publish_p from cr_revisions where revision_id = :revision_id