Annoyed me for years, finally looked at SQL output of advanced queries. No wonder they don’t work as expected! Had to fix by hand.