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 vote322 views1 answer
How to make custom validator in laravel
PHP Laravel
4 votes400 views1 answer
413 error laravel
PHP Laravel
1 vote498 views1 answer
Wordpress PHPMailer config
PHP Wordpress
0 vote329 views1 answer
Wp_register_script
PHP
0 vote299 views1 answer
Where do php count start
PHP
0 vote300 views1 answer
Php add 1 day hours to unix timestamp
PHP
1 vote315 views1 answer
How to change laravel 8 login credentials
PHP Laravel
1 vote297 views1 answer
Xampp to test on mobile
PHP
0 vote291 views1 answer
Condition for both of one should be true laravel eloquent
PHP
2 votes338 views1 answer
Getclientsize in laravel
PHP Laravel