First of all, Phil's query does not only return the correct results but it's also around 6 times more efficient than the original one, given there is no index satisfying the query.

😎

Secondly, do post the DDL (create tables), sample data in the form of an insert statement and the expected results. The absence of these seriously affect the accuracy of the responses as everyone has to guess what it could look like.