Ordenar Mostrar

FILTRAR

Categoría:

SubCategoría:

Marca:

product

Combo Mouse+Pad MARVO G928+G1 7 LED 3200 DPI

Conexión:USB, Mouse: DPI: 800-1200-2400-3200, Velocidad: 125Hz, RGB: 7 Colores, Pad: 287 x 244 x 3mm

Código: G928-G1

USD 10.18 +IVA (10.50%)

product

Combo Teclado+Mouse MARVO KM408 3 LED SP

Teclado de teclas:104, Tipo de tecla: Membrana, Resolución del Mouse: 800-1200-1600-2400DPI, Mouse de 6 botones, RGB 7 C

Código: KM408

USD 12.28 +IVA (10.50%)

product

Combo Teclado+Mouse+Pad MARVO KM400 G1 3 LED SP

Teclado de teclas:114, Tipo de tecla: Membrana, Res. del Mouse: 800-1200-1600-2400DPI, Mouse:6 botones, RGB:7 Colores,Pa

Código: KM400-G1 SP

USD 17.46 +IVA (10.50%)

product

Mouse MARVO G914 Overwatch 4000 DPI RGB

Conexión:USB, Mouse: DPI: 1000-2000-3000-4000, Velocidad:hasta 1000Hz, Led: RGB, Botones: 6

Código: G914

USD 20.52 +IVA (10.50%)

product

Teclado MARVO K616 RGB SP

Conexión: USB, Teclado de teclas:104, Tipo de tecla: Membrana, Diseño:Slim, Luz LED: Miztadearco iris de 3 colores

Código: K616

USD 9.33 +IVA (10.50%)

  • Primero
  • Anterior
  • 1
  • Próximo
  • Último
  •     Total: 5 | Página actual: 1




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

    Ws_ID: 44adcd0c-7ce0-46f7-8adf-67848d39e00b
    Page_Id: 5173fa01-6da7-402d-b30d-ca1f5e880834
    WSU_Id: -1
    Parámetros de la Página: CAT_ID=-1;S;SCA_ID=-1;BRAND_ID=138;BUS=;GBPWSTID=44adcd0c-7ce0-46f7-8adf-67848d39e00b;
    Cart Guid: deac0b3f-aa7d-4b27-b10d-2a19a0a7647a

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

    Comp_Id: 1
    Lang_Id: 2
    54.198.55.167
    * WebSite Designer *



    Tiempo Total de Proceso: 2 Segundos.



    Ultimos SQL Ejecutados:


    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 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 = '-1'

    Tiempo Consumido: 00:00:00





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT SUBSTRING (subcataux_desc, 1, 50) [subcataux_desc] FROM TBSUBCATEGORYAUX WHERE subcataux_id = '-1'

    Tiempo Consumido: 00:00:00





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory WHERE subcat_id = ''

    Tiempo Consumido: 00:00:00





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT SUBSTRING (cust_name, 1, 25) FROM tbCustomer WHERE cust_id = -1

    Tiempo Consumido: 00:00:00





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT convert (decimal(16,2), dbo.fnGetExchange2('1', 1, 2,1, 0, 0, 0, 'False'))

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT CAT_ID, CASE WHEN cat_WebSite_desc <> '' THEN SUBSTRING (cat_WebSite_desc, 1, 50) ELSE SUBSTRING (cat_desc, 1, 50) END [cat_WebSite_desc] FROM TBCATEGORY WHERE CAT_WEB = 'TRUE' ORDER BY cat_web_order, cat_WebSite_desc, cat_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: CAT2
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT CAT_ID, CASE WHEN cat_WebSite_desc <> '' THEN SUBSTRING (cat_WebSite_desc, 1, 50) ELSE SUBSTRING (cat_desc, 1, 50) END [cat_WebSite_desc] FROM TBCATEGORY WHERE CAT_WEB = 'TRUE' ORDER BY cat_web_order, cat_WebSite_desc, cat_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCAT1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc],cat_id FROM tbSubCategory WHERE cat_id = 48 AND comp_id='1' AND subcat_web = 'TRUE' ORDER BY subcat_web_order,subcat_desc ASC

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCAT1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc],cat_id FROM tbSubCategory WHERE cat_id = 54 AND comp_id='1' AND subcat_web = 'TRUE' ORDER BY subcat_web_order,subcat_desc ASC

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCAT1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc],cat_id FROM tbSubCategory WHERE cat_id = 52 AND comp_id='1' AND subcat_web = 'TRUE' ORDER BY subcat_web_order,subcat_desc ASC

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCAT1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc],cat_id FROM tbSubCategory WHERE cat_id = 1 AND comp_id='1' AND subcat_web = 'TRUE' ORDER BY subcat_web_order,subcat_desc ASC

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCAT1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc],cat_id FROM tbSubCategory WHERE cat_id = 50 AND comp_id='1' AND subcat_web = 'TRUE' ORDER BY subcat_web_order,subcat_desc ASC

    Tiempo Consumido: 00:00:00.0156259





    GBP_LIST: CAT3
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT subcat_id, CASE WHEN subcat_WebSite_desc <> '' THEN SUBSTRING (subcat_WebSite_desc, 1, 50) ELSE SUBSTRING (subcat_desc, 1, 50) END [subcat_WebSite_desc] FROM tbSubCategory WHERE subcat_web = 'TRUE' ORDER BY subcat_web_order, subcat_WebSite_desc, subcat_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3856' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00.0156388





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3900' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3885' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3833' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3899' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3858' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3872' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3906' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3907' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3820' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3868' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3910' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3898' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3908' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3842' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3891' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3886' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3841' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3887' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3840' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3897' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3829' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3836' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3861' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3901' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3912' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00.0156262





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3857' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3909' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00.0156005





    GBP_LIST: SCATAUX1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id FROM tbSubCategoryAux a inner join tbitem i ON a.comp_id=i.comp_id AND a.subcataux_id=i.subcataux_id AND i.item_web='true' inner join tbSubCategory s ON s.comp_id=i.comp_id AND i.subcat_id=s.subcat_id AND i.item_web='true' WHERE s.subcat_id='3893' and a.subcataux_web='true' GROUP BY a.subcataux_id, a.subcataux_desc, s.subcat_id , s.cat_id, a.subcataux_web_order ORDER BY a.subcataux_web_order, a.subcataux_desc

    Tiempo Consumido: 00:00:00





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 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





    GBP_LIST: LISTCAT
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('138') =1) BEGIN SET @brand_id = CAST('138' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @scat_id = CAST('' 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 tbCategory.cat_desc AS s, tbCategory.cat_id AS cat_id, COUNT(tbItem.item_id) AS Cantidad, @scat_id AS subCategoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbCategory ON tbItem.comp_id = tbCategory.comp_id AND tbItem.cat_id = tbCategory.cat_id WHERE 1=1 --AND tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation > 0 AND tbWebSiteII_ItemsData.prli_id = 6 AND tbItem.item_web = 1 AND tbWebSiteII_ItemsData.ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbCategory.cat_desc, tbCategory.cat_id, tbCategory.cat_web_order

    Tiempo Consumido: 00:00:00.0156005





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW IF (ISNUMERIC ('') <> 1 OR '' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT subcat_desc FROM tbSubCategory WHERE subcat_id= '' END

    Tiempo Consumido: 00:00:00





    GBP_LIST: LISTSCAT
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('138') =1) BEGIN SET @brand_id = CAST('138' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @scat_id = CAST('' 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, tbSubCategory.subcat_id AS subcat_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id AS Categoria, @sca_id AS subCategoriaAux, @brand_id AS Marca, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id INNER JOIN tbSubCategory ON tbItem.comp_id = tbSubCategory.comp_id AND tbItem.comp_id = tbSubCategory.comp_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.cat_id = tbSubCategory.cat_id AND tbItem.subcat_id = tbSubCategory.subcat_id AND tbItem.subcat_id = tbSubCategory.subcat_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation > 0 AND tbWebSiteII_ItemsData.ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' AND tbWebSiteII_ItemsData.prli_id = 6 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND tbItem.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbSubCategory.subcat_desc, tbSubCategory.subcat_id, tbSubCategory.subcat_web_order

    Tiempo Consumido: 00:00:00.0156271





    GBP_REPLACE:
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW IF (ISNUMERIC ('138') <> 1 OR '138' = '-1') BEGIN SELECT 'Todas' END ELSE BEGIN SELECT brand_desc FROM tbBrand WHERE brand_id= '138' END

    Tiempo Consumido: 00:00:00





    GBP_LIST: LISTSMARCA
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' IF (ISNUMERIC ('138') =1) BEGIN SET @brand_id = CAST('138' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @scat_id = CAST('' 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 tbBrand.brand_desc, tbBrand.brand_id, COUNT(tbItem.item_id) AS Cantidad, @cat_id as Categoria, @scat_id AS Subcategoria, @sca_id AS SubcategoriaAux, @busqueda as BUSQUEDA FROM tbItem INNER JOIN tbBrand ON tbItem.comp_id = tbBrand.comp_id AND tbItem.brand_id = tbBrand.brand_id INNER JOIN tbWebSiteII_ItemsData ON tbItem.comp_id = tbWebSiteII_ItemsData.comp_id AND tbItem.item_id = tbWebSiteII_ItemsData.item_id WHERE 1 = 1 --tbWebSiteII_ItemsData.itst_LastAvailableInRelalculation > 0 AND tbWebSiteII_ItemsData.ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' AND tbWebSiteII_ItemsData.prli_id = 6 AND tbItem.item_web = 1 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND tbItem.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND tbItem.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND tbItem.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND 1 <> 1 )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((tbItem.item_desc like '%' + @busqueda + '%') OR (tbItem.item_WebSite_desc like '%' + @busqueda + '%') OR (tbItem.item_annotation1 like '%' + @busqueda + '%') OR (tbItem.item_annotation2 like '%' + @busqueda + '%') OR (tbItem.item_descHTML like '%' + @busqueda + '%') OR (tbItem.item_vendorCode like '%' + @busqueda + '%') OR (tbItem.item_Code like '%' + @busqueda + '%')))) GROUP BY tbBrand.brand_desc, tbBrand.brand_id ORDER BY Cantidad DESC

    Tiempo Consumido: 00:00:00.0312241





    GBP_LIST: SPOTS1
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW SELECT imageName, URL FROM vwWebSiteII_Spots WHERE ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' and Type = 8

    Tiempo Consumido: 00:00:00





    GBP_LIST: LISTA_ARTICULOS
    SET LOCK_TIMEOUT 800 SET DEADLOCK_PRIORITY LOW DECLARE @order AS INT DECLARE @brand_id AS INT DECLARE @scat_ID AS INT DECLARE @sca_ID AS INT DECLARE @cat_ID AS INT DECLARE @busqueda varchar(100) -- TOMA LAs VARIABLES DE LA URL SET @busqueda = '' SET @busqueda = replace(@busqueda, ' ','%') -- Agrega % a los espacios intermedios. IF (ISNUMERIC ('5') =3) BEGIN SET @order = CAST('5' AS INT) END ELSE BEGIN SET @order = 3 END IF (ISNUMERIC ('138') =1) BEGIN SET @brand_id = CAST('138' AS INT) END ELSE BEGIN SET @brand_id = -1 END IF (ISNUMERIC ('') =1) BEGIN SET @scat_id = CAST('' 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 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_WebSite_vendorDrivers, 1, 120), ti.item_newness, ti.item_liquidation, isnull(item_WebSite_vendorPage,'VACIO'), convert(nvarchar(20),convert(decimal(16,2), tpli.prli_price)) [price], tc.curr_symbol, tbr.brand_desc, CASE WHEN i4c.item_id = ti.item_id THEN 1 else 0 END [checkid], CASE WHEN i4c.item_id = ti.item_id THEN 'checked' else '' END [checked], CASE WHEN i4c.item_id = ti.item_id THEN 'Ver Comparacion' else 'Comparar' END [checked], convert (decimal(16,2), ttn.tax_percentage) [IVA], tbn.wssn_isNovelty, tbn.wssn_is4Sale FROM tbitem ti INNER JOIN tbWebSiteII_ItemsData tpli ON tpli.comp_id = ti.comp_id AND tpli.item_id = ti.item_id AND tpli.prli_id = 6 AND tpli.ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' 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 = 'deac0b3f-aa7d-4b27-b10d-2a19a0a7647a' LEFT JOIN tbWebSiteII_Items_NoveltyAnd4Sale tbn ON tbn.comp_id = ti.comp_id AND ti.item_id = tbn.item_id AND tbn.ws_id = '44adcd0c-7ce0-46f7-8adf-67848d39e00b' LEFT JOIN tbItemTaxes tit ON tit.item_id=ti.item_id AND tit.comp_id=ti.comp_id and tax_itemComposed = 0 LEFT JOIN tbTaxName ttn ON ttn.tax_id=tit.tax_id AND ttn.comp_id=tit.comp_id and ttn.tax_class=1 WHERE ti.item_web = 'true' --and tpli.itst_LastAvailableInRelalculation > 0 AND ((ISNULL(@cat_id, -1)=-1 AND 1=1 )OR(ISNULL(@cat_id, -1)<>-1 AND ti.cat_id=@cat_id )) AND ((ISNULL(@scat_id, -1)=-1 AND 1=1 )OR(ISNULL(@scat_id, -1)<>-1 AND ti.subcat_id=@scat_id )) AND ((ISNULL(@sca_id, -1)=-1 AND 1=1 )OR(ISNULL(@sca_id, -1)<>-1 AND ti.subcataux_id=@sca_id )) AND ((ISNULL(@brand_id, -1)=-1 AND 1=1 )OR(ISNULL(@brand_id, -1)<>-1 AND ti.brand_id = @brand_id )) AND ((ISNULL(@busqueda, '')='' AND 1=1 ) OR (ISNULL(@busqueda, '')<>'' AND ((ti.item_desc like '%' + @busqueda + '%') OR (ti.item_WebSite_desc like '%' + @busqueda + '%') OR (ti.item_annotation1 like '%' + @busqueda + '%') OR (ti.item_annotation2 like '%' + @busqueda + '%') OR (ti.item_descHTML like '%' + @busqueda + '%') OR (ti.item_vendorCode like '%' + @busqueda + '%') OR (ti.item_Code like '%' + @busqueda + '%')))) 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,ti.item_annotation2,ti.item_WebSite_vendorDrivers, item_newness,item_liquidation,item_WebSite_vendorPage,prli_price,curr_symbol,item_markup_1,ti.comp_id,i4c.item_id,ttn.tax_percentage, tbn.wssn_isNovelty, tbn.wssn_is4Sale 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.0624792