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 cast(0 as varchar(100)) as DATA , 'total_sales' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'taxable' as DATA , '_tax_status' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>

union
select '' as DATA , '_tax_class' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>

union
 
select 'yes' as DATA , '_manage_stock' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'no' as DATA , '_backorders' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union 
select '0' as DATA , '_low_stock_amount' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'no' as DATA , '_sold_individually' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'no' as DATA , '_virtual' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'no' as DATA , '_downloadable' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '' as DATA , '_product_image_gallery' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '-1' as DATA , '_download_limit' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '-1' as DATA , '_download_expiry' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '' as DATA , '_thumbnail_id' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'instock' as DATA , '_stock_status' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '0' as DATA , '_wc_average_rating' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '0' as DATA , '_wc_review_count' 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@>
union
select '0' as DATA , '_product_version' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'default' as DATA , '_et_pb_post_hide_nav' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'et_right_sidebar' as DATA , '_et_pb_page_layout' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
 union
select 'off' as DATA , '_et_pb_side_nav' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
 union
select '' as DATA , '_et_pb_use_builder' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
 union
select '' as DATA , '_et_pb_first_image' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select '' as DATA , '_et_pb_old_content' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
union
select 'a:2:{s:6:"family";a:1:{s:16:"et-gf-montserrat";s:137:"Montserrat:100,100italic,200,200italic,300,300italic,regular,italic,500,500italic,600,600italic,700,700italic,800,800italic,900,900italic";}s:6:"subset";a:3:{i:0;s:10:"vietnamese";i:1;s:5:"latin";i:2;s:9:"latin-ext";}}' as DATA , 'et_enqueued_post_fonts' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>
 union
select '1' as DATA , '_edit_last' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>	
 union
select '1571666066:1' as DATA , '_edit_lock' as TYPENAME
from stock
 where WStockid = <@WSTOCKID@>

 

 