update catalog_category_entity
set 
parent_id = <@PROCESS@>@select trim(substring(IMP_EXTID from 6 for 12)) from IMP_LINK where WGROUPID =
 <@WPARENTGROUP2ID@> and imp_sourceid =<@SOURCEID@> ##,
path = '1/2/<@PROCESS@>@select trim(substring(IMP_EXTID from 6 for 12)) from IMP_LINK where WGROUPID =
 <@WPARENTGROUP2ID@> and imp_sourceid =<@SOURCEID@> ##/<@PROCESS@>@select trim(substring(IMP_EXTID from 6 for 12)) 
from IMP_LINK where WGROUPID = <@WGROUPID@> and imp_sourceid =<@SOURCEID@> ##',
updated_at = now(),
position = '<@WSORTNO@>'
where entity_id = <@KEY@>