SQL Server Query not returning results

No, it;'s not that one. the query debug should be off.
It’s this one: