[New post] PHP code snippet – How to use union and intersection in laravel query?

Subash Chandran posted: "$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('pr" New post on Poopcode PHP code snippet – How to use union and intersection in laravel query? by Subash Chandran $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); Read more of this post Subash Chandran | November 20, 2021 at 11:26 am | Tags: how to use union and intersection in laravel query, how to use union in laravel, how to use union in laravel in select query, laravel intersect query, laravel query optimization usng union and intersection, laravel union query, laravel union two queries | Categories: Snippets | URL: https://wp.me/pb9kQA-4tR Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/php-code-snippet-how-to-use-union-and-intersection-in-laravel-query/