select 'catalog/product' ATTRIBTYPE , 'custom_layout_update' ATTRIBNAME, 'catalog_product_entity_text' TABLENAME
 , 0 STORE_ID, ''  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select first 1 'catalog/product' ATTRIBTYPE , 'description' ATTRIBNAME, 'catalog_product_entity_text' TABLENAME
 , 0 STORE_ID,trim(coalesce(cast(b.SEXTRADESCRIPTION as char(2000))
,a.Sdescription)) COLVALUE
 from stock a  left join STOCK_DESCRIPTIONS b on a.wstockid = b.wstockid  where a.wstockid = <@WSTOCKID@>
and b.WLANGUAGEID = {if interbase}(SELECT first 1 p.WLANGUAGEID
FROM GETUSERLANG p){else}GETUSERLANG(){endif}


union
select 'catalog/product' ATTRIBTYPE , 'meta_keyword' ATTRIBNAME, 'catalog_product_entity_text' TABLENAME
 , 0 STORE_ID,trim(coalesce(b.Sdescription,a.Sdescription)) COLVALUE
 from stock a  left join STOCK_DESCRIPTIONS b on a.wstockid = b.wstockid  where a.wstockid = <@WSTOCKID@>
and b.WLANGUAGEID = {if interbase}(SELECT first 1 p.WLANGUAGEID
FROM GETUSERLANG p){else}GETUSERLANG(){endif}
union
select 'catalog/product' ATTRIBTYPE , 'recurring_profile' ATTRIBNAME, 'catalog_product_entity_text' TABLENAME
 , 0 STORE_ID, ''  COLVALUE
 from stock a where a.wstockid = <@WSTOCKID@>
union
select 'catalog/product' ATTRIBTYPE , 'short_description' ATTRIBNAME, 'catalog_product_entity_text' TABLENAME
 , 0 STORE_ID,trim(coalesce(cast(b.SEXTRADESCRIPTION as char(2000))
,a.Sdescription)) COLVALUE
 from stock a  left join STOCK_DESCRIPTIONS b on a.wstockid = b.wstockid  where a.wstockid = <@WSTOCKID@>
and b.WLANGUAGEID = {if interbase}(SELECT first 1 p.WLANGUAGEID
FROM GETUSERLANG p){else}GETUSERLANG(){endif}