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'