select order_id from ec_orders where user_session_id=:user_session_id and order_state='in_basket' select order_id from ec_orders where user_id=:user_id and confirmed_date is not null and order_id=( select max(o2.order_id) from ec_orders o2 where o2.user_id=:user_id and o2.confirmed_date is not null ) 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