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 vote260 views1 answer
Laravel subtract date
PHP Laravel
0 vote226 views1 answer
Cakephp 3
PHP CakePHP
0 vote218 views1 answer
Like query with prepare wordpress
PHP
0 vote202 views1 answer
Redirect compact laravel
PHP
4 votes197 views1 answer
Send json reponse php
PHP
8 votes197 views1 answer
Get all routes laravel
PHP
0 vote232 views1 answer
Add attachment to the invoice laravel
PHP Laravel
4 votes239 views2 answers
Define home url wp
PHP Wordpress
0 vote280 views1 answer
Drupal 8 user_load
PHP Drupal
0 vote262 views1 answer
Form validation for file type in codeigniter
PHP