select order_id, user_id as order_owner from ec_orders where user_session_id=:user_session_id and order_state='in_basket' select count(*) from ec_addresses where address_id = :address_id and user_id = :user_id update ec_orders set shipping_address = :address_id where order_id = :order_id select shipping_address from ec_orders where order_id = :order_id select p.no_shipping_avail_p, count (*) from ec_items i, ec_products p where i.product_id = p.product_id and p.no_shipping_avail_p = 'f' and i.order_id = :order_id group by no_shipping_avail_p