select object_type from acs_objects where object_id=:object_id select contract_id from valid_uninstalled_bindings where contract_name='FtsContentProvider' and impl_name=:content_type 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