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

17 votes390 views5 answers
?: php
PHP
4 votes321 views2 answers
How to get woocommerce product price
PHP
9 votes390 views2 answers
Make resource in laravel
PHP Laravel
9 votes392 views2 answers
How to Log Query in Laravel
PHP Laravel
10 votes315 views4 answers
Laravel migration change column default
PHP
1 vote300 views1 answer
Get elasticsearch data magento 2
PHP
2 votes342 views2 answers
Laravel switch
PHP
0 vote346 views1 answer
How to fix Undefined variable: product (View: C:\xampp\htdocs\ecommerce\resources\views\livewire\shop-component.blade.php)
PHP
0 vote410 views2 answers
Wordpress single post template
PHP Wordpress
3 votes363 views1 answer
Laravel carbon get year number
PHP Laravel