Index: openacs-4/packages/contacts/lib/contacts.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contacts.xql,v diff -u -r1.13 -r1.14 --- openacs-4/packages/contacts/lib/contacts.xql 20 Oct 2005 22:52:33 -0000 1.13 +++ openacs-4/packages/contacts/lib/contacts.xql 21 Oct 2005 10:54:12 -0000 1.14 @@ -4,12 +4,10 @@ select - parties.party_id + distinct parties.party_id, $sort_item from parties - left join persons on (parties.party_id = persons.person_id) - left join organizations on (parties.party_id = - organizations.organization_id) + $left_join 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