select contact_search__log(:search_id,:user_id) select title from contact_searches where search_id = :search_id select * from contact_searches where search_id = :search_id select parties.party_id from parties left join cr_items on (parties.party_id = cr_items.item_id) left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id ), group_distinct_member_map where parties.party_id = group_distinct_member_map.member_id and group_distinct_member_map.group_id = '[contacts::default_group]' [contact::search_clause -and -search_id $search_id -query "" -party_id "parties.party_id" -revision_id "revision_id"] select type, var_list from contact_search_conditions where search_id = :search_id select count(*) from parties left join cr_items on (parties.party_id = cr_items.item_id) left join cr_revisions on (cr_items.latest_revision = cr_revisions.revision_id ) , group_distinct_member_map where parties.party_id = group_distinct_member_map.member_id and group_distinct_member_map.group_id = '[contacts::default_group]' [contact::search_clause -and -search_id $search_id -query $query -party_id "parties.party_id" -revision_id "revision_id"] select title, owner_id, all_or_any, object_type from contact_searches where search_id = :search_id select type, var_list from contact_search_conditions where search_id = :search_id