Thanks for that Jet! Forgot to add the 'order by' in my query.
I haven't thoroughly looked at the paging bug; but off the top of my head there's a problem with the math. Our pager isn't your everyday pager where page 1
is page 1, technically for us page 1 is 0.
I'm thinking of a workaround without actually fixing the entire pager, which is used site-wide.