select special_offer.*, unix_timestamp(expiry_date) as unix_date from special_offer left join (profile) on (special_offer.profile_id=profile.id) where special_offer.published="true" and (special_offer.permanent="true" or special_offer.expiry_date="0" or special_offer.expiry_date >= "2017-06-23 00:00:00") group by special_offer.id order by ((profile.zip>=1000 and profile.zip<=2999) or (profile.zip>=3700 and profile.zip<=3799)) desc, special_offer.id desc limit 30