Hi, I see there are other questions like this but I didn't like the answers. I am building an incredibly simple vote-idea-for-the-company app which has a Topic (title, description) that has many users (voters). I'd like to display the topics sorted by votes count and date, which I am doing like this:
$topics = Topic::select( array( '*', DB::raw('(SELECT count(*) FROM topic_user WHERE topic_id = id) as count_voters')) )->with('voters') ->orderBy('count_voters','desc') ->get();
This however doesn't sort by date, and it's really ugly to see. Suggestions?