I had found an error in my query the first time...

However, I now get multiple copies of each row that I originally would have gotten, and the total row count (unfiltered by page number) of the output table is now several times the size of the original query.

Also, I don't always get the same rows each time when I filter the results by rows.