Laravel OrderBy relationship count

by

This works for me in Laravel 5.3, using your example:

Hackathon::withCount('participants')->orderBy('participants_count', 'desc')->paginate(10);

This way it is ordered on the query and the pagination works nicely.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to do this in Laravel, subquery where in
  3. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  4. Laravel $q->where() between dates
  5. Eloquent many-to-many-to-many – how to load distant relation easily
  6. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  7. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  8. Get the Last Inserted Id Using Laravel Eloquent
  9. Bulk Insertion in Laravel using eloquent ORM
  10. Laravel 5 PDOException Could Not Find Driver
  11. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  12. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  13. How to exclude certains columns while using eloquent
  14. How to alias the name of a column in Eloquent
  15. belongsToMany relationship in Laravel across multiple databases
  16. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  17. How to Make Laravel Eloquent “IN” Query?
  18. Update without touching timestamps (Laravel)
  19. Laravel Cannot delete or update a parent row: a foreign key constraint fails
  20. laravel collection to array
  21. Base table or view not found: 1146 Table Laravel 5
  22. Laravel Eloquent sort by relation table column
  23. Eloquent Parent-Child relationship on same model
  24. How can I query raw via Eloquent?
  25. Mysql InnoDB engine in Laravel
  26. A __construct on an Eloquent Laravel Model
  27. How to get last insert id in Eloquent ORM laravel
  28. PHP Laravel: No connection could be made because the target machine actively refused it
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment