Productos que podrían interesarte
{{
GBP_LIST;
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, 50)
ELSE
SUBSTRING (ti.item_desc, 1, 50)
END [item_desc],
SUBSTRING (ti.item_annotation1, 1, 20),
dbo.fnStrAllTrim(ti.item_code) [item_code],
ti.item_vendorCode,
ti.brand_id,
ti.item_annotation2,
SUBSTRING (ti.item_annotation2, 1, 90),
tbn.wssn_isNovelty,
tbn.wssn_is4Sale,
item_WebSite_vendorPage,
CASE WHEN {(GBP_CUSTOMER)} = -1 AND '{(GBP_VARIABLE1)}' <> '' THEN (SELECT '{(GBP_VARIABLE1)}') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price],
tc.curr_symbol,
tbr.brand_desc,
CASE WHEN i4c.item_id = ti.item_id THEN '
Ver Comparacion' else 'Comparar' END [checked],
convert (decimal(16,2), ttn.tax_percentage) [IVA]
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 = {(GBP_PRICELIST)} AND tpli.ws_id = '{(GBP_WSID)}'
INNER JOIN tbsysCurrency tc ON tc.curr_id = tpli.curr_id
INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id
INNER JOIN tbSubCategory tsub ON tsub.subcat_id = ti.subcat_id
INNER JOIN tbCategory tcat ON tcat.cat_id = ti.cat_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 = '{(GBP_WSID)}'
LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = '{(GBP_GUID)}'
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_web = 'true' AND ti.item_id <> '2271' and ti.subcat_id = '3932';
SQLFIELDS4REPLACE:=§ESFABRICACION§,§STOCKSEMAFORO§,§ITEMID§,§ITEMTIT§,§ITEMCOPETE§,§ITEMCODIGO§,§ITEMCODPROV§,§ITEMMARCAID§,§ITEMDESCORTA§,§ITEMDESCORTA90§,§ITEMNOVEDAD§,§ITEMOFERTA§,§ITEMPAGINAFAB§,§PRICE1§,§SYMB1§,§ITEMMARCA§,§COMPATEXT§,§IVA§;
ITEMSBYPAGE:=3;
TEMPLATEPAGE:=CAJA_PRODUCTO1;
}}