1)//$palpites=DB::select("SELECT * FROM palpite  WHERE  id_u='$id'   order by id_c desc ");
   2) $palpites = DB::table('palpite')->where('id_u',$id)->orderby('id_c','desc') ->paginate(3);

$confrontos=DB::select("SELECT * FROM confrontos as c, palpite as p WHERE   p.id_u ='$id' AND EXISTS (SELECT * FROM palpite WHERE c.id = p.id_c)  order by id_c desc ");