（laravel）两个ORDER BY子句和一个LIMIT

Question

This is some sorting:

1. I want to list 20 best posts based on "views".
2. then, sort it based on "created_at".

How to do it?

Heres my current code (which work, but doesnt sort by "created_at"):

$this->data['today_post'] = 
Posts::orderBy('views', 'desc')
->orderBy('created_at', 'desc')
->whereRaw('created_at >= NOW() - INTERVAL 1 DAY')
->limit(20)->get();

Answer 1

You can write this. Hopefully this will solve your problem

$this->data['today_post'] = 
Posts::orderBy('views', 'desc')
->orderBy('created_at', 'desc')
->whereDate('created_at', Carbon::today()->toDateString())
->limit(20)
->get();

Also add use Carbon\Carbon; at the beginning of your controller.