select
distinct p.party_id, $sort_item
from
parties p
$left_join, cr_items ci, cr_revisions cr,
group_distinct_member_map
where
p.party_id = group_distinct_member_map.member_id
and ci.item_id = p.party_id and ci.latest_revision = cr.revision_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
[contact::search_clause -and -search_id $search_id -query $query -party_id "p.party_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select
o.organization_id
from organizations o,
cr_items ci, cr_revisions cr,
group_distinct_member_map
where
o.organization_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
and ci.item_id = o.organization_id and ci.latest_revision = cr.revision_id
[contact::search_clause -and -search_id $search_id -query $query -party_id "o.organization_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select
p.person_id
from persons p, cr_items ci, cr_revisions cr,
group_distinct_member_map
where
p.person_id = group_distinct_member_map.member_id
and group_distinct_member_map.group_id in ('[join [contacts::default_groups] "','"]')
and ci.item_id = p.person_id and ci.latest_revision = cr.revision_id
[contact::search_clause -and -search_id $search_id -query $query -party_id "p.person_id" -revision_id "revision_id"]
[template::list::orderby_clause -orderby -name "contacts"]
select $extend_query
organizations.name,
first_names, last_name,
parties.party_id,
parties.email,
parties.url
from parties
left join persons on (parties.party_id = persons.person_id)
left join organizations on (parties.party_id = organizations.organization_id), cr_items ci, cr_revisions cr
where ci.item_id = party_id and ci.latest_revision = cr.revision_id
[template::list::page_where_clause -and -name "contacts" -key "party_id"]
$group_by_group_id
[template::list::orderby_clause -orderby -name "contacts"]
select
csem.extend_id
from
contact_search_extend_map csem,
contact_extend_options ceo
where
ceo.extend_id = csem.extend_id
and ceo.aggregated_p = 'f'
and csem.search_id = :search_id
select distinct
$extend_query
rel.object_id_one as party_id,
rel.object_id_two as employee_id
from
acs_rels rel,
parties p
where
rel.rel_type = 'contact_rels_employment'
and rel.object_id_one = p.party_id
[template::list::page_where_clause -and -name "contacts" -key "party_id"]
select
rel.object_id_one as party_id,
rel.object_id_two as employee_id
from
acs_rels rel, persons p
where
rel.rel_type = 'contact_rels_employment'
and person_id = object_id_one
order by last_name
select
object_type
from
contact_searches
where
search_id = :search_id
select
object_type
from
contact_searches
where
search_id = :search_id
select
type
from
contact_search_conditions
where
search_id = :search_id