/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

4 votes281 views1 answer
Bcript laravel
PHP Laravel
0 vote265 views1 answer
PaymentIntent::create laravel
PHP Laravel
64 votes301 views6 answers
Delete cache laravel
PHP Laravel
0 vote216 views2 answers
Laravel migration table softdeletes
PHP Laravel
1 vote231 views2 answers
Laravel throttle
PHP Laravel
0 vote239 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
2 votes221 views3 answers
Laravel blade time difference
PHP Laravel
2 votes227 views1 answer
How to use model method in controller in laravel
PHP Laravel
3 votes269 views2 answers
Laravel 8 Target class [FormController] does not exist.
PHP Laravel
0 vote302 views3 answers
Email or phone required in laravel
PHP Laravel