SECOND AMENDED & RESTATED ADVISORY AGREEMENT