/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 vote338 views1 answer
Clear from faild_jobs laravel
PHP Laravel
2 votes354 views1 answer
Laravel app get locale
PHP Laravel
3 votes346 views2 answers
Name csrf token laravel mismatch
PHP Laravel
0 vote375 views1 answer
Show selected value in dropdown laravel
PHP Laravel
12 votes327 views5 answers
Drop column migration laravel
PHP Laravel
1 vote384 views1 answer
Laravel command parameter optional
PHP Laravel
0 vote375 views1 answer
Form validation nullable laravel
PHP Laravel
2 votes309 views3 answers
Laravel get file contents from storage
PHP Laravel
37 votes385 views4 answers
Foreign key in laravel migration
PHP Laravel
0 vote340 views1 answer
Laravel faker generate country code
PHP Laravel