select 
coalesce(unit.FUNITQTY,1) FUNITQTY,
stock.*,
stock.SDEscription product_name,
stock.Sextradesc product_description,
Accintax.SAccountCode IntaxCode,
Accintax.Sdescription IntaxDesc,
intax.FRate IntaxRate,
AccOutTax.SAccountCode outTaxCode,
AccOutTax.Sdescription outTaxDesc,
OutTax.FRate outTaxRate,
COSAcc.SAccountCode COSAccCode,
COSAcc.SDescription COSAccDesc,
SalesAcc.SAccountCode SalesAccCode,
SalesAcc.SDescription SalesAccDesc,
StockAcc.SAccountCode StockAccCode,
StockAcc.SDescription StockAccDesc,
IIF(stock.BDisabled = 1 ,0,1) STOCKSTATUS,
'STK_'|| stock.WStockid image

from 
stock left join UNIT on unit.WUNITID = stock.WUNITID
left join 
STOCK_DESCRIPTIONS sd on (sd.WStockid = stock.WStockid) and WLANGUAGEID in ( 
select wgroupid from IMP_LINK where WGroupid is not null and IMP_EXTID like 'LANG:%' and imp_sourceid = <@SOURCEID@>
) left join 
Tax intax on(stock.WInputtaxid =intax.WaccountId) left join 
Tax OutTax on(stock.WOutputtaxid = OutTax.WaccountId) left join 
Account Accintax on(stock.WInputtaxid = Accintax.WaccountId) left join 
Account AccOutTax on(stock.WOutputtaxid = AccOutTax.WaccountId ) left join 
Account COSAcc on(stock.WCOSTACCOUNTID = COSAcc.WaccountId ) left join 
Account SalesAcc on(stock.WSalesAccountId = SalesAcc.WaccountId ) left join 
Account StockAcc on(stock.WStockAccountId = stockAcc.WaccountId ) 

where 
stock.WStockid = <@KEY@>