https://www.youtube.com/watch?v=Gme6Lgd8SBg
YouTube
Eloquent Query Last Related Row: Subquery or Relationship?
If you need to query the list of rows, with the newest/oldest row from a related table, how to make it in one Eloquent sentence? In fact, there are two ways.

Related article:
Eloquent Subquery Enhancements in Laravel 6.0: https://laravel-news.com/eloquent…