sort by number of views descending laravel
Solutions on MaxInterview for sort by number of views descending laravel by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "sort by number of views descending laravel"
Ana Sofia
20 Jul 2020
1$posts = Post::select(DB::raw('posts.*, count(*) as `aggregate`'))
2 ->join('views', 'posts.id', '=', 'views.post_id')
3 ->groupBy('post_id')
4 ->orderBy('aggregate', 'desc')
5 ->get();
6similar questions
laravel order by raworderby in laravelarray sort in laravelorderby text values eliquent laravellaravel query order by relationlaravel order byeloquent model sort by ascending orderlaravel collection sortbylaravel get all records order bylaravel collection sortlaravel sort collection by keyorder number generate laravelorder by asc in laravbellaravel sort collectionlaravel eloquent order by alphabetical orderlaravel order by desclaravel 6 orderbyget all sort by laravellaravel sortable columnsort laravel eloquentsortbydesc on a collection laravellaravel belongs to order bylaravel orderby with relationlaravel sortby relationship columnaravel 8 how to order by using eloquent ormlaravel multiple orderbylaravel collection orderorder by in datatable laravel your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful