select 'catalog/product' ATTRIBTYPE , 'country_of_manufacture ' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, ''  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'custom_design' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'gallery' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, a.Sdescription COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'gift_message_available' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, ''  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'links_title' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'links_title' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>

union
select 'catalog/product' ATTRIBTYPE , 'image' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '<@PROCESS@>@Select '/' ||substring(lower(m.SDESCRIPTION) from 1 for 1) || '/' || substring(lower(m.SDESCRIPTION) from 2 for 1) || '/' || lower(m.SDESCRIPTION) dest, m.sgroup from MULTIMEDIA m join stock s on m.wrefid = s.wstockid where m.WREFID =  <@WSTOCKID@> and m.STYPE = 'STOCK' and (m.SPATH like 'link:%' or m.SPATH like 'file:%') and (m.SGROUP = 'products_image') ##' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>

union
select 'catalog/product' ATTRIBTYPE , 'small_image' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '<@PROCESS@>@Select '/' ||substring(lower(m.SDESCRIPTION) from 1 for 1) || '/' || substring(lower(m.SDESCRIPTION) from 2 for 1) || '/' || lower(m.SDESCRIPTION) dest, m.sgroup from MULTIMEDIA m join stock s on m.wrefid = s.wstockid where m.WREFID =  <@WSTOCKID@> and m.STYPE = 'STOCK' and (m.SPATH like 'link:%' or m.SPATH like 'file:%') and (m.SGROUP = 'products_image') ##' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'thumbnail' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '<@PROCESS@>@Select '/' ||substring(lower(m.SDESCRIPTION) from 1 for 1) || '/' || substring(lower(m.SDESCRIPTION) from 2 for 1) || '/' || lower(m.SDESCRIPTION) dest, m.sgroup from MULTIMEDIA m join stock s on m.wrefid = s.wstockid where m.WREFID =  <@WSTOCKID@> and m.STYPE = 'STOCK' and (m.SPATH like 'link:%' or m.SPATH like 'file:%') and (m.SGROUP = 'products_image') ##' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>

union
select 'catalog/product' ATTRIBTYPE , 'image_label' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '<@PROCESS@>@Select  m.SDESCRIPTION dest  from MULTIMEDIA m join stock s on m.wrefid = s.wstockid where m.WREFID =  <@WSTOCKID@>  and m.STYPE = 'STOCK' and (m.SPATH like 'link:%' or m.SPATH like 'file:%') and (m.SGROUP = 'product_image') ##' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'links_title' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'media_gallery' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'meta_description' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, trim(a.SDESCRIPTION) COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'meta_title' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, trim(a.SDESCRIPTION) COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'msrp_display_actual_price_type' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'msrp_enabled' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'name' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, trim(a.SDESCRIPTION) COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'url_key' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, replace( trim(a.SDESCRIPTION),' ','-') COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'url_path' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, replace( trim(a.SDESCRIPTION),' ','-') || '.html' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'options_container' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'page_layout' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'samples_title' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, '' COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'small_image_label' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, trim(a.SDESCRIPTION) COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'thumbnail_label' ATTRIBNAME, 'catalog_product_entity_varchar' TABLENAME
 , 0 STORE_ID, trim(a.SDESCRIPTION) COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>