Large query breaks page

Thanks, Edgar, for reporting
Thanks, Odai for following up on issues.

To check the following issues

• 🐛 Fix not applied pagination Closed: duplicate
• 🐛 Latest Release Breaks Pagination RTBC

Fixed in 🐛 Latest Release Breaks Pagination RTBC
As the limit was moved to the end right before the execute and returning of results

    $result = $query->orderByHeader($header)->limit($limit)->execute();

    return $result;