Как написать такой SQL запрос в Laravel?

Question

[PRIZRAKeee]

Есть такой запрос, который работает, если им воcпользоваться в phpmyadmin.

(SELECT * FROM products WHERE brand = 'Atlas Copco' ORDER BY created_At DESC) UNION (SELECT * FROM products WHERE brand != 'Atlas Copco' ORDER BY created_at DESC)

Но у меня никак не получается написать его для Laravel в eloquent orm
Пытался сделать так, но выдаёт ошибку

$products_atlas_copco = $category->products()->whereBrand('Atlas Copco')->orderBy('created_at', 'desc')->public();
$products = $category->products()->where('brand','!=','Atlas Copco')->orderBy('created_at', 'desc')->public()->union($products_atlas_copco);

Но по отдельности оба запроса работают, если я сделаю так

$products_atlas_copco = $category->products()->whereBrand('Atlas Copco')->orderBy('created_at', 'desc')->public();
$products = $category->products()->where('brand','!=','Atlas Copco')->orderBy('created_at', 'desc')->public();

Подскажите пожалуйста. где я ошибку делаю

Comments

[Александр]

убери из 1-ого цепочки метод ->public();

$products_atlas_copco = $category->products()
    ->whereBrand('Atlas Copco')
    ->orderBy('created_at', 'desc');
$products = $category->products()
    ->where('brand','!=','Atlas Copco')
    ->orderBy('created_at', 'desc')
    ->union($products_atlas_copco)
    ->public();

[PRIZRAKeee]

Minifets, к сожалению пишет две ошибки

Первая
SQLSTATE[42000]: Syntax error or access violation: 1250 Table 'products' from one of the SELECTs cannot be used in global ORDER clause (SQL: (select count(*) as aggregate from `products` where `products`.`catalog_id` = 2 and `products`.`catalog_id` is not null and `brand` != Atlas Copco and `products`.`published` = 1 and `products`.`deleted_at` is null order by `created_at` desc) union (select * from `products` where `products`.`catalog_id` = 2 and `products`.`catalog_id` is not null and `brand` = Atlas Copco and `products`.`deleted_at` is null order by `created_at` desc) order by `products`.`order` asc)

Вторая
SQLSTATE[42000]: Syntax error or access violation: 1250 Table 'products' from one of the SELECTs cannot be used in global ORDER clause