19.98 ORDER BY procent DESC LIMIT 1)"; } // removes the last union #$query .= substr($query, -1, strlen(" UNION ")); #echo "

";
	    #var_dump($query); exit;

	    /*
	    $dbh = DB::connection('mysql')->getPdo();
	    $stmt = $dbh->prepare($query);
	    $stmt->execute();

	    $data = $stmt->fetchAll(\PDO::FETCH_ASSOC);
	     */


	    #var_dump($query); exit;
	    $data = DB::select($query);
		#$data = DB::table('whisky_view')->orderBy('procent', 'DESC')->limit(100)->simplePaginate(20);

        return view('index', ['data' => $data]);
    }
}