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 c.creditcard_type, c.creditcard_last_four, c.creditcard_expire, a.address_id
from ec_creditcards c, ec_addresses a
where creditcard_id = :creditcard_id
and c.billing_address = a.address_id
select default_name from countries 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
delete from ec_product_purchase_comb
where exists (select product_id
from ec_products p
where p.active_p = 'f'
and p.product_id in (ec_product_purchase_comb.product_id, ec_product_purchase_comb.product_0,
ec_product_purchase_comb.product_1, ec_product_purchase_comb.product_2,
ec_product_purchase_comb.product_3, ec_product_purchase_comb.product_4))
select url
from ec_products
where product_id = :product_id