>Where is the WHERE clause in the code you showed (I don't see one)?

I didn't include it for the sample. That SQL is private and I had to manipulate it to show a related example. However, when doing this, I forgot the where clause. Having done it, probably someone else would have found it before me. :)