Dimsav\Translatable\Translatable::scopeWhereTranslation PHP Method

    public function scopeWhereTranslation(Builder $query, $key, $value, $locale = null)
    {
        return $query->whereHas('translations', function (Builder $query) use($key, $value, $locale) {
            $query->where($this->getTranslationsTable() . '.' . $key, $value);
            if ($locale) {
                $query->where($this->getTranslationsTable() . '.' . $this->getLocaleKey(), $locale);
            }
        });
    }