Distribuidora Mayorista con venta directa
DESODORANTE

REXONA MEN INVISIBLE X90GRS / 150ML AERO

CODIGO: 7791293049465

ARS 5503.36

La NUEVA FÓRMULA del desodorante antitranspirante Rexona Hombre Fútbol Fanatics responde directamente al movimiento, manteniéndote fresco, seco y protegido como nunca antes. La vida se trata de experimentar, probar, moverse, fallar y superarse. El propósito de Rexona es inspirar la confianza en cada uno para romper con las auto-limitaciones que nos restringen de movernos más. Y es por esto que Rexona busca constantemente innovar en la Categoría desarrollando nuevas propuestas disruptivas para satisfacer las necesidades de todos, independientemente de su nivel de transpiración. Y una vez más Rexona se supera relanzando su línea de Desodorantes antitranspirantes con una nueva formulación que combina un innovador activo antitranspirante con la exclusiva tecnología de fragancia encapsula. ¿El resultado? 72 horas de protección activada por el movimiento y mucha más confianza para encarar cualquier desafío. Con 16 patentes exclusivas y más de 300 estudios científicos, está comprobado que esta nueva tecnología de Rexona entrega un nivel de protección contra la transpiración y mal olor como ninguna otra propuesta antitranspirante del mercado. Su tecnología única en partículas más chicas y estables forman una barrera protectora más resistente y perdurable en el tiempo, manteniéndote seco, fresco y protegido en cada movimiento. No importa si estás escalando una montaña, corriendo para tomar el colectivo, dando una presentación en el trabajo o yendo a una cita, Rexona te garantiza la mejor protección contra la transpiración y más confianza para encarar cualquier desafío en cualquier momento del día. Rexona, no te abandona.
Recomendar este producto
Productos relacionados

DOVE MEN EXTRA FRESH x 150ML

Cod: 7791293048017
ARS 5388.23

DOVE MEN INVISIBLE DRY x 150ML

Cod: 7791293048031
ARS 5388.23

DOVE MEN PROT TOTAL x 150ML

Cod: 7791293048000
ARS 5375.56

DOVE VEGAN POMELO AER 150 ML

Cod: 7791293048482
ARS 6719.47

DOVE VEGAN PEPINO AER 150 ML

Cod: 7791293048475
ARS 6719.47

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=3229;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2;
Cart Guid: 0597db65-d1b5-4012-bb7c-d45711966714

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
216.73.216.23
* 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 = 3229 and tc.comp_id=1 GROUP BY tc.Size_code, tc.Size_desc

Tiempo Consumido: 00:00:00.0049758


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 = 3229 and tc.comp_id=1 GROUP BY tc.itemID4SizeColor, tc.color_code, tc.Size_code

Tiempo Consumido: 00:00:00.0059740


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 = 3229 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.0055970



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 = 3229

Tiempo Consumido: 00:00:00.0015321



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.0010006



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.0015039



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.0015019


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.0055067


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.0111223


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.0470443


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.0090089


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 = 59 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.0185186


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.0100398


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.0505162


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.1884814


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.1122092



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 = 3229

Tiempo Consumido: 00:00:00.0050045



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 = 3229 and ti.comp_id=1 GROUP BY tc.item_id

Tiempo Consumido: 00:00:00.0014702



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 = 3229 and tpdf.comp_id=1

Tiempo Consumido: 00:00:00.0010001


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 = 3229

Tiempo Consumido: 00:00:00.0050050


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 = 3229 AND tpdf.comp_id = 1 ORDER BY tpdf.itpdf_order

Tiempo Consumido: 00:00:00.0045091



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 = 3229

Tiempo Consumido: 00:00:00.0010015


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 = '0597db65-d1b5-4012-bb7c-d45711966714' 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 <> '3229' and ti.subcat_id = '3922'

Tiempo Consumido: 00:00:00.0795763