postgresql7.1
select persons.person_id
from persons, group_distinct_member_map
where persons.person_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ([template::util::tcl_to_sql_list [contacts::default_groups -package_id $package_id]])
[contact::search::query_clause -and -query $query -party_id "persons.person_id"]
order by upper(persons.first_names) asc, upper(persons.last_name) asc
limit 51
select organizations.organization_id
from organizations, group_distinct_member_map
where organizations.organization_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ([template::util::tcl_to_sql_list [contacts::default_groups -package_id $package_id]])
[contact::search::query_clause -and -query $query -party_id "organizations.organization_id"]
order by upper(organizations.name) asc
limit 51