Archived since Laravel 7 now support reorder internally see: reinink PR

clear query builder orders

->clearOrdersBy()

if you're using too many relations or using built in laravel realtions that using order by and you don't want them use :

$model
->selectRaw('count(*) as MYORDER')
->where('name', 'Bader')
->clearOrdersBy()
->orderBy('MYORDER', 'desc')

auth()->user()->notifications()
->selectRaw('count(*) as MYORDER')
->clearOrdersBy()
->orderBy('MYORDER', 'desc')

composer require if4lcon/laravel-clear-orders-by

Then add this line Bader\ClearOrdersBy\ClearOrdersByServiceProvider::class to service providers in config/app.php.

This package is open-sourced software licensed under the MIT license.