select order_id from ec_orders where user_session_id=:user_session_id and order_state='in_basket' update ec_orders set user_id=:user_id where order_id=:order_id select address_id, attn, line1, line2, city, usps_abbrev, zip_code, phone, country_code, full_state_name, phone_time from ec_addresses where user_id=:user_id and address_type='shipping'