After testing out the different versions again on some of my databases, I noticed the same discrepancy in the number of records returned between Abdullah Khan's query and Jorge Serres'...

Edit: After I posted this I realized that I did not try out Jorge Serres' version above, which does in fact contain the schema name.

I noticed that none of the...