php - How to make multiple subquery in Laravel 6?
one text
Solution:
You could make use of the  function
$query = trim($request->get('searchText'));
$titulos = DB::table('titulo as t')
    ->select('t.nombre','t.anio')
    ->selectSub(function ($query) {
        $query->from('Valor')
            ->whereColumn('Valor.id', 'titulo.tipo')
            ->select('Valor.value')
            ->latest()
            ->take(1);
    }, 'tipo')
    ->selectSub(function ($query) {
        $query->from('Valor')
            ->whereColumn('Valor.id', 'titulo.centro')
            ->select('Valor.value')
            ->latest()
            ->take(1);
    }, 'centro')
    ->paginate(7);