Hello, I'm trying to search in different language. How i read in documentation i must use ' join ' on translations but it don't working.
Every search works except translations.
Controller:
public function webSearch(Request $request)
{
$translations = \DB::table('articles')->join('translations', 'articles.id', '=', 'translations.id')->where('title', 'LIKE', "%{$request->search}%")->orderBy('published_at', 'Desc')->get();
$articles = Article::where('title', 'LIKE', "%{$request->search}%")->orderBy('published_at', 'Desc')->get();
$episodes = Episode::where('title', 'LIKE', "%{$request->search}%")->orderBy('published_at', 'Desc')->get();
$quizzes = Quizze::where('title', 'LIKE', "%{$request->search}%")->orderBy('published_at', 'Desc')->get();
$shows = Show::where('title', 'LIKE', "%{$request->search}%")->orderBy('published_at', 'Desc')->get();
return view('pages/search')
->with('articles', $articles)
->with('episodes', $episodes)
->with('quizzes', $quizzes)
->with('shows', $shows)
->with('translations', $translations);
}