get offer by join id