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