turn mysql query to Laravel

Hello , i have this query , can anyone help me to make same using laravel way

thanks

SELECT `categories`.`id`,`categories`.`cat_name`,COUNT(`tenders`.`cat_id`)

FROM `categories`

left JOIN `tenders` ON `tenders`.`cat_id` = `categories`.`id`

WHERE `categories`.`active`=1

GROUP BY `categories`.`id`

amrsoft

8 years ago

Level 1

any idea

kfirba

8 years ago

Level 50

@amrsoft Hey.

I think this should work:

Category::leftJoin('tenders', 'tenders.cat_id', '=', 'categories.id')
    ->where('categories.active', 1)
    ->groupBy('categories.id')
    ->select('categories.id', 'categories.cat_name', \DB::raw('count(tenders.cat_id)'))
    ->get();

The above code produces the following sql query:

select `categories`.`id`, `categories`.`cat_name`, count(tenders.cat_id) from `categories` left join `tenders` on `tenders`.`cat_id` = `categories`.`id` where `categories`.`active` = ? group by `categories`.`id`

jlrdw

8 years ago

Level 75

@amrsoft why?

If you have a working query, you realize at runtime it's converted right back to your original query.

Please or to participate in this conversation.