select SStockcode as DATA , '_sku' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select cast(fSellingprice2 as varchar(100)) as DATA , '_price' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select cast(fSellingprice2 as varchar(100)) as DATA , '_sale_price' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select cast(fSellingprice2 as varchar(100)) as DATA , '_regular_price' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select cast(fqtyonhand as varchar(100)) as DATA , '_stock' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select substring(b.IMP_EXTID  {If SQL Server},{else} from {endif} 6 {If SQL Server},{else}for{endif} 12) , '_primary_term_product_cat' from IMP_LINK b  join
 stock a on 
 b.WGROUPID = a.WReportingGroup1id  and b.imp_sourceid =<@SOURCEID@>
where a.WStockid = <@WSTOCKID@>
union
select '' as DATA , '_product_image_gallery' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'a:3:{s:12:"l-x-b-x-h-cm";a:6:{s:4:"name";s:14:"L x B x H (cm)";s:5:"value";s:13:"'{concat} TRIM(Cast(WLENGTH AS VARCHAR(10))) {concat}'x '{concat} TRIM(Cast(FWIDTH AS VARCHAR(10))) {concat}'x '{concat} TRIM(Cast(WHEIGHT AS VARCHAR(10))) {concat}' cm";s:8:"position";s:1:"0";s:10:"is_visible";s:1:"1";s:12:"is_variation";s:1:"0";s:11:"is_taxonomy";s:1:"0";}s:5:"kleur";a:6:{s:4:"name";s:5:"Kleur";s:5:"value";s:34:"'{concat}trim(SCOLORS){concat}'";s:8:"position";s:1:"1";s:10:"is_visible";s:1:"1";s:12:"is_variation";s:1:"0";s:11:"is_taxonomy";s:1:"0";}s:7:"gewicht";a:6:{s:4:"name";s:7:"Gewicht";s:5:"value";s:5:"'{concat} TRIM(Cast({if SQL Server}round( FGROSSWEIGHT,0){else}trunc( FGROSSWEIGHT){endif} AS VARCHAR(20)))  {concat}' kg";s:8:"position";s:1:"2";s:10:"is_visible";s:1:"1";s:12:"is_variation";s:1:"0";s:11:"is_taxonomy";s:1:"0";}}' as DATA , '_product_attributes' as TYPENAME
from stock left join stock_extra
on  stock_extra.WStockid = stock.WStockid 
 where stock.WStockid = <@WSTOCKID@>


 

 

 