Datamapper and pagination

[eluser]WanWizard[/eluser]
1.8.1. is a fairly old version. I can't check bitbucket atm (it's down) to see if something was fixed in later versions, but looking at the current code, I don't see any reason why any clause would get dropped from the query.

Perhaps you can try the 1.8.3-dev from bitbucket (when it's back online) to see if it indeed is fixed?

I assume it is, because in this version the count query is run on a cloned object, from which the select and order_by clauses are removed. It will definitely not strip any other clauses.