select min(price) from ec_offers where product_id=:product_id select retailprice from ec_custom_product_field_values where product_id=:product_id select min(price) from ec_offers where product_id=:product_id select user_id,first_names,last_name,email,other_id_info,postal_code from ec_user_identification where user_identification_id=:user_identification_id select first_names || ' ' || last_name from cc_users where user_id=:user_id select line1, line2, city, usps_abbrev, zip_code, country_code, full_state_name, attn, phone, phone_time from ec_addresses where address_id=:address_id select creditcard_type, creditcard_last_four, creditcard_expire, billing_zip_code from ec_creditcards where creditcard_id=:creditcard_id select default_name from country_names where iso=:country_code select case when shipping_method = 'no shipping' then 0 else 1 end as shippable_p from ec_orders where order_id=:order_id select gift_certificate_state, user_id from ec_gift_certificates where gift_certificate_id=:gift_certificate_id