postgresql7.1 select r.revision_id as object_id, r.name as title, r.content as content, r.mime_type as mime, r.name as keywords, 'text' as storage_type from cr_revisions r where revision_id = :object_id select site_node__url(node_id) as url_stub from site_nodes where object_id=:package_id