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 update ec_financial_transactions set failed_p = 't' where transaction_id = :transaction_id" update ec_financial_transactions set failed_p = 't' where transaction_id = :transaction_id