select content, mime_type from cr_revisions where revision_id = :revision_id