Laravel Eloquent sort by relation table column

by

Eager loading uses separate queries so you need join for this:

$products = Shop\Product::join('shop_products_options as po', 'po.product_id', '=', 'products.id')
   ->orderBy('po.pinned', 'desc')
   ->select('products.*')       // just to avoid fetching anything from joined table
   ->with('options')         // if you need options data anyway
   ->paginate(5);

SELECT clause is there in order to not appending joined columns to your Product model.

edit: as per @alexw comment – you still can include columns from joined tables if you need them. You can add them to select or call addSelect/selectRaw etc.

More Related Contents:

  1. Get Specific Columns Using “With()” Function in Laravel Eloquent
  2. Add a custom attribute to a Laravel / Eloquent model on load?
  3. Get the Query Executed in Laravel 3/4
  4. How to Make Laravel Eloquent “IN” Query?
  5. Laravel Many to many self referencing table only works one way
  6. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  7. Automatically deleting related rows in Laravel (Eloquent ORM)
  8. How to do this in Laravel, subquery where in
  9. Laravel Eloquent Query Using WHERE with OR AND OR?
  10. Laravel Check If Related Model Exists
  11. Laravel update model with unique validation rule for attribute
  12. How can I convert many statement mysql to laravel eloquent?
  13. Eloquent ORM Code Hinting in PhpStorm
  14. Laravel eager loading with limit
  15. What does “Mass Assignment” mean in Laravel?
  16. Laravel OrderBy relationship count
  17. Laravel Checking If a Record Exists
  18. How to set a default attribute value for a Laravel / Eloquent model?
  19. Laravel 5 hasMany relationship on two columns
  20. Order By before Group By using Eloquent (Laravel)
  21. Laravel Recursive Relationships
  22. How to Merge Two Eloquent Collections?
  23. Laravel Eloquent – Attach vs Sync
  24. How to create a subquery using Laravel Eloquent?
  25. Eloquent model mass update
  26. Difference between Eloquent\Model::get() and all()
  27. Laravel 4.1: How to paginate eloquent eager relationship?
  28. Eloquent many-to-many-to-many – how to load distant relation easily
  29. Find or Create with Eloquent
  30. Laravel Eloquent update just if changes have been made

Leave a Comment