Distribuidora Mayorista con venta directa
ARS 732.19

Jabon en pan multiaccion

Cod: 7791290011755
ARS 755.07
ARS 767.24
ARS 806.06
ARS 817.19
ARS 859.89
ARS 920.69
ARS 969.21
ARS 990.79
ARS 994.33
ARS 1053.57
ARS 1069.64
ARS 1364.02
ARS 1434.04

QUITAM. TRENET GATILLO 500ML

Cod: 7793253001179
ARS 1483.69
ARS 1534.93
ARS 1545.18
ARS 1573.00
ARS 1601.01
ARS 1645.60
ARS 1648.60
ARS 1787.01
ARS 1891.61

Jabon en pan multiaccion

Cod: 69637216
ARS 1984.40

JAB. PVO SKIP BAJA ESPUMA 600GR

Cod: 7791290789814
ARS 1989.19

VAIS APRESTO DP 900ML

Cod: 1010157
ARS 2350.08
ARS 2481.22
ARS 2519.54
ARS 2519.82
ARS 2519.82
  • Primero
  • Anterior
  • 1
  • 2
  • Próximo
  • Último
  •     Total: 49 | Página actual: 1

    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: f9e879d8-ea32-4698-85a0-db132acec1c1
    WSU_Id: -1
    Parámetros de la Página: ;CAT_ID=47;SCAT_ID=3861;BRAND_ID=-1;GBPWSTID=9af6db34-3ada-47ce-b029-1f91212586a2;
    Cart Guid: 9f7789b5-1d63-46e9-b91b-4f449c4cc5a4

    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.237.65.102
    * WebSite Designer *



    Tiempo Total de Proceso: 1 Segundos.



    Ultimos SQL Ejecutados:


    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CASE WHEN cat_WebSite_NOTE1 <> '' THEN cat_WebSite_NOTE1 ELSE 'pixel.png' END [cat_WebSite_NOTE1] , CASE WHEN cat_WebSite_desc <> '' THEN SUBSTRING (cat_WebSite_desc, 1, 100) ELSE SUBSTRING (cat_desc, 1, 100) END [cat_WebSite_desc] FROM tbCategory WHERE cat_id = '47'

    Tiempo Consumido: 00:00:00



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT SUBSTRING (subcataux_desc, 1, 100) [subcataux_desc] FROM TBSUBCATEGORYAUX WHERE subcataux_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 subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 100) ELSE SUBSTRING (subcat_desc, 1, 100) END [subcat_WebSite_desc] FROM tbSubCategory WHERE subcat_id = '3861'

    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


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


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


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


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


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


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


    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 = 51 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.0312523



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('47') <> 1 OR '47' = '-1' ) BEGIN SELECT 'Todas' END ELSE BEGIN SELECT cat_desc FROM tbCategory WHERE cat_id='47' END

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTCAT
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('3861') =1) BEGIN SET @scat_id = CAST('3861' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('47') =1) BEGIN SET @cat_id = CAST('47' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbCategory.cat_desc AS s, tbCategory.cat_id AS cat_id, COUNT(tbItem.item_id) AS Cantidad, @scat_id AS subCategoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbCategory ON tbItem.comp_id = tbCategory.comp_id AND tbItem.cat_id = tbCategory.cat_id WHERE 1=1 --AND tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.prli_id = 1 AND tbItem.item_web = 1 AND tbWebSiteII_ItemsData.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbCategory.cat_desc, tbCategory.cat_id, tbCategory.cat_web_order

    Tiempo Consumido: 00:00:00.0781322



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('3861') <> 1 OR '3861' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT subcat_desc FROM tbSubCategory WHERE subcat_id= '3861' END

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTSCAT
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('3861') =1) BEGIN SET @scat_id = CAST('3861' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('47') =1) BEGIN SET @cat_id = CAST('47' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbSubCategory.subcat_desc AS s, tbSubCategory.subcat_id AS subcat_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbSubCategory ON tbItem.comp_id = tbSubCategory.comp_id AND tbItem.comp_id = tbSubCategory.comp_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.subcat_id = tbSubCategory.subcat_id AND tbItem.subcat_id = tbSubCategory.subcat_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' AND tbWebSiteII_ItemsData.prli_id = 1 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbSubCategory.subcat_desc, tbSubCategory.subcat_id, tbSubCategory.subcat_web_order

    Tiempo Consumido: 00:00:00.0625053



    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('-1') <> 1 OR '-1' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT brand_desc FROM tbBrand WHERE brand_id= '-1' END

    Tiempo Consumido: 00:00:00.0156298


    GBP_LIST: LISTSMARCA
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('3861') =1) BEGIN SET @scat_id = CAST('3861' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('47') =1) BEGIN SET @cat_id = CAST('47' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbBrand.brand_desc, tbBrand.brand_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id as Categoria, @scat_id AS Subcategoria, @sca_id AS SubcategoriaAux, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbBrand ON tbItem.comp_id = tbBrand.comp_id AND tbItem.brand_id = tbBrand.brand_id INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation » 0 AND tbWebSiteII_ItemsData.ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' AND tbWebSiteII_ItemsData.prli_id = 1 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC

    Tiempo Consumido: 00:00:00.0625062


    GBP_LIST: SPOTS1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT imageName, CASE WHEN URL <> '' THEN URL ELSE '' END [URL], openMode FROM vwWebSiteII_Spots WHERE ws_id = '9af6db34-3ada-47ce-b029-1f91212586a2' and Type = 8

    Tiempo Consumido: 00:00:00


    GBP_LIST: LISTA_ARTICULOS
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @order as int DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAS VARIABLES DE LA URL SET @busqueda = '' SET @busqueda = replace(@busqueda, ' ','%') -- Agrega % a los espacios intermedios. IF (ISNUMERIC ('1') =1) BEGIN SET @order = CAST('1' AS INT) END ELSE BEGIN SET @order = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @brand_id = CAST('-1' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('3861') =1) BEGIN SET @scat_id = CAST('3861' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @sca_id = CAST('' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('47') =1) BEGIN SET @cat_id = CAST('47' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT ti.item_made, tpli.semaphoreValue, ti.Item_id, CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (ti.item_website_desc, 1, 100) ELSE SUBSTRING (ti.item_desc, 1, 100) 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), ti.item_newness, ti.item_liquidation, isnull(item_WebSite_vendorPage,'VACIO'), convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid], CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked], 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], CASE WHEN tcf.comp_id is null THEN 'false' else 'true' END [grisar], 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 tbWebSiteII_ItemsData tpli INNER JOIN tbitem ti 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 LEFT JOIN tbWebSiteII_ItemRates itr ON itr.comp_id = ti.comp_id AND itr.item_id = ti.item_id LEFT JOIN tbWebSiteII_TMPItem4Compare i4c ON i4c.item_id = ti.item_id AND i4c.ws_guid = '9f7789b5-1d63-46e9-b91b-4f449c4cc5a4' 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 vwWebSiteII_itemSizeColor vtc ON vtc.itemid4sizeColor = ti.item_id and vtc.comp_id= ti.comp_id LEFT JOIN vwWebSiteII_itemSizeColor_getOnlyFather tcf ON tcf.item_id = tpli.item_id and tcf.comp_id= tpli.comp_id 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 tpli.itst_LastAvailableInRelalculation » 0 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND ti.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND ti.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND ti.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND ti.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((ti.item_desc like '%' + @busqueda + '%') OR (ti.item_WebSite_desc like '%' + @busqueda + '%') OR (ti.item_annotation1 like '%' + @busqueda + '%') OR (ti.item_annotation2 like '%' + @busqueda + '%') OR (ti.item_descHTML like '%' + @busqueda + '%') OR (ti.item_vendorCode like '%' + @busqueda + '%') OR (ti.item_Code like '%' + @busqueda + '%')))) AND vtc.comp_id is null GROUP BY ti.item_made,tpli.semaphoreValue, ti.item_id,item_WebSite_desc,item_desc, item_code,item_desc,item_vendorCode,ti.brand_id,tbr.brand_desc,item_annotation1,item_annotation2, item_newness,item_liquidation,item_WebSite_vendorPage,prli_price,curr_symbol,tpli.itst_cant,ti.comp_id,i4c.item_id,ttn.tax_percentage,tcf.comp_id,tpli.strikeThroughPrice ORDER BY CASE WHEN @order=1 THEN tpli.prli_price END ASC, CASE WHEN @order=2 THEN tpli.prli_price END DESC, CASE WHEN @order=3 THEN ti.item_WebSite_desc END ASC, CASE WHEN @order=4 THEN ti.item_WebSite_desc END DESC, CASE WHEN @order=5 THEN tpli.semaphoreValue END DESC, tpli.itst_cant DESC

    Tiempo Consumido: 00:00:00.1874899