Total: 69 | Página actual: 3
|
Modo de Diseño: Parámetros Internos del Sitio Web |
| Ws_ID: ad2cd11b-a122-4b45-b062-9ab879d93aa5 |
| Page_Id: 8f91d7b4-0c3d-41ad-bcbd-4ba36ebe268e |
| WSU_Id: -1 |
| Parámetros de la Página: ;SCAT_ID=4494;m=0;BUS=;A_PAGENUMBER=3;GBPWSTID=ad2cd11b-a122-4b45-b062-9ab879d93aa5; |
| Cart Guid: 5fb41309-4cdb-41cb-8283-dbcc90f6a0b9 |
|
Estados Internos * cust_id:-1 * st_id:1 * dl_id:1 * cc_id:-1 * ccp_id:-1 * Cuotas:-1 * disc_id:1 * bra_id:54 * prli_id:1 * prof_id:1 * stor_id:32 * item_id:-1 * camp_id:-1 * |
| Comp_Id: 1 |
| Lang_Id: 2 |
| 18.222.110.31 |
| * 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 catg_desc FROM tbCategoryGroup WHERE catg_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 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 = '' 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 = '4494' 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' Tiempo Consumido: 00:00:00 GBP_LIST: SCATAUX SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CATG_ID, catg_desc FROM TBCATEGORYGROUP WHERE comp_id=1 AND catg_webNOTE1 <> 'N' ORDER BY CAST(catg_webNOTE1 AS INT) asc Tiempo Consumido: 00:00:00.0156249 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('') <> 1 OR '' = '-1' ) BEGIN SELECT 'Todas' END ELSE BEGIN SELECT cat_desc FROM tbCategory WHERE cat_id='' 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 @catg_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 = '0' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('4494') =1) BEGIN SET @scat_id = CAST('4494' 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 ('') =1) BEGIN SET @cat_id = CAST('' AS INT) END ELSE BEGIN SET @cat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @catg_ID = CAST('' AS INT) END ELSE BEGIN SET @catg_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, '0', @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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@catg_ID, -1)=-1 AND 1=1 )OR(ISNULL(@catg_ID, -1)<>-1 AND tbWebSiteII_ItemsData.catg_id=@catg_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 (0) )) 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.1093754 GBP_REPLACE: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; IF (ISNUMERIC ('4494') <> 1 OR '4494' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT subcat_desc FROM tbSubCategory WHERE subcat_id= '4494' 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 @catg_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 = '0' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('4494') =1) BEGIN SET @scat_id = CAST('4494' 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 ('') =1) BEGIN SET @cat_id = CAST('' AS INT) END ELSE BEGIN SET @cat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @catg_ID = CAST('' AS INT) END ELSE BEGIN SET @catg_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, '0', @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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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(@catg_ID, -1)=-1 AND 1=1 )OR(ISNULL(@catg_ID, -1)<>-1 AND tbWebSiteII_ItemsData.catg_id=@catg_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 (0) )) 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.0781578 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 @catg_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) SET @busqueda = replace('', 'ñ','ñ') SET @busqueda = replace(@busqueda, ' ','%') SET @brand_id = '0' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('4494') =1) BEGIN SET @scat_id = CAST('4494' 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 ('') =1) BEGIN SET @cat_id = CAST('' AS INT) END ELSE BEGIN SET @cat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @catg_ID = CAST('' AS INT) END ELSE BEGIN SET @catg_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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' WHERE ti.item_web = 'true' AND tbWebSiteII_ItemsData.ws_id = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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(@catg_ID, -1)=-1 AND 1=1 )OR(ISNULL(@catg_ID, -1)<>-1 AND tbWebSiteII_ItemsData.catg_id=@catg_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.0937364 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 @catg_ID AS INT DECLARE @busqueda varchar(100) DECLARE @brand_id varchar SET @busqueda = replace('', 'ñ','ñ') SET @busqueda = replace(@busqueda, ' ','%') SET @brand_id = '0' IF (@brand_id ='0') BEGIN SET @brand_id = '' END IF (ISNUMERIC ('4494') =1) BEGIN SET @scat_id = CAST('4494' 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 ('') =1) BEGIN SET @cat_id = CAST('' AS INT) END ELSE BEGIN SET @cat_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @catg_ID = CAST('' AS INT) END ELSE BEGIN SET @catg_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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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(@catg_ID, -1)=-1 AND 1=1 )OR(ISNULL(@catg_ID, -1)<>-1 AND tpli.catg_id=@catg_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 (0) )) 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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 = 'ad2cd11b-a122-4b45-b062-9ab879d93aa5' 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(@catg_ID, -1)=-1 AND 1=1 )OR(ISNULL(@catg_ID, -1)<>-1 AND tpli.catg_id=@catg_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 (0) )) 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.1812410 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 @CATG_ID AS INT DECLARE @BUSQUEDA VARCHAR(100) SET @BUSQUEDA = REPLACE('', 'ñ','Ñ') SET @BUSQUEDA = REPLACE(@BUSQUEDA, ' ','%') SET @BRAND_ID = '0' IF (@BRAND_ID ='0') BEGIN SET @BRAND_ID = '' END IF (ISNUMERIC ('3') =1) BEGIN SET @ORDER = CAST('3' AS INT) END ELSE BEGIN SET @ORDER = -1 END IF (ISNUMERIC ('4494') =1) BEGIN SET @SCAT_ID = CAST('4494' 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 ('') = 1) BEGIN SET @CAT_ID = CAST('' AS INT) END ELSE BEGIN SET @CAT_ID = -1 END IF (ISNUMERIC ('') = 1) BEGIN SET @CATG_ID = CAST('' AS INT) END ELSE BEGIN SET @CATG_ID = -1 END SELECT TPLI.ITEM__MADE, TPLI.SEMAPHOREVALUE, TPLI.ITEM_ID, SUBSTRING (TPLI.ITEM__WEBSITE_DESC, 1, 100), SUBSTRING ( TPLI.ITEM__ANNOTATION1, 1, 20), DBO.FNSTRALLTRIM(TPLI.ITEM__CODE) [ITEM_CODE], TPLI.ITEM__VENDORCODE, TPLI._BRAND_ID, TPLI.ITEM__ANNOTATION2, SUBSTRING ( TPLI.ITEM__ANNOTATION2, 1, 90), TBN.WSSN_ISNOVELTY, TBN.WSSN_IS4SALE, --FORMAT(TPLI.PRLI_PRICE, 'N', 'DE-DE') AS 'NUMERIC FORMAT', REPLACE(FORMAT(CONVERT(DECIMAL(16,0), TPLI.PRLI_PRICE), 'N', 'DE-DE'),',00',''), TPLI.CURRENCY_SYMBOL, '', CASE WHEN I4C.ITEM_ID = TPLI.ITEM_ID THEN 1 ELSE 0 END [CHECKID], CASE WHEN I4C.ITEM_ID = TPLI.ITEM_ID THEN 'CHECKED' ELSE '' END [CHECKED], CASE WHEN I4C.ITEM_ID = TPLI.ITEM_ID THEN '«A HREF=HTTP://GBP47S.GLOBALBLUEPOINT.COM/COLUCCI/COMPARA/X/GBPWSTID=AD2CD11B-A122-4B45-B062-9AB879D93AA5/GBPWST.ASPX»VER COMPARACION«/A»' ELSE 'COMPARAR' END [COMPATEXT], CONVERT (DECIMAL(16,2), TTN.TAX_PERCENTAGE) [IVA], SUBSTRING (DBO.FNSTRREMOVESPECIALCHARACTERS(TPLI.ITEM__WEBSITE_DESC), 1, 100), REPLACE(DBO.FNSTRALLTRIM(TPLI.ITEM__CODE),'/','--') , REPLACE (FORMAT(CONVERT(DECIMAL(16,0), ISNULL(TPLI.STRIKETHROUGHPRICE,'0')), 'N', 'DE-DE'),',00',''), CASE WHEN CONVERT(DECIMAL(16,2), ISNULL(TPLI.STRIKETHROUGHPRICE,'0')) » CONVERT(DECIMAL(16,2), TPLI.PRLI_PRICE) THEN 'TRUE' ELSE 'FALSE' END [PRECIOTACHADOMOSTRAR], CASE WHEN CONVERT(DECIMAL(16,0), ISNULL(TPLI.STRIKETHROUGHPRICE,'0')) » 0 THEN CONVERT(DECIMAL(16,0),(-1 * (((TPLI.PRLI_PRICE * 100)/TPLI.STRIKETHROUGHPRICE) -100))) ELSE 0 END FROM TBWEBSITEII_ITEMSDATA TPLI LEFT JOIN TBWEBSITEII_ITEMRATES ITR ON ITR.COMP_ID = TPLI.COMP_ID AND ITR.ITEM_ID = TPLI.ITEM_ID LEFT JOIN TBWEBSITEII_TMPITEM4COMPARE I4C ON I4C.ITEM_ID = TPLI.ITEM_ID AND I4C.WS_GUID = '5FB41309-4CDB-41CB-8283-DB6C90F6A0B9' LEFT JOIN TBWEBSITEII_ITEMS_NOVELTYAND4SALE TBN ON TBN.COMP_ID = TPLI.COMP_ID AND TPLI.ITEM_ID = TBN.ITEM_ID AND TBN.WS_ID = 'AD2CD11B-A122-4B45-B062-9AB879D93AA5' LEFT JOIN VWWEBSITEII_ITEMSIZECOLOR VTC ON VTC.ITEMID4SIZECOLOR = TPLI.ITEM_ID AND VTC.COMP_ID= TPLI.COMP_ID LEFT JOIN TBITEMTAXES TIT ON TIT.ITEM_ID=TPLI.ITEM_ID AND TIT.COMP_ID=TPLI.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 TPLI.PRLI_ID = 1 AND TPLI.WS_ID = 'AD2CD11B-A122-4B45-B062-9AB879D93AA5' AND ((ISNULL(@CAT_ID, -1)=-1 AND 1=1 )OR(ISNULL(@CAT_ID, -1)<>-1 AND TPLI.CAT_ID=@CAT_ID )) AND ((ISNULL(@CATG_ID, -1)=-1 AND 1=1 )OR(ISNULL(@CATG_ID, -1)<>-1 AND TPLI.CATG_ID=@CATG_ID )) AND ((ISNULL(@SCAT_ID, -1)=-1 AND 1=1 )OR(ISNULL(@SCAT_ID, -1)<>-1 AND TPLI.SUBCAT_ID=@SCAT_ID )) AND ((ISNULL(@SCA_ID, -1)=-1 AND 1=1 )OR(ISNULL(@SCA_ID, -1)<>-1 AND TPLI.SUBCATAUX_ID=@SCA_ID )) AND ((ISNULL(@BRAND_ID, '')='') OR (ISNULL(@BRAND_ID, '')<>'' AND TPLI._BRAND_ID IN (0) )) AND ((ISNULL(@BUSQUEDA, '')='' AND 1=1 ) OR (ISNULL(@BUSQUEDA, '') <> '' AND ((TPLI.ITEM__WEBSITE_DESC LIKE '%' + @BUSQUEDA + '%') OR (TPLI.ITEM__ANNOTATION1 LIKE '%' + @BUSQUEDA + '%') OR (TPLI.ITEM__ANNOTATION2 LIKE '%' + @BUSQUEDA + '%') OR (TPLI.ITEM__DESCHTML LIKE '%' + @BUSQUEDA + '%')))) AND VTC.COMP_ID IS NULL AND TPLI.WS_ID = 'AD2CD11B-A122-4B45-B062-9AB879D93AA5' 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 TPLI.ITEM__WEBSITE_DESC END ASC, CASE WHEN @ORDER=4 THEN TPLI.ITEM__WEBSITE_DESC END DESC, CASE WHEN @ORDER=5 THEN TPLI.SEMAPHOREVALUE END DESC, TPLI.ITST_CANT DESC Tiempo Consumido: 00:00:00.1739482 |
|
|