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 insert into ec_creditcards (creditcard_id, user_id, creditcard_number, creditcard_last_four, creditcard_type, creditcard_expire, billing_address) values (:creditcard_id, :user_id, :creditcard_number,:cc_fmt , :creditcard_type, :expiry, :address_id) update ec_orders set creditcard_id = :creditcard_id where order_id = :order_id and order_state = 'in_basket'