BTW, the execution plan is definitely, ahem, "interesting"

You can knock out about 100 possible combitation by adding the following inferred clues:

AND NOT...