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