select a.*, substring(c.IMP_EXTID from 6 for 10) IMP_EXTID,
<@PROCESS@>&select  ifnull( max(value_id)+ 1,1) from <@PREFIX@>attr_values ## NEXTID
 from groups a 
 join groups b on b.WGROUPID = a.WPARENTGROUP2ID
join IMP_LINK c on c.WGROUPID = b.WGROUPID 
where
a.WGROUPID = <@KEY@> 

