{{ GBP_SQLREPLACE; NAME:=BODY_LIQ; SQLSCRIPT:= DECLARE @prli_id AS INT select @prli_id = case when prli_idBlocked = 1 then prli_id else 5 end from tbWebSiteII_Names where ws_id = '73d51dcf-41f7-4784-b831-f0da710e7789' SELECT ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 50) ELSE SUBSTRING (ti.item_desc, 1, 50) END [item_desc], SUBSTRING (ti.item_annotation1, 1, 18), dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_vendorCode, ti.brand_id, ti.item_annotation1, ti.item_annotation2, SUBSTRING (ti.item_annotation2, 1, 100), 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, tcat.cat_desc, tsub.subcat_desc, tcat.cat_id, tsub.subcat_id, ti.item_descHTML 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 = @prli_id AND tpli.ws_id = '73d51dcf-41f7-4784-b831-f0da710e7789' 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 = '73d51dcf-41f7-4784-b831-f0da710e7789' WHERE ti.item_id = 46499 AND tpli.itst_LastAvailableInRelalculation > 0; SQLFIELDS4REPLACE:=§ITEM_ID§,§ITEMTIT§,§ITEMCOPETE§,§ITEMCODIGO§,§ITEMCODPROV§,§ITEMMARCAID§,§ITEMDESCORTA1§,§ITEMDESCORTA§,§ITEMDESCORTA100§,§ITEMNOVEDAD§,§ITEMOFERTA§,§ITEMPAGINAFAB§,§PRICE1§,§SYMB1§,§ITEMMARCA§,§CAT_DESC§,§SUBCAT_DESC§,§CAT_ID§,§SCAT_ID§,§ITEMDESCHTML§; 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 = 46499; SQLFIELDS4REPLACE:=§IMGID§,§ALT§; ITEMSBYPAGE:=6; TEMPLATEPAGE:=GALERIADETALLE; }}

§ITEMTIT§

Código: §ITEMCODIGO§

§ITEMDESCORTA1§

§PRICE1§

COMPRAR


{{GBP_INSERTSCRIPT; TEMPLATEPAGE:=SPOTS_RIGHT_1}}
Recomendar este producto

Si la cantidad seleccionada es mayor a la disponible, se ajustará automáticamente al stock existente.

§ITEMDESCHTML§
{{GBP_INSERTFOOTERSCRIPT}}