Create Query with Eloquent

I want to use laravel eloquent to implement the below query. Please help

SELECT COUNT(`category_id`) as categorycount,`category_id`,`product_id` FROM `productcategories` GROUP BY `category_id` ORDER BY categorycount DESC

Model Name is Productcategory

BezhanSalleh

8 years ago

Level 25

Productcategory::select(DB::raw('count(category_id) as categoryCount','category_id','product_id')
    ->groubBy('category_id','product_id')
    ->orderBy('categorycount','desc')
    ->get();

1 like

tisuchi

8 years ago

Best Answer

Level 70

Try this-

App\Productcategory::selectRaw('category_id, product_id, count(*) categorycount')
                            ->orderBy('categorycount', 'desc')
                            ->groupBy('category_id')
                            ->get();

7 likes

V9द

8 years ago

Level 3

@BezhanSalleh and @tisuchi Thank You For Your Reply Its Work for me.

1 like

Please or to participate in this conversation.