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 c.creditcard_type, c.creditcard_number, c.creditcard_expire, a.* from ec_creditcards c, ec_addresses a, ec_orders o where c.creditcard_id = o.creditcard_id and order_id = :order_id and c.billing_address = a.address_id