select trim(substring(imp_link.IMP_EXTID from 6 for 12)) LANGEXTID, groups.wSortno,  GROUPS_DESCRIPTIONS.* from groups 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@>

