delete from <@PREFIX@>vm_product where
PRODUCT_ID='<@KEY@>'
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_name' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_s_desc' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_product' and reference_field = 'product_desc' 
and LANGUAGE_ID not in ( 
<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## 
)
@@GO@@
delete from <@PREFIX@>vm_product_category_xref where product_id = <@KEY@>
@@GO@@
delete from <@PREFIX@>vm_product_price where product_id = <@KEY@>
@@GO@@
delete from <@PREFIX@>vm_product_relations where product_id = <@KEY@>
@@GO@@



