select STOCK_DESCRIPTIONS.*,x.sdescription LANGEXTID from STOCK_DESCRIPTIONS join groups x on x.wgroupid = STOCK_DESCRIPTIONS.WLANGUAGEID 
 where WStockid = <@WSTOCKID@>
and WLANGUAGEID in ( 
select wgroupid from IMP_LINK where WGroupid is not null and IMP_EXTID like 'LANG:%' and imp_sourceid = <@SOURCEID@>
)
