select order_id
from ec_orders
where user_session_id=:user_session_id
and order_state='in_basket'
select count(*)
from ec_items
where order_id=:order_id
select user_id
from ec_orders
where order_id=:order_id
select shipping_address
from ec_orders
where order_id=$order_id
select creditcard_id
from ec_orders
where order_id=:order_id
select shipping_method
from ec_orders
where order_id=:order_id