This is a basic example of how to use the CakePHP paginator helper with the group by condition, it took a little mucking around but this is how I got it working. In this example we have a Comment controller which I want to paginate a custom query displaying an IP address and a calculated count field of the number of spam comments from these particular IP addresses. In the Controller The CommentCon