get offer by query