Stuff

select distinct
offer.offerid, offerpacks.bookpack,offer.staydate2

from offer,offerpacks

where
offer.offerid=offerpacks.offer
and (offer.bookdate1<= 1136073600
or ((offer.bookdate1-(86400*3)))= (1136073600-(86400*3)))
and offer.bookdate2>= 1136073600

and (offer.staydate1<= 1136937600
or ((offer. staydate1-(86400*3)))= (1136937600-(86400*3)))
and offer. staydate2 >= 1136937600