/PHP/Laravel/Count with left join in laravel

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')
	->get();

Source: github.com

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')    
	->get();

Source: github.com

Count with left join in laravel

$areas = Area::select('areas.*', DB::raw('count(area_id) as connections'))
	->leftJoin('object_areas', 'object_areas.area_id', '=', 'areas.id')
	->groupBy('areas.id')gg
	->get();

Source: github.com

Similar codes

8 votes114 views3 answers
What is route namespace in laravel
PHP Laravel
37 votes120 views6 answers
Laravel order by
PHP Laravel
0 vote101 views1 answer
Laravel get current action name
PHP Laravel
7 votes102 views1 answer
Laravel not in query
PHP Laravel
0 vote107 views1 answer
Validate user password laravel8
PHP Laravel
0 vote115 views1 answer
Laravel Http client retry request if fail
PHP Laravel
0 vote117 views2 answers
String to array in laravel
PHP Laravel
0 vote117 views1 answer
Add selected to dropdpown item laravel
PHP Laravel
6 votes111 views6 answers
Laravel folder permission
PHP Laravel
24 votes164 views4 answers
Clear cache command in laravel controller
PHP Laravel