SECOND AMENDED AND RESTATED AGREEMENT OF LIMITED PARTNERSHIP OF SANCHEZ PRODUCTION PARTNERS LP