select   trim(substring(imp_link.IMP_EXTID from 6 for 12)) LANGEXTID, groups.wSortno,  GROUPS_DESCRIPTIONS.* , replace(cast(grx.SExtraDesc as varchar(5000)), ASCII_CHAR(13)||ASCII_CHAR(10),' ' )  SExtraDesc from groups join
 GROUPS_DESCRIPTIONS 
on groups.WGROUPID = GROUPS_DESCRIPTIONS.WGROUPID 
join GROUP_DESC_EXTRA grx on grx.WGROUPDESCID = GROUPS_DESCRIPTIONS.WGROUPDESCID
join IMP_LINK on GROUPS_DESCRIPTIONS.WLANGUAGEID = IMP_LINK.WGROUPID  
where 
groups.WGROUPID = <@WGROUPID@> and IMP_LINK.IMP_SOURCEID = <@SOURCEID@>
and GROUPS_DESCRIPTIONS.WLANGUAGEID not in ( 
<@PROCESS@>*SELECT a.WGROUPID 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:%' ## 
)


