select * from OfferManager where offerid=#offerid#