{{ GBP_SQLREPLACE; NAME:=BODY_LIQ; SQLSCRIPT:= SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 75) ELSE SUBSTRING (ti.item_desc, 1, 75) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 18), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.item_annotation1, ti.item_annotation2, ti.item_annotation, SUBSTRING (ti.item_annotation2, 1, 100), ti.item_descHTML, tbn.wssn_isNovelty, tbn.wssn_is4Sale, item_WebSite_vendorPage, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], tc.curr_symbol, tbr.brand_desc, tbr.brand_id, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN (ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND ti.item_isForAssociation='false') OR tpli.semaphoreValue <= 1 THEN 'True' ELSE 'False' END [grisar_boton], convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0'))), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPrice,'0')) > convert(decimal(16,2), tpli.prli_price) THEN 'True' else 'False' END [PRECIOTACHADOMOSTRAR] FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 21 AND tpli.ws_id = '43e8c54d-c706-4f55-bd68-65d718d288c7' INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_id INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '43e8c54d-c706-4f55-bd68-65d718d288c7' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.comp_id LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE ti.item_id = 981; SQLFIELDS4REPLACE:=§ESFABRICACION§,§STOCKSEMAFORO§,§ITEM_ID§,§ITEMTIT§,§ITEM_COPETE_CORTO§,§ITEMCODIGO§,§ITEMCODPROV§,§ITEM_COPETE§,§ITEM_DESCORTA§,§ITEM_ANOTATION2§,§ITEM_DESCORTA_CORTA§,§ITEM_DESLARGA§,§ITEMNOVEDAD§,§ITEMOFERTA§,§ITEMPAGINAFAB§,§PRICE1§,§SYMB1§,§ITEMMARCADESC§,§ITEMMARCAIMG§,§CAT_DESC§,§SUBCAT_DESC§,§CAT_ID§,§SCAT_ID§,§IVA§,§GRISARBOTON§,§PRECIOTACHADOSINIMPUESTOS§,§PRECIOTACHADOMOSTRAR§; ITEMSBYPAGE:=1; }} {{ GBP_SQLREPLACE; NAME:=TALLE_COLOR_VISIBILIDAD; SQLSCRIPT:= SELECT CASE WHEN COUNT(tc.item_id) > 0 THEN 'block' ELSE 'none' END [mostrar], CASE WHEN COUNT(tc.item_id) > 0 THEN 'none' ELSE 'block' END [no_mostrar] FROM tbitem ti LEFT JOIN vwWebSiteII_itemSizeColor tc ON tc.comp_id = ti.comp_id AND tc.item_id = ti.item_id WHERE ti.item_id = 981 and ti.comp_id=1 GROUP BY tc.item_id; SQLFIELDS4REPLACE:=§MOSTRARTALLECOLOR§,§OCULTARTALLECOLOR§; ITEMSBYPAGE:=1; }}
{{ GBP_LIST; NAME:=GALERIADETALLE; SQLSCRIPT:= SELECT tii.itimg_id ,ti.item_desc FROM tbItemImages tii INNER JOIN tbItem ti ON ti.item_id = tii.item_id WHERE tii.item_id = 981; SQLFIELDS4REPLACE:=§IMGID§,§ALT§; ITEMSBYPAGE:=6; TEMPLATEPAGE:=GALERIADETALLE; }}

CODIGO: §ITEMCODIGO§

§ITEMTIT§

§ITEM_COPETE§
§ITEM_DESCORTA§

Seleccione un talle y color para continuar con la compra:

Medida:

    §SYMB1§ §PRICE1§





    Descripción del producto

    §ITEM_DESLARGA§
    {{GBP_INSERTSCRIPT;TEMPLATEPAGE:=PRODUCTOS_RELACIONADOS;}}


    Consúltenos por este producto

    {{GBP_INSERTFOOTERSCRIPT}}