/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 vote362 views1 answer
Laravel carbon first day of month
PHP Laravel
9 votes404 views2 answers
How to Log Query in Laravel
PHP Laravel
4 votes422 views2 answers
Laravel blade errors all
PHP Laravel
0 vote378 views1 answer
Laravel check if primary key exists
PHP Laravel
21 votes344 views4 answers
Laravel where not
PHP Laravel
0 vote368 views1 answer
Laravel migration unknown column type double requested
PHP Laravel
0 vote344 views1 answer
Laravel validation get failed rules
PHP Laravel
0 vote368 views1 answer
Only get selected value from has many ralation laravel
PHP Laravel
0 vote403 views1 answer
Use app http models in laravel 8
PHP Laravel
-1 vote358 views4 answers
Adminlte in laravel 8
PHP Laravel