select WLANGUAGEID,stock.WStockid, replace(cast(STOCK_DESCRIPTIONS.SDESCRIPTION as Varchar(200)),ASCII_CHAR(13)||ASCII_CHAR(10),' ' ) DESCRIPTION 
, replace(cast(STOCK_DESCRIPTIONS .SEXtraDescription as Varchar(6000)),'',' ' ) EXTRADESCRIPTION 
, replace(cast(x.SPROD_S_DESC as Varchar(6000)),ASCII_CHAR(13)||ASCII_CHAR(10),' ' ) SMALLEXTRADESCRIPTION 
 from STOCK_DESCRIPTIONS 
join stock on STOCK_DESCRIPTIONS.WStockid = stock.WStockid 
and WLANGUAGEID in ( 

SELECT  a.WGROUPID  from IMP_LINK a
left 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:%'
and b.imp_sourceid is null
) left join STOCK_DESCRIPTIONS_X x on x.WSTOCKDESCID = STOCK_DESCRIPTIONS.WSTOCKDESCID

where stock.WStockid = <@WSTOCKID@>
 

 

