public function scopeIsVerifiedForComponent(Builder $query, $component_id)
    {
        return $query->select('subscriptions.*')
            ->join('subscribers', 'subscriptions.subscriber_id', '=', 'subscribers.id')
            ->where(function ($query) {
                $query->where('subscriptions.component_id', '=', $component_id)
                    ->orWhere('subscribers.global');
            })
            ->whereNotNull('subscribers.verified_at');
    }