insert into ec_user_session_info (user_session_id, product_id) values (:user_session_id, :product_id)
select count(*) from ec_user_session_offer_codes where user_session_id=:user_session_id and product_id=:product_id
insert into ec_user_session_offer_codes (user_session_id, product_id, offer_code) values (:user_session_id, :product_id, :offer_code)
update ec_user_session_offer_codes set offer_code=:offer_code where user_session_id=:user_session_id and product_id=:product_id
select offer_code from ec_user_session_offer_codes where user_session_id=:user_session_id and product_id=:product_id
select *
from ec_products p
LEFT JOIN ec_custom_product_field_values v on (p.product_id = v.product_id)
where p.product_id = :product_id
select template
from ec_templates
where template_id=:template_id
SELECT template
FROM ec_templates t, ec_category_template_map ct, ec_category_product_map cp
WHERE t.template_id = ct.template_id
AND ct.category_id = cp.category_id
AND cp.product_id = :product_id
select template
from ec_templates
where template_id=(select default_template
from ec_admin_settings)