select parent_id as folder_id from cr_items where item_id=:file_id select title, description from cr_revisions,cr_items where cr_items.item_id=:file_id and revision_id=live_revision