Bug report: Cohort filtering only catches one profile when same email exists on multiple person profiles

[slshults]

Bug Description

Bug description

When an email address exists as the email property value on multiple person profiles (where the email is not being used as the distinct_id), cohorts and filters using cohorts only catch one of those profiles. This results in incomplete filtering when using cohorts to filter out internal users.

Expected behavior: All person profiles with matching email addresses should be included in the cohort/filter results.

Actual behavior: Only one person profile with the matching email address is included in the cohort/filter results.

How to reproduce

View the criteria in this cohort
2. Note the cohort is used in a not in filter in the Filter out internal and test users setting
3. On this insight, click on the bar for Feb 28 and notice that a user with an email address domain from the cohort matching settings still appears in the list.
4. Note that user's email address appears on two person profiles; this profile and this other profile
5. Back on the cohort, notice also that using the Search for persons field to search for that email address only finds one of the profiles with that address

Additional context

From: https://posthoghelp.zendesk.com/agent/tickets/26367

Debug info

Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/01958182-5829-7c75-8fbf-132e836c5a3f?t=998
Admin: http://go/adminOrgUS/0194bef4-b2e2-0000-6beb-2c0b85562069 (project ID 123996)
Sentry: http://go/sentryUS/123996