perf: Person property filters on joins should be moved to subquery

[timgl]

The problem

To filter a list of events down based on person properties, we join on the person table. However, this means that when we fan out the queries to other nodes, instead of them just responding with a count, they have to send over every single event, which we then join on the main node. This means transferring 10s of GBs of data.

We should move join into a subquery instead, so the nodes can respond with the total count instead.

See this query for an overview

Example query before moving person to subquery

Example query after moving person to subquery

[pauldambra]

100% #22358 (comment)