Session replay filtering does not work as expected when several filter options specified

[bacher]

Bug Description

Bug description

When I try to filter session replays by specific events and match logic is set to AND I see results like if those filters applied with OR logic, so I see events that contains the first event or the second event, but I would expect that I should see the only records which includes both events at the same time, so logic operator AND.

On this screenshot you can see results when both event are specified as filters:

---

Then I removed the second filter and my results got shrunk to just 1 session:

---

Expect results that adding of new filtering rule will shrunk number of results and
removing of filtering rule should increase number of results.

---

We actually checked results, and can confirm, that returned sessions do not contain targeted event (except for 1 of course).

---

If you are on PostHog Cloud it would be really valuable if you can share any links where the problem occurs. This speeds up our ability to troubleshoot tremendously.

session replays

How to reproduce

1. Add a few filters with Match logic set to AND;
2. Number of results get growth but should reduce.

Additional context

Debug info

- [x] PostHog Cloud, Debug information: [please copy/paste from https://us.posthog.com/settings/project-details#variables or https://eu.posthog.com/settings/project-details#variables]

Session: https://us.posthog.com/project/sTMFPsFhdP1Ssg/replay/01937830-fbd6-7b24-b3c3-f984f1c302f3?t=941
Admin: http://go/adminOrgUS/01826d68-12b6-0000-a6a7-29ce579bab99 (project ID 49356)
Sentry: http://go/sentryUS/49356

- [ ] PostHog Hobby self-hosted with `docker compose`, version/commit: [please provide]
- [ ] PostHog self-hosted with Kubernetes (deprecated, see [`Sunsetting Kubernetes support`](https://posthog.com/blog/sunsetting-helm-support-posthog)), version/commit: [please provide]

[pauldambra]

Ugh, annoying!

I have this PR which is changing some of the query code here and the tests already forced me to account for the AND/OR of some things so I'm surprised this isn't covered

I'll get that PR in since I'd have to make a fix to filtering in two places otherwise and then look at this

thanks for reporting it!