/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

18 votes347 views1 answer
Schema::default string laravel
PHP Laravel
3 votes326 views1 answer
Check file size validation laravel
PHP Laravel
6 votes460 views2 answers
Laravel migration integer
PHP Laravel
2 votes378 views2 answers
Increase memory laravel controller
PHP Laravel
0 vote368 views1 answer
Run laravel localhost network
PHP Laravel
0 vote350 views1 answer
Laravel 8 crud api example
PHP Laravel
0 vote367 views1 answer
Laravel return redirect by stuckOverFlow
PHP Laravel
1 vote354 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote386 views1 answer
Laravelda urlga requestlarni cheklash
PHP Laravel
0 vote363 views3 answers
Laravel where json array column
PHP Laravel