What's wrong with this query?

It should first select the items before filtering themThere's nothing wrong with the query

It should first select the items before filtering them.