select STOCK.WSTOCKID, 
x.SPROD_S_DESC,
STOCK.SSTOCKCODE, STOCK.SBARCODENUMBER, 
STOCK.SDESCRIPTION, 
STOCK_DESCRIPTIONS.SDescription SEXTRADESCR,
STOCK_DESCRIPTIONS.SEXTRADESCRIPTION LONGDESC,
STOCK.WREPORTINGGROUP1ID, 
STOCK.WREPORTINGGROUP2ID, 
STOCK.WCOSTACCOUNTID, STOCK.WINPUTTAXID, STOCK.WOUTPUTTAXID,
STOCK.FOPENINGAVECOST, 
IIF(STOCK.WSTOCKTYPEID = 1,999,STOCK.FQTYONHAND) FQTYONHAND, STOCK.FOPENINGQTY, 
STOCK.FINVQTYONHAND, STOCK.FREORDERQTY, STOCK.WSALESACCOUNTID, 
STOCK.BAPPLYINVOICEDISCOUNT, STOCK.WSTOCKACCOUNTID, STOCK.FSELLINGPRICE1, 
STOCK.FSELLINGPRICE2, STOCK.FSELLINGPRICE3, STOCK.FUNITAVECOST, 
STOCK.FUNITCOST, STOCK.WUNITID, STOCK.DSYSDATE, STOCK.BAPPLYTAX, 
STOCK.WINPUTTAX2ID, STOCK.BTAXABLE, STOCK.WSUPPLIER1ID, STOCK.WSUPPLIER2ID, STOCK.WSTOCKTYPEID, STOCK.WOUTPUTTAX2ID, 
STOCK.WPROFILEID, STOCK.BDISABLED, STOCK.WPERENTID, 
STOCK.WLOCATIONID, STOCK.WFILENAMEID, STOCK.SEXTRADESC, 
STOCK.SEXTERNALID, STOCK.FNETTOWEIGHT, STOCK.FGROSSWEIGHT, 
STOCK.FREORDERQTYTRIG ,STOCK.SMANUFACTURER, STOCK.FMINIMUMQTY,
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 ,'N','Y') STOCKSTATUS,
 
'STK_'|| stock.WStockid image
 from 
stock 
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 ) 
left join  STOCK_DESCRIPTIONS on stock.wstockid = STOCK_DESCRIPTIONS.WStockid and STOCK_DESCRIPTIONS.WlanguageID = 84  
join STOCK_DESCRIPTIONS_X x on x.WSTOCKDESCID = STOCK_DESCRIPTIONS.WSTOCKDESCID
where Stock.WStockid = <@KEY@>