select count(*) as aggregate from `orders` where exists (select * from `product_warehouse` where `orders`.`warehouse_id` = `product_warehouse`.`id` and exists (select *, COALESCE(
            (select min(`price`) from `product_warehouse` where `product_warehouse`.`product_id` = products.id and `product_warehouse`.`product_id` is not null and `product_warehouse`.`deleted_at` is null),
            (select min(`price`) from `product_pricing` where `product_pricing`.`product_id` = products.id)
        ) AS min_price from `products` where `product_warehouse`.`product_id` = `products`.`id` and exists (select * from `shops` where `products`.`shop_id` = `shops`.`id` and `shop_id` = '2')))

 COALESCE(    
                (select min(`price`) from `product_warehouse` 
                where `product_warehouse`.`product_id` = products.id 
                  and `product_warehouse`.`product_id` is not null 
                  and `product_warehouse`.`deleted_at` is null),
                                (select min(`price`) from `product_pricing` 
                where `product_pricing`.`product_id` = products.id) ) AS min_price