select <@NEXTID@> MYNEXTID, groupsoptions.SUSE_THUMBNAIL,groupsoptions.SREM,groupsoptions.WLOOKUPTYPE, 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   
join groupsoptions on groups.WGROUPID = groupsoptions.WGROUPID   where 
groups.WGROUPID = <@WGROUPID@> and IMP_LINK.IMP_SOURCEID = <@SOURCEID@>

