select title as name from cr_revisions where revision_id = (select live_revision from cr_items where item_id = :file_id)