update  <@PREFIX@>vm_category
set category_name = '<@SDESCRIPTION@>',
category_browsepage = '<@SBROWSEPAGE@>' ,
products_per_row = <@FPRODPERROW@> ,
category_flypage = '<@SFLYPAGE@>' ,
list_order  = '<@FLISTORDER@>'
where category_id = <@KEY@>
@@GO@@

delete from  <@PREFIX@>jf_content where reference_id = <@KEY@> and reference_table='vm_category' and reference_field = 'category_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_category' and reference_field = 'category_description' 
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@@ 