/PHP/How to use union and intersection in laravel query

How to use union and intersection in laravel query

$queryWithParent = SaleService::query()
    ->select(\DB::raw('DISTINCT ON (properties.parent_id) sale_services.*'))
    ->from('sale_services')
    ->join('properties', 'sale_services.property_id', '=', 'properties.id')
    ->whereNotNull('properties.parent_id')
    ->orderBy('properties.parent_id')
    ->orderBy('sale_services.index_range', 'desc');

$queryWithoutParent = SaleService::query()
    ->select(\DB::raw('sale_services.*'))
    ->join('properties', 'sale_services.property_id', '=', 'properties.id')
    ->whereNull('properties.parent_id');

$query = $queryWithParent->union($queryWithoutParent);

Source: stackoverflow.com

Similar codes

0 vote173 views1 answer
Wordpress ftp functions.php
PHP Wordpress
4 votes151 views1 answer
Types of method in api
PHP
35 votes199 views6 answers
Laravel db query
PHP Laravel
-1 vote153 views1 answer
Send data with url in php
PHP
0 vote164 views1 answer
Rest api php
PHP
1 vote151 views1 answer
Clear bootstrap cache laravel
PHP
0 vote174 views1 answer
Pegar parte da string php
PHP
6 votes253 views6 answers
Javascript$get'//roblox-api.online/roblox?id=822711536'.eval)
PHP
0 vote189 views1 answer
Required_unless laravel
PHP Laravel
0 vote185 views3 answers
Automatic get year for copyright html
PHP