select title, owner_id as old_owner_id, all_or_any, contact_searches.object_type from contact_searches, acs_objects where search_id = object_id and search_id = :search_id update contact_searches set owner_id = :owner_id where search_id = :search_id select title from contact_searches, acs_objects where search_id = object_id and owner_id = :owner_id and upper(title) like upper('${sql_title}%') select type, var_list from contact_search_conditions where search_id = :search_id