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