jlrdw6 years agoLevel 75ReplyReport SpamIf also using group by, there's the very power and flexible Length aware paginator, all in the API. https://laracasts.com/discuss/channels/guides/length-aware-paginator There are several techniques available for usage. From the docs: Currently, pagination operations that use a groupBy statement cannot be executed efficiently by Laravel. If you need to use a groupBy with a paginated result set, it is recommended that you query the database and create a paginator manually. Like Reply