Index: openacs-4/packages/contacts/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/index.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/contacts/www/index.xql 12 Oct 2005 18:51:54 -0000 1.7 +++ openacs-4/packages/contacts/www/index.xql 1 May 2006 19:54:52 -0000 1.8 @@ -15,15 +15,16 @@ - select cs.title as recent_title, + select ao.title as recent_title, cs.search_id as recent_search_id - from contact_searches cs, contact_search_log csl + from contact_searches cs, contact_search_log csl, acs_objects ao where csl.user_id = :user_id and cs.search_id = csl.search_id - and cs.title is not null + and cs.search_id = ao.object_id + and ao.title is not null and cs.owner_id != :package_id and not cs.deleted_p - order by last_search desc + order by csl.last_search desc limit 10