select name as url, parent_id as package_id from cr_items where live_revision = :object_id select r.revision_id as object_id, r.title as title, content as content, 'text/html' as mime, '' as keywords, 'text' as storage_type from cr_revisions r where revision_id = :object_id