select title, search_id from contact_searches where owner_id = :package_id and title is not null and not deleted_p order by lower(title) select cs.title as recent_title, cs.search_id as recent_search_id from contact_searches cs, contact_search_log csl where csl.user_id = :user_id and cs.search_id = csl.search_id and cs.title is not null and cs.owner_id != :package_id and not cs.deleted_p order by last_search desc limit 10