where('registration_complete', true) ->where(function ($query) { $query->whereDoesntHave('client.schedules', fn ($q) => $q->where('status', 'finished')) ->orWhereDoesntHave('client.schedules', fn ($q) => $q->where('status', 'finished') ->where('updated_at', '>=', now()->subDays(30))); }) ->get(); } }