/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

0 vote125 views2 answers
Create storage link laravel without terminal server
PHP Laravel
2 votes133 views1 answer
Laravel how to test email testing
PHP Laravel
2 votes145 views2 answers
Laravel/ui for laravel 7
PHP Laravel
0 vote125 views1 answer
Skip model accessor laravel8
PHP Laravel
23 votes123 views6 answers
Laravel logs
PHP Laravel
0 vote119 views1 answer
How to add a clock in laravel
PHP Laravel
8 votes133 views5 answers
Laravel route is current route
PHP Laravel
22 votes118 views5 answers
Foreign key string laravel
PHP Laravel
0 vote129 views1 answer
Laravel get biggest id
PHP Laravel
6 votes120 views4 answers
Install laravel on windows
PHP Laravel