select trim(substring(imp_link.IMP_EXTID from 6 for 12)) LANGEXTID, groups.wSortno, 
<@PROCESS@>&select ifnull(max(products_options_values_id)+ 1,1) from products_options_values ## OSCNEXTID,
trim(trim(b.SDescription) || '_' || groups.SDescription) SFileDescription,

 GROUPS_DESCRIPTIONS.* from groups 
join groups b on groups.WPARENTGROUP2ID = b.Wgroupid
 join GROUPS_DESCRIPTIONS on groups.WGROUPID = GROUPS_DESCRIPTIONS.WGROUPID 
join IMP_LINK on GROUPS_DESCRIPTIONS.WLANGUAGEID = IMP_LINK.WGROUPID  
 where 
groups.WGROUPID = <@WGROUPID@> and IMP_LINK.IMP_SOURCEID = <@SOURCEID@>

