ORM generates inappropriate SQL query: " SELECT * FROM posts WHERE ( title like '%Ut%' or body like '%Ut%' and EXISTS ( SELECT * FROM categories WHERE posts.category_id = categories.id and slug = 'fuga' ) ) ORDER BY created_at DESC".

I believe that appropriate SQL query is: "SELECT * FROM posts WHERE EXISTS ( SELECT * FROM categories WHERE posts.category_id = categories.id and slug = 'fuga' ) and ( title like '%Ut%' or body like '%Ut%' ) ORDER BY created_at DESC" because otherwise in results we get posts from others categories.

The code I wrote to write this query: $query->when($filters['category'] ?? false, fn ($query, $category) => $query->whereHas('category', fn ($query) => $query->where('slug', $category)));

    $query->when($filters['author'] ?? false, fn ($query, $author) =>
    $query->whereHas('author', fn ($query) =>
    $query->where('username', $author)));

    $query->when(
        $filters['search'] ?? false,
        function ($query, $search){
            $query
            ->where(function($query) use ($search){
                $query->where('title', 'like', '%' . $search . '%')
                ->orWhere('body', 'like', '%' . $search . '%');
            });
        }
    );

Merge Category and Search Queries

Updated Series Available