if (!empty($request->search)) $query->where('candidates.name', 'like', "%$request->search%")->orWhere('candidates.email', 'like', "%$request->search%")->orWhere('candidates.skype', 'like', "%$request->search%");

(`candidates`.`name` like %Oleksandr Matsuk% or `candidates`.`email` like %Oleksandr Matsuk% or `candidates`.`skype` like %Oleksandr Matsuk% and `vacancies_to_candidates`.`status` != 1

```(`candidates`.`name` like %Oleksandr Matsuk% or `candidates`.`email` like %Oleksandr Matsuk% or `candidates`.`skype` like %Oleksandr Matsuk%) and `vacancies_to_candidates`.`status` != 1

$users = DB::table('users')
            ->where('votes', '>', 100)
            ->orWhere(function($query) {
                $query->where('name', 'Abigail')
                      ->where('votes', '>', 50);
            })
            ->get();