Comment by Sesse__

I have no idea what a Cartesian product would have to do with my query; there's only a single table there.

> But actually you have a point in that half the problem is the predicate is not linked to the tables

No, it really isn't a problem at all that the predicate isn't linked to the tables. That in itself is entirely legal and unproblematic.