select
ot.option_id,
ot.option
from
ams_option_types ot
where
ot.attribute_id = :attr_id
select
value_id
from
ams_options
where
option_id = :option_id
select
count(parties.party_id)
from
parties
where parties.party_id in (
select
parties.party_id
from
parties
left join organizations on (parties.party_id = organizations.organization_id)
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
$search_clause
)
and parties.party_id in (
select
distinct
p.party_id
from
ams_attribute_values a,
cr_items i,
parties p
where
a.object_id = i.latest_revision and
i.item_id = p.party_id
and a.value_id = $value_id )