SECOND AMENDED AND RESTATED ADVISORY AGREEMENT between