How to order authors by the latest article

Asked Dec 01 '15 at 09:53

Active Dec 01 '15 at 09:55

Viewed 42 times

I am using Laravel 4 for web development. I defined a Model called Author and Author could post article. then i need a list of authors, which ordered by the latest article, and the name of authors could not be duplicate. I using the code like

$authors= Author::LeftJoin('articles','author.id','=','articles.author_id')
        ->orderBy('articles.created_at','DESC');
        ->groupBy('author.id')->paginate(16);

this note work well. the authors are order by the first article not the last. could groupBy work on the first row occurred?

edited Dec 01 '15 at 09:55

Oldskool

34,211
7
53
66

asked Dec 01 '15 at 09:53

ArchenZhang

Possible duplicate of [How to order grouped results using Eloquent?](http://stackoverflow.com/questions/18159465/how-to-order-grouped-results-using-eloquent) – aldrin27 Dec 01 '15 at 09:55
You need to run raw DB statements. – Mina Abadir Dec 01 '15 at 10:08

How to order authors by the latest article

0 Answers0