select 'catalog/product' ATTRIBTYPE , 'Color' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, ''  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'is_recurring' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'links_exist' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'links_purchased_separately' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'manufacturer' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'old_id' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, <@WSTOCKID@> COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'price_type' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'price_view' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'shipment_type' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'sku_type' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'status ' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, IIF(a.BDisabled = 1 ,0,1)  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'tax_class_id ' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, <@PROCESS@>@select imp_extid from IMP_LINK where WTaxid = <@WOUTPUTTAXID@> and imp_sourceid =<@SOURCEID@> ## COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'visibility ' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, null COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'weight_type' ATTRIBNAME, 'catalog_product_entity_int' TABLENAME
 , 0 STORE_ID, 0 COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
