Question : How to get Last Record From join Table in Laravel
Answered by : uptight-unicorn-3mtdsagqepro
$query = Article::select('articles.*', 'comments.comment as article_comment')
->leftJoin('comments', function($query) { $query->on('comments.article_id','=','articles.id') ->whereRaw('comments.id IN (select MAX(a2.id) from comments as a2 join articles as u2 on u2.id = a2.article_id group by u2.id)');
})
->get();Source : https://www.laravelcode.com/post/how-to-get-last-record-from-leftjoin-table-in-laravel | Last Update : Tue, 13 Sep 22