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

Ws_ID: 2565b354-0d67-4df4-9ca2-153c2eb68ade

Page_Id: 8f91d7b4-0c3d-41ad-bcbd-4ba36ebe268e

WSU_Id: -1

Parámetros de la Página: ;SCA_ID=-1;CAT_ID=68;SCAT_ID=-1;m=81;GBPWSTID=2565b354-0d67-4df4-9ca2-153c2eb68ade;

Cart Guid: 71ad4969-4921-4efb-9ebd-06e846d7389e

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

Comp_Id: 1

Lang_Id: 2

18.224.31.14

* 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 = '68'

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 = '-1'

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 = '-1'

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 convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False'))

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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade'

Tiempo Consumido: 00:00:00

GBP_LIST: SCAT1
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.CAT_ID, TC.cat_WebSite_NOTE1, 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], CASE WHEN TC.cat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(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' AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' GROUP BY TC.CAT_ID,TC.cat_WebSite_NOTE1, 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' 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.0156309

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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' 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.0155991

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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 68 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 70 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 71 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 73 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.0155976

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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 82 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 110 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 111 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 113 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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 117 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.0156552

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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 95 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.0155990

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, CASE WHEN TC.subcat_WebSite_desc <> '' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_WebSite_desc), 1, 50) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(TC.subcat_desc), 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory tc INNER JOIN tbWebSiteII_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 AND tmp2.ws_id='2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 115 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.0156263

GBP_LIST: MARCAS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT brand_id, brand_desc FROM tbBrand WHERE brand_note2 = 'S' OR brand_note2 = 's' Order By brand_desc

Tiempo Consumido: 00:00:00.0468801

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

Tiempo Consumido: 00:00:00

GBP_LIST: LISTCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda1 varchar(100) DECLARE @busqueda varchar(100) DECLARE @brand_id varchar SET @busqueda1 = replace('', 'Ã±','ñ') SET @busqueda = replace(@busqueda1, ' ','%') SET @brand_id = '81' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('-1') =1) BEGIN SET @scat_id = CAST('-1' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @sca_id = CAST('-1' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('68') =1) BEGIN SET @cat_id = CAST('68' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbCategory.cat_desc AS s, dbo.fnSTRRemoveSpecialCharacters(tbCategory.cat_desc), tbCategory.cat_id AS cat_id, COUNT(ti.item_id) AS Cantidad, @scat_id AS subCategoria, @sca_id AS subCategoriaAux, '81', @busqueda1 as BUSQUEDA FROM tbItem ti INNER JOIN tbWebSiteII_ItemsData ON ti.comp_id = tbWebSiteII_ItemsData.comp_id AND ti.item_id = tbWebSiteII_ItemsData.item_id AND tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' INNER JOIN tbCategory ON ti.comp_id = tbCategory.comp_id AND ti.cat_id = tbCategory.cat_id WHERE tbWebSiteII_ItemsData.prli_id = 1 AND ti.item_web = 'true' AND tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' 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 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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (81) )) 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 + '%')))) GROUP BY tbCategory.cat_desc, tbCategory.cat_id, tbCategory.cat_web_order

Tiempo Consumido: 00:00:00.0468590

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 subcat_desc FROM tbSubCategory WHERE subcat_id= '-1' END

Tiempo Consumido: 00:00:00

GBP_LIST: LISTSCAT
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda1 varchar(100) DECLARE @busqueda varchar(100) DECLARE @brand_id varchar SET @busqueda1 = replace('', 'Ã±','ñ') SET @busqueda = replace(@busqueda1, ' ','%') SET @brand_id = '81' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('-1') =1) BEGIN SET @scat_id = CAST('-1' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @sca_id = CAST('-1' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('68') =1) BEGIN SET @cat_id = CAST('68' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tbSubCategory.subcat_desc AS s, dbo.fnSTRRemoveSpecialCharacters(tbSubCategory.subcat_desc), tbSubCategory.subcat_id AS subcat_id, COUNT(ti.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, '81', @busqueda1 as BUSQUEDA FROM tbItem ti INNER JOIN tbWebSiteII_ItemsData ON ti.comp_id = tbWebSiteII_ItemsData.comp_id AND ti.item_id = tbWebSiteII_ItemsData.item_id AND tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' INNER JOIN tbSubCategory ON ti.comp_id = tbSubCategory.comp_id AND ti.cat_id = tbSubCategory.cat_id AND ti.subcat_id = tbSubCategory.subcat_id WHERE tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' AND tbWebSiteII_ItemsData.prli_id = 1 AND ti.item_web = 'true' 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 1 <> 1 )) 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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (81) )) 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 + '%')))) GROUP BY tbSubCategory.subcat_desc, tbSubCategory.subcat_id, tbSubCategory.subcat_web_order

Tiempo Consumido: 00:00:00.0468559

GBP_LIST: COMPA
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) DECLARE @brand_id varchar SET @busqueda = replace('', 'Ã±','ñ') SET @busqueda = replace(@busqueda, ' ','%') SET @brand_id = '81' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('-1') =1) BEGIN SET @scat_id = CAST('-1' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @sca_id = CAST('-1' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('68') =1) BEGIN SET @cat_id = CAST('68' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT tic.wco_desc as orden1,'«li class="term-item"»«label onchange="filtroClick('+convert(varchar,tic.wco_id)+','''+ticr.wco_Text1,''')"»«input type="checkbox" id="',tic.wco_id as orden2,ticr.wco_Text1,'" name="'+convert(varchar,tic.wco_id)+'" value="'as WCOID,ticr.wco_Text1+'"» ',ticr.wco_Text1,' «span»('+convert(varchar,count(ti.item_id))+')«/span»'as cantidad,'«/label»«/li»' FROM tbitem ti INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id 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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade' INNER JOIN tbCategory cat ON ti.cat_id = cat.cat_id INNER JOIN tbItemComparativesRelations ticr ON ticr.item_id = ti.item_id INNER JOIN tbItemComparatives tic ON tic.wco_id = ticr.wco_id WHERE tpli.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' AND tpli.prli_id = 1 AND ti.item_web = 'true' AND tic.wco_isAvailable4Filters = 1 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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (81) )) 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 + '%')))) GROUP BY tic.wco_desc, tic.wco_id, ticr.wco_Text1 UNION SELECT distinct tic.wco_desc,'«/ul»«li class="menuLatTit" id="','',0,'','"»','',tic.wco_desc,'','«/li»«ul class="menuUl term-list"»' FROM tbitem ti INNER JOIN tbBrand tbr ON ti.brand_id = tbr.brand_id 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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade' INNER JOIN tbCategory cat ON ti.cat_id = cat.cat_id INNER JOIN tbItemComparativesRelations ticr ON ticr.item_id = ti.item_id INNER JOIN tbItemComparatives tic ON tic.wco_id = ticr.wco_id WHERE tic.wco_isAvailable4Filters = 1 AND tpli.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' AND tpli.prli_id = 1 AND ti.item_web = 'true' 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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (81) )) 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 + '%')))) GROUP BY tic.wco_desc, tic.wco_id, ticr.wco_Text1 ORDER BY orden1, orden2

Tiempo Consumido: 00:00:00.1250139

GBP_LIST: LISTSMARCA
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @brand_id AS varchar DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) SET @busqueda = replace('', 'Ã±','ñ') SET @busqueda = replace(@busqueda, ' ','%') SET @brand_id = '81' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('-1') =1) BEGIN SET @scat_id = CAST('-1' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @sca_id = CAST('-1' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('68') =1) BEGIN SET @cat_id = CAST('68' AS INT) END ELSE BEGIN SET @cat_id = -1 END SELECT '','«li class="term-item"»«label onchange="marcaClick(' + convert(varchar,tbBrand.brand_id), ')"» «input type="checkbox" id="marca', tbBrand.brand_id, '', '" name="'+convert(varchar,tbBrand.brand_id)+'" value="' as BRAND_ID, dbo.fnSTRRemoveSpecialCharacters(tbBrand.brand_desc)+'"» ', tbBrand.brand_desc, ' «span»('+convert(varchar,COUNT(ti.item_id))+')«/span»'as cantidad, '«/label»«/li»' FROM tbItem ti INNER JOIN tbBrand ON ti.comp_id = tbBrand.comp_id AND ti.brand_id = tbBrand.brand_id INNER JOIN tbWebSiteII_ItemsData ON ti.comp_id = tbWebSiteII_ItemsData.comp_id AND ti.item_id = tbWebSiteII_ItemsData.item_id AND tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' WHERE ti.item_web = 'true' AND tbWebSiteII_ItemsData.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' AND tbWebSiteII_ItemsData.prli_id = 1 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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (@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 + '%')))) GROUP BY tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC

Tiempo Consumido: 00:00:00.0468787

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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade' and Type = 8 ORDER BY [Order]

Tiempo Consumido: 00:00:00.0156531

GBP_LIST: A
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @order AS INT DECLARE @brand_id varchar DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) SET @busqueda = replace('', 'Ã±','ñ') SET @busqueda = replace(@busqueda, ' ','%') SET @brand_id = '81' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('18') =1) BEGIN SET @order = CAST('18' AS INT) END ELSE BEGIN SET @order = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @scat_id = CAST('-1' AS INT) END ELSE BEGIN SET @scat_id = -1 END IF (ISNUMERIC ('-1') =1) BEGIN SET @sca_id = CAST('-1' AS INT) END ELSE BEGIN SET @sca_id = -1 END IF (ISNUMERIC ('68') =1) BEGIN SET @cat_id = CAST('68' 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), tbn.wssn_isNovelty, tbn.wssn_is4Sale, isnull(item_WebSite_vendorPage,'VACIO'), --convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) [price], format(tpli.prli_price, 'N', 'de-de') AS 'Numeric Format', 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://gbp61.globalbluepoint.com/Tecnopolis/COMPARA/X/GBPWSTID=2565b354-0d67-4df4-9ca2-153c2eb68ade/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [compatext], convert (decimal(16,2), ttn.tax_percentage) [IVA], CASE WHEN ti.item_website_desc<>'' THEN SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_website_desc), 1, 100) ELSE SUBSTRING (dbo.fnSTRRemoveSpecialCharacters(ti.item_desc), 1, 100) END [item_desc] , REPLACE(ti.item_code,'/','--') , CASE WHEN ti.item_NoStockCheck='true' AND ti.item_web = 'true' AND (ti.item_isForAssociation='false' OR ti.item_annotation1 like '%@@GRISAR%' ) THEN 'True' ELSE 'False' END [grisar_boton], REPLACE(format(CAST(isnull(tpli.strikeThroughPrice,'0') AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', 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 = '2565b354-0d67-4df4-9ca2-153c2eb68ade' 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 = '71ad4969-4921-4efb-9ebd-06e846d7389e' LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '2565b354-0d67-4df4-9ca2-153c2eb68ade' LEFT JOIN vwWebSiteII_itemSizeColor vtc ON vtc.itemid4sizeColor = ti.item_id and vtc.comp_id= ti.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 ((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, '')='') OR (ISNULL(@brand_id, '')<>'' AND ti.brand_id IN (81) )) 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,item_annotation1,item_annotation2, wssn_isNovelty,wssn_is4Sale,item_WebSite_vendorPage,prli_price, curr_symbol,tpli.itst_cant,ti.comp_id,i4c.item_id,ttn.tax_percentage, ti.item_isForAssociation,ti.item_web,ti.item_NoStockCheck */ 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.1093847

FILTRAR

Categoría

SubCategoría

Marca

MOTHERBOARD ASROCK AM4 B450M-HDV 4.0

MB ASROCK B760M PG LIGHTNING S1700

MB ASROCK B550 AM4 STEEL LEGEND