Eclypse, desafiando la tecnología | Insumos de Informática
...

FILTRAR

Categoría

SubCategoría

Marca

[Más info]
Procesador Amd Atlhon 3000G 3.5Ghz

Procesador Amd Atlhon 3000G 3.5Ghz

$ 69.662

6 cuotas sin interés de
$ 13.933

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 3 3200G AM4

Procesador Amd Ryzen 3 3200G AM4

$ 84.659

6 cuotas sin interés de
$ 16.932

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 4500 4.1 Ghz S/Video

Procesador Amd Ryzen 5 4500 4.1 Ghz S/Video

$ 101.591

6 cuotas sin interés de
$ 20.318

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 5500 3.6 Ghz

Procesador Amd Ryzen 5 5500 3.6 Ghz

$ 110.867

6 cuotas sin interés de
$ 22.174

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i3 12100F 4.3Ghz

Procesador Intel Core i3 12100F 4.3Ghz

$ 114.653

6 cuotas sin interés de
$ 22.931

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i3 10100 4.3Ghz S1200

Procesador Intel Core i3 10100 4.3Ghz S1200

$ 133.834

6 cuotas sin interés de
$ 26.767

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5 10400F 4.3 Ghz

Procesador Intel Core i5 10400F 4.3 Ghz

$ 158.361

6 cuotas sin interés de
$ 31.672

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5 12400F 4.4Ghz S1700

Procesador Intel Core i5 12400F 4.4Ghz S1700

$ 179.308

6 cuotas sin interés de
$ 35.862

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 5600GT 4.6Ghz AM4

Procesador Amd Ryzen 5 5600GT 4.6Ghz AM4

$ 181.413

6 cuotas sin interés de
$ 36.283

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 7 5700G

Procesador Amd Ryzen 7 5700G

$ 200.280

6 cuotas sin interés de
$ 40.056

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 8400F 4.7Ghz AM5

Procesador Amd Ryzen 5 8400F 4.7Ghz AM5

$ 200.280

6 cuotas sin interés de
$ 40.056

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5 12400 4.4Ghz S1700

Procesador Intel Core i5 12400 4.4Ghz S1700

$ 203.182

6 cuotas sin interés de
$ 40.637

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 8500G 5Ghz

Procesador Amd Ryzen 5 8500G 5Ghz

$ 207.948

6 cuotas sin interés de
$ 41.590

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5 14400F 4.7 Ghz

Procesador Intel Core i5 14400F 4.7 Ghz

$ 263.363

6 cuotas sin interés de
$ 52.673

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 5 8600G 5Ghz

Procesador Amd Ryzen 5 8600G 5Ghz

$ 272.555

6 cuotas sin interés de
$ 54.511

AGREGAR AL CARRITO
[Más info]
Procesador AMD Ryzen 5 7600X 5.3Ghz AM5

Procesador AMD Ryzen 5 7600X 5.3Ghz AM5

$ 329.688

6 cuotas sin interés de
$ 65.938

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5 13600K 5.3Ghz S1700

Procesador Intel Core i5 13600K 5.3Ghz S1700

$ 348.313

6 cuotas sin interés de
$ 69.663

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 7 8700F 5Ghz

Procesador Amd Ryzen 7 8700F 5Ghz

$ 348.652

6 cuotas sin interés de
$ 69.730

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i5-14600K LGA1700 5.4Ghz

Procesador Intel Core i5-14600K LGA1700 5.4Ghz

$ 357.989

6 cuotas sin interés de
$ 71.598

AGREGAR AL CARRITO
[Más info]
Procesador Amd Ryzen 7 8700G AM5 5.1 Ghz

Procesador Amd Ryzen 7 8700G AM5 5.1 Ghz

$ 362.826

6 cuotas sin interés de
$ 72.565

AGREGAR AL CARRITO
[Más info]
Procesador AMD Ryzen 7 7700X 5.4Ghz AM5

Procesador AMD Ryzen 7 7700X 5.4Ghz AM5

$ 460.548

6 cuotas sin interés de
$ 92.110

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i7 13700K 5.4Ghz S1700

Procesador Intel Core i7 13700K 5.4Ghz S1700

$ 551.496

6 cuotas sin interés de
$ 110.299

AGREGAR AL CARRITO
[Más info]
Procesador intel Core Ultra 7 265K 5.50Ghz LGA1851

Procesador intel Core Ultra 7 265K 5.50Ghz LGA1851

$ 567.461

6 cuotas sin interés de
$ 113.492

AGREGAR AL CARRITO
[Más info]
Procesador Intel Core i7 14700KF 5.6 Ghz

Procesador Intel Core i7 14700KF 5.6 Ghz

$ 586.086

6 cuotas sin interés de
$ 117.217

AGREGAR AL CARRITO
  • Primero
  • Anterior
  • 1
  • 2
  • Próximo
  • Último

    •     Total: 29 | Página actual: 1




    Modo de Diseño: Parámetros Internos del Sitio Web
    Ws_ID: 0eeb8df0-4255-4fd7-93e4-dd21aa3fa774
    Page_Id: cb29689e-d25e-4526-86c2-c331f952a4ef
    WSU_Id: -1
    Parámetros de la Página: ;CAT_ID=1;SCAT_ID=-1;SCA_ID=-1;m=0;BUS=;GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774;
    Cart Guid: 15fb3e10-d1b6-4d16-b9dd-a13430d8d644

    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:1 * stor_id:1 * item_id:-1 * camp_id:-1 *

    Comp_Id: 1
    Lang_Id: 2
    18.117.157.126
    * 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, CASE WHEN catg_note2 <> '' THEN catg_note2 ELSE 'Eclypse - Insumos de Informática' END FROM tbCategoryGroup WHERE catg_id = ''

    Tiempo Consumido: 00:00:00.0009989


    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; DECLARE @cat_ID AS INT DECLARE @catg_ID AS INT IF (ISNUMERIC ('1') =1) BEGIN SET @cat_id = CAST('1' 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 CASE WHEN ISNULL(@cat_ID, -1)<>-1 THEN REPLACE(cat_desc,'"','') ELSE '' END, CASE WHEN (cat_WebSite_NOTE1 <> '' AND ISNULL(@cat_ID, -1)<>-1) THEN cat_WebSite_NOTE1 ELSE (CASE WHEN (ISNULL(@catg_ID, -1)<>-1) THEN '' ELSE 'Eclypse - Insumos de Informática' END) END FROM tbCategory WHERE ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND cat_id=@cat_id ))

    Tiempo Consumido: 00:00:00


    GBP_REPLACE:
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT CATG_ID, 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], CASE WHEN cat_imageChecksum » 0 THEN '«div style="margin-bottom:15px"»«img src="http://gbp83.globalbluepoint.com/eclypse/Temp/App_WebSite/App_PictureFiles/Categories/1.jpg" style="border-radius:10px" class="img-responsive" /»«/div»' ELSE '' END FROM tbCategory WHERE cat_id = '1'

    Tiempo Consumido: 00:00:00.0019956


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


    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 ws_newCustomerAllowed, ws_manage_showStockSemaphore , ws_manage_hidePricesIfNotLogged FROM tbWebSiteII_Names WHERE comp_id=1 AND ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774'

    Tiempo Consumido: 00:00:00.0009977


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


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

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

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='1' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0020244

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019961

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 49 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019948

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0039897

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019962

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019937

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019942

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 1 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019956

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 55 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019948

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='2' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019938

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019625

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019935

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 65 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029932

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 125 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019624

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 67 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019949

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019949

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 69 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019938

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 132 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029912

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='3' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019949

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029907

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 100 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029935

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 77 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029908

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029925

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 72 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029922

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029934

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 56 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019970

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='5' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019937

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 112 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029912

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019947

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='6' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019926

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 133 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029619

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 83 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029931

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 88 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019947

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019941

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 85 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0020281

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 89 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029920

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='9' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019899

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 74 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0069822

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='11' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019957

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 102 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0020227

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='12' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019945

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 104 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0020021

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 109 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019600

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 105 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029929

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 130 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029922

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 107 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019942

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 106 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029919

    GBP_LIST: SCAT1
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; SET LOCK_TIMEOUT 1000; SET DEADLOCK_PRIORITY LOW; SELECT TC.cat_id, TC.cat_WebSite_desc, dbo.fnSTRRemoveSpecialCharacters(TC.cat_WebSite_desc) FROM tbWebSiteII_CategoryData TC WHERE TC.catg_id='10' AND TC.prli_id = 1 GROUP BY TC.cat_id, TC.cat_WebSite_desc ORDER BY TC.cat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0039887

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 131 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029919

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 97 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019951

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029928

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 128 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029924

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 90 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029931

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0279236

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 118 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0019952

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 126 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0039885

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 99 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029927

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 119 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0039888

    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='0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE TC.subCAT_WEB = 'TRUE' and tc.cat_id = 116 GROUP BY TC.subCAT_ID,TC.subcat_WebSite_desc,TC.subcat_desc, tc.cat_id, tc.subcat_web_order ORDER BY tc.subcat_desc ASC, tc.subcat_WebSite_desc ASC

    Tiempo Consumido: 00:00:00.0029921


    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 cat_desc FROM tbCategory WHERE cat_id='1' END

    Tiempo Consumido: 00:00:00.0009971

    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 @busqueda varchar(100) DECLARE @busqueda1 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 ('-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 ('1') =1) BEGIN SET @cat_id = CAST('1' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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.0359041


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

    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 @busqueda varchar(100) DECLARE @busqueda1 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 ('-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 ('1') =1) BEGIN SET @cat_id = CAST('1' 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, '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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 (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.0229672

    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 @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 ('-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 ('1') =1) BEGIN SET @cat_id = CAST('1' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' WHERE ti.item_web = 'true' AND tbWebSiteII_ItemsData.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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.0239615

    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 = '0' 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 ('1') =1) BEGIN SET @cat_id = CAST('1' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 (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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 (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.0598131

    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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' and Type = 8 ORDER BY [Order]

    Tiempo Consumido: 00:00:00.0019947

    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 varchar(100) 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 @input varchar(200) DECLARE @m1 varchar(10), @m2 varchar(10), @m3 varchar(10), @m4 varchar(10), @m5 varchar(10), @m6 varchar(10), @m7 varchar(10), @m8 varchar(10), @m9 varchar(10), @m10 varchar(10) SET @input = '0' -- 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 (@input ='0') BEGIN SET @m1= '' SET @m2= '' SET @m3= '' SET @m4= '' SET @m5= '' SET @m6= '' SET @m7= '' SET @m8= '' SET @m9= '' SET @m10= '' END ELSE IF (@input != '') BEGIN SET @m1= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input = IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m2= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m3= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m4= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m5= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m6= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m7= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m8= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m9= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') SET @input =IIF(CHARINDEX(',',@input)=0,'',RIGHT(@input,LEN(@input)-CHARINDEX(',',@input))) SET @m10= NULLIF(LEFT(@input,ISNULL(NULLIF(CHARINDEX(',',@input)-1,-1),LEN(@input))),'') 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 ('1') =1) BEGIN SET @cat_id = CAST('1' 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 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'), REPLACE(format(CAST(tpli.prli_price AS INT), 'N', 'de-de'),',00','') AS 'Numeric Format', REPLACE(format(convert(decimal(16,0), 1.20 * tpli.prli_price/6), 'N', 'de-de'),',00',''), 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://gbp83.globalbluepoint.com/eclypse/COMPARA/X/GBPWSTID=0eeb8df0-4255-4fd7-93e4-dd21aa3fa774/gbpwst.aspx»Ver Comparacion«/a»' else 'Comparar' END [checked], convert (decimal(16,0), 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,'/','--') , 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 = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 = '15fb3e10-d1b6-4d16-b9dd-a13430d8d644' LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '0eeb8df0-4255-4fd7-93e4-dd21aa3fa774' 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 tpli.itst_LastAvailableInRelalculation » 0 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(@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(@m1, '')<>'' AND tpli._brand_id = @m1))) OR (((ISNULL(@m2, '')<>'' AND tpli._brand_id = @m2 ))) OR (((ISNULL(@m3, '')<>'' AND tpli._brand_id = @m3 ))) OR (((ISNULL(@m4, '')<>'' AND tpli._brand_id = @m4 ))) OR (((ISNULL(@m5, '')<>'' AND tpli._brand_id = @m5 ))) OR (((ISNULL(@m6, '')<>'' AND tpli._brand_id = @m6 ))) OR (((ISNULL(@m7, '')<>'' AND tpli._brand_id = @m7 ))) OR (((ISNULL(@m8, '')<>'' AND tpli._brand_id = @m8 ))) OR (((ISNULL(@m9, '')<>'' AND tpli._brand_id = @m9 ))) OR (((ISNULL(@m10, '')<>'' AND tpli._brand_id = @m10 ))) OR ((@m1='') AND (@m2='') AND (@m3='') AND (@m4='') AND (@m5='') AND (@m6='') AND (@m7='') AND (@m8='') AND (@m9='') AND (@m10=''))) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '') <> '' AND ((ti.item_desc 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,item_markup_1,ti.comp_id,i4c.item_id,ttn.tax_percentage*/ 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, ti.item_markup_1 * dbo.fnGetAStock(ti.comp_id,1,ti.item_id,99999999) DESC

    Tiempo Consumido: 00:00:00.1126677

    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_note like '%SMAX%' and brand_note2 like '%SMAX%' Order By brand_desc

    Tiempo Consumido: 00:00:00.0019935