postgresql7.1
select product_id from ec_products
where sku = :sku
insert into ec_subsubcategory_product_map (
product_id,
subsubcategory_id,
publisher_favorite_p,
last_modified,
last_modifying_user,
modified_ip_address)
values (
:product_id,
:subsubcategory_id,
'f',
now(),
:user_id,
:ip)
insert into ec_subcategory_product_map (
product_id,
subcategory_id,
publisher_favorite_p,
last_modified,
last_modifying_user,
modified_ip_address)
values (
:product_id,
:subcategory_id,
'f',
now(),
:user_id,
:ip)
insert into ec_category_product_map (
product_id,
category_id,
publisher_favorite_p,
last_modified,
last_modifying_user,
modified_ip_address)
values (
:product_id,
:category_id,
'f',
now(),
:user_id,
:ip)
insert into ec_category_product_map (
product_id,
category_id,
publisher_favorite_p,
last_modified,
last_modifying_user,
modified_ip_address)
values (
:product_id,
:category_id,
'f',
now(),
:user_id,
:ip)