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