Distribuidora Mayorista con venta directa
JABON

REXONA JAB PASTILLA COTTON FRESH 3 X 120

CODIGO: 7791293050935

Los jabones en barra Rexona Cotton Fresh recargan tus energías en la ducha y en tu lavado de manos para no parar de moverte. El jabón individual en pastilla Rexona, con extracto de algodón y notas florales, se encuentra dermatológicamente testeado.
ARS 3216.65

Los jabones en barra Rexona Cotton Fresh recargan tus energías en la ducha y en tu lavado de manos para no parar de moverte. El jabón individual en pastilla Rexona, con extracto de algodón y notas florales, se encuentra dermatológicamente testeado. Los jabones Cotton Fresh fueron creados para proponerte una experiencia que revolucionará el momento de la ducha, brindándote la frescura y suavidad que tu cuerpo pide. Es un jabón diseñado para las personas en movimiento, brindando un baño fresco después de hacer deporte, ir a trabajar, o después de un paseo. Los jabones Rexona tienen una exclusiva frescura energizante que buscan acompañarte antes o después de tu día en movimiento. Además, hay un empeño constante por conocer más sobre la transpiración y todo lo que se va aprendiendo influye en cada innovación de los productos. Viene en dos presentaciones: barra Individual de una unidad de 125 gramos o la barra Multipack de 3 unidades de 125 gramos ¡Probá también las otras variedades de jabones Rexona Fresh y su línea Antibacterial o de Glicerina! Modo de uso: Mojar el cuerpo, enjabonar y masajear normalmente. Enjuagar con abundante agua. Evite el contacto con los ojos. En caso de contacto lavar con abundante agua. Mantener fuera del alcance de los niños.
Recomendar este producto
Productos relacionados
ARS 38637.72
ARS 60570.18
ARS 60679.08
ARS 130.68
ARS 686.07

UBICACION

  • Misiones 708 Esq. La Rioja, Campana, Buenos Aires
  • 03489 44-0930
  • contacto@vileni.com.ar



Modo de Diseño: Parámetros Internos del Sitio Web

Ws_ID: 9af6db34-3ada-47ce-b029-1f91212586a2
Page_Id: f4f9b517-98df-4759-96b5-fec28d625817
WSU_Id: -1
Parámetros de la Página: ;§ITEMTITSEO§;ITEM_ID=4138;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2;
Cart Guid: debf3ead-2e03-4ebf-8947-dcabc81844bb

Estados Internos
* cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:1 * prli_id:1 * prof_id:17 * stor_id:1 * item_id:-1 * camp_id:-1 *

Comp_Id: 1
Lang_Id: 2
3.133.151.90
* WebSite Designer *



Tiempo Total de Proceso: 1 Segundos.



Ultimos SQL Ejecutados:

GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.Size_code, tc.Size_desc, '', '' FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 4138 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc

Tiempo Consumido: 00:00:00.0156195


GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, '', tc.Size_code, tc.color_code FROM vwWebSiteII_itemSizeColor tc WHERE tc.item_id = 4138 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code

Tiempo Consumido: 00:00:00


GBP_LIST: ITEM
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tc.itemID4SizeColor, CASE WHEN -1 = -1 AND '' <> '' THEN (SELECT '') else convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) END [price], c.curr_symbol, tc.Item_id FROM vwWebSiteII_itemSizeColor tc INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = tc.comp_id AND tpli.item_id = tc.itemID4SizeColor AND tpli.prli_id = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' INNER JOIN tbsysCurrency c ON c.curr_id = tpli.curr_id WHERE tc.item_id = 4138 AND tc.comp_id=1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' GROUP BY tc.itemID4SizeColor, tpli.prli_price,c.curr_symbol,tc.Item_id

Tiempo Consumido: 00:00:00.0156259



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, CASE WHEN ti.item_website_desc<>'' THEN ti.item_website_desc ELSE ti.item_desc END [item_desc], dbo.fnStrAllTrim(ti.item_code) [item_code], ti.item_annotation1 FROM tbitem ti WHERE ti.item_id = 4138

Tiempo Consumido: 00:00:00



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT cust_name FROM tbCustomer WHERE cust_id = -1

Tiempo Consumido: 00:00:00



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged FROM tbWebSiteII_Names WHERE comp_id=1 AND ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2'

Tiempo Consumido: 00:00:00



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False'))

Tiempo Consumido: 00:00:00


GBP_LIST: SCATAUX
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.CAT_ID, CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (TC.cat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.cat_desc, 1, 50) END [cat_WebSite_desc] FROM TBCATEGORY TC INNER JOIN tbWebSiteII_CategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.prli_id = 1 WHERE TC.CAT_WEB = 'TRUE' GROUP BY TC.CAT_ID, TC.cat_WebSite_desc, TC.cat_desc, tc.cat_web_order ORDER BY tc.cat_web_order ASC, tc.cat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156201


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 52 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 50 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0312513


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 57 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156547


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 58 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 53 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0312176


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 48 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0937490


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 47 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0625017


GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.subCAT_ID, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (TC.subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (TC.subcat_desc, 1, 50) END [subcat_WebSite_desc], tc.cat_id FROM tbSubCategory tc INNER JOIN vwWebSiteII_subCategoryData tmp2 on tmp2.comp_id = tc.comp_id AND tmp2.cat_id = tc.cat_id AND tmp2.subcat_id = tc.subcat_id --and tmp2.prli_id = 1 WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 46 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_web_order ASC, tc.subcat_WebSite_desc ASC

Tiempo Consumido: 00:00:00.0156561



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; 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], 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 = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = 4138

Tiempo Consumido: 00:00:00



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN COUNT(tc.item_id) » 0 THEN 'block' ELSE 'none' END [cantidad] 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 = 4138 and ti.comp_id=1 GROUP BY tc.item_id

Tiempo Consumido: 00:00:00



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN COUNT(tpdf.item_id) » 0 THEN 'block' ELSE 'none' END [mostrar], CASE WHEN COUNT(tpdf.item_id) » 0 THEN 'none' ELSE 'block' END [no_mostrar] FROM tbItemPDF tpdf WHERE tpdf.item_id = 4138 and tpdf.comp_id=1

Tiempo Consumido: 00:00:00


GBP_LIST: GALERIADETALLE
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; 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 = 4138

Tiempo Consumido: 00:00:00.0156244


GBP_LIST: LISTADODOCUMENTOS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT tpdf.itpdf_id , ISNULL(tpdf.itpdf_desc,'') FROM tbItemPDF tpdf WHERE tpdf.item_id = 4138 AND tpdf.comp_id = 1 ORDER BY tpdf.itpdf_order

Tiempo Consumido: 00:00:00.0156254



GBP_REPLACE:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT ti.item_id, ti.subcat_id FROM tbitem ti WHERE ti.item_id = 4138

Tiempo Consumido: 00:00:00


GBP_LIST: BODY_LIQ
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; 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 -1 = -1 AND '' <> '' THEN (SELECT '') 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 '«a href=http://gbp47.globalbluepoint.com/vileni/COMPARA/X/GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], convert(nvarchar(20),convert(decimal(16,2), isnull(tpli.strikeThroughPriceNOTaxes,'0'))), CASE WHEN convert(decimal(16,2), isnull(tpli.strikeThroughPriceNOTaxes,'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 = 1 AND tpli.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' 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 = '9af6db34-3ada-47ce-b029-1f91212586a2' LEFT JOIN tbWebSiteII_TMPItem4Compare i4c On i4c.item_id = ti.item_id and i4c.ws_guid = 'debf3ead-2e03-4ebf-8947-dcabc81844bb' 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 <> '4138' and ti.subcat_id = '3923'

Tiempo Consumido: 00:00:00.0781250