select zip_code from ec_addresses a, ec_orders o where a.address_id=o.shipping_address and order_id=:order_id