Laravel Eloquent: Order By Relationship - Two Ways 

Love this performance related videos. Keep up the good work.

What about nested relationships? For example: category.user.name

Since 'join()' returns query builder, it can used as a scope. Product::select(...)->joinCategories()->orderBy(...)->paginate(...)

Actually you've showed three ways, with/orderBy, collection/sortBy and join/orderBy. Thank you.

How to use join when Product has several Categories. It will bring duplicates to the table for each Category.

But you can order by relationship with query inside callback function.

Sometimes I was wondering why we need to use eloquent...

This is a problem as u also have to use groupby and disable strict in database.php for join, in case its a one to many relationship. But i have been using join didn't know the order by accept sub-query also nice video

Great video, solved some of my questions!

Laravel Daily to the rescue! Thanks again.

One of the best channel to find something better for my code consept..

help me to use this in mongodb

you could still add 'with' if you want to access the category models

Sir, I am a big fan of you. This is my daily routine to watch atleast one video of you.😍.. I did a project, I want you feedback on that project, How can I send the project to you.. Again, Thanks a lot for your great videos😍. Note: The project take 2 days more to finish. Want to sent it after two days. And can you please review my code 😊

Thanks for this video . Can we use select and join with hasMany relationships.

I need your help. What if you want first to group by name and then order by the last record on the database?

Great video. Thank you so much.

what if use join : $products=Product::with('category')->join('categories','category_id','=','categories.id')->select('products.*','categories.name')->orderBy('categories.name')->get();

Thank you for this kind of video. Can you explain this "->orderBy(Category::select('name')>whereColumn('categories.id', 'products.category_id'))" orderBy() accept column but how this work?

We also can use callback function inside with function

Thx a lot for this tips and how to search a record in relationship table??

Hopefully I will use in comming project ❤️

Thank you this was helpful.

I am watching almost all your videos, altough even i know the subjects some of them. Because i am not only learning sth, but also i learn how to think about the codes.

thank u so much...very usefull...

Thank you so much, i was stuck with this one, saved me a lot

Thanks!!! You're the best!

Hi which package or tool you are using for measuring time, checking queries and ram memory for laravel as you use in this video.

Useful, thanks!

the more better way is to create view table..

Thank youuu

Please tutorial for Repository and Service pattern. Thank you!

thanks for this video 😍, also when i watching your video i was wondering what do you think of aimeos (laravel ecommerce & shop)

Great bro

Nice examples, thanks!

Great tip! Thanks

Great bro

Thank you...

very informative, which phpstorm version you are using?

great content as usual. I have a question if i may may ask: suppose we have a table of users with region_name where they live and a field of votes ( boolean if voted or not), how to get the total number of user voted per region_name and total number of users in every region but with the same query. Is it possible?