Datamapper and pagination

[eluser]WanWizard[/eluser]
The problem might be here that you're using a count() query in combination with a group_by.

get_paged() runs two queries, one to determine the number of rows in the result, and one to actually get the rows for the required page.

For the first query, all select() and order_by() clauses are stripped, since they are not relevant for a count query. Unless you already have a query with a count() constructed, in which case this goes horribly wrong (as your grouping will no longer work).

Can you enable profiling, and post the SQL of the count query generated for this get_paged() call?